Home » SQL & PL/SQL » Client Tools » create table with tablespace giving error
create table with tablespace giving error [message #391321] Wed, 11 March 2009 16:18 Go to next message
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.
Re: create table with tablespace giving error [message #391322 is a reply to message #391321] Wed, 11 March 2009 16:45 Go to previous message
ThomasG
Messages: 3189
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: Wed Dec 07 09:04:33 CST 2016

Total time taken to generate the page: 0.08568 seconds