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: 3212
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: Fri Feb 07 00:14:26 CST 2025