OraFAQ Forum: Client Tools » create table with tablespace giving error

Home » Other » Client Tools » create table with tablespace giving error

Wed, 11 March 2009 16:18

ora1980
Messages: 251
Registered: May 2008

Senior Member

I have an sql file creating table with tablespace..

drop table example
/


CREATE TABLE example
(
  xyz number,
  mycode           VARCHAR2(50 ))

TABLESPACE MISC_DATA;

 
/

i get following error
SP2-0734: unknown command beginning "TABLESPACE..." - rest of line ignored.

Wed, 11 March 2009 16:45

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Get rid of the empty lines between the commands.

Previous Topic:	ora12154 - error
Next Topic:	SQL Navigator

Goto Forum:

]

Current Time: Thu Apr 18 18:05:58 CDT 2024