Home » SQL & PL/SQL » SQL & PL/SQL » Tablespace (SQL)
Tablespace [message #583007] Wed, 24 April 2013 14:25 Go to next message
RCaballero1
Messages: 1
Registered: April 2013
Location: Los Angeles
Junior Member

create table TEST(
fld1_1 varchar(4) not null,
fld2_2 varchar(6) not null,
fld3_3 varchar(2) not null,

) tablespace fld_data;

grant select,insert,update,delete on TEST to public;

alter table TEST
add constraint TEST_pk primary key (fld1_1)
using index tablespace fld_indx;

What am I doing wrong?
Re: Tablespace [message #583008 is a reply to message #583007] Wed, 24 April 2013 14:33 Go to previous messageGo to next message
Littlefoot
Messages: 19335
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, it would help if you said what happened when you executed those statements.
Re: Tablespace [message #583009 is a reply to message #583008] Wed, 24 April 2013 14:48 Go to previous messageGo to next message
BlackSwan
Messages: 22527
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>What am I doing wrong?
I have no idea what is wrong with you.
Are you abusing Oracle while not qualified to issue SQL?
Re: Tablespace [message #583010 is a reply to message #583009] Wed, 24 April 2013 14:55 Go to previous messageGo to next message
BlackSwan
Messages: 22527
Registered: January 2009
Senior Member
>create table TEST(
>fld1_1 varchar(4) not null,
>fld2_2 varchar(6) not null,
>fld3_3 varchar(2) not null,
>) tablespace fld_data;

SQL above fails due to extraneous comma on the right end of fld3_3 line;
but I suspect this is NOT the real issue.
Re: Tablespace [message #583028 is a reply to message #583007] Thu, 25 April 2013 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 58618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Welcome to the forum.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals.

Use SQL*Plus and copy and paste your session.

Regards
Michel
Re: Tablespace [message #583043 is a reply to message #583007] Thu, 25 April 2013 02:25 Go to previous message
ashwani0301
Messages: 44
Registered: March 2013
Location: Karnatka, Bangalore
Member
Hi RCaballero1,

Quote:
using index tablespace fld_indx


looking no error, but do you have fld_indx created in your database ??

Thanks
Previous Topic: Compilation Error in Procedure
Next Topic: difference between oracle 9i and 10g
Goto Forum:
  


Current Time: Wed Jul 30 09:37:41 CDT 2014

Total time taken to generate the page: 0.13197 seconds