Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create Sequences under TABLESPACE

401103Nov 8 2003 — edited Nov 10 2003

Hi all,

I have created a new tablespace TEST which wrks fine.
When i create a table i just add an suffix TABLESPACE TEST and this wrks fine.

But when i create an SEQUENCE
Create Sequence seq start with 1 TABLESPACE TEST. Its shows an error but again Create Sequence seq start with 1 wrks as it is saved under default TABLESPACE.

How can i overcome this as i wanted it to be created under TABLESPACE TEST.

Also when i create TRIGGER/INDEXES/CONTRAINTS ON Tables which r under TABLESPACE TEST they all r created under TABLESPACE TEST only.

Rgds
Lalit

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2003

Added on Nov 8 2003

#general-database-discussions

6 comments

3,080 views