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 TABLE A AS SELECT * FROM B (HOW TO SPECIFY TABLESPACE IN THIS SQL?)

60716Sep 27 2005 — edited Sep 27 2005

Hi All,

Pls addvice on how to specify TABLESPACE in the below statement

CREATE TABLE A
AS SELECT * FROM B

I want A to be created in TABLESPACE TS1

Thanks in advance
SV

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2005

Added on Sep 27 2005

#general-database-discussions

3 comments

663 views