Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> create table as select * takes one commit?
I am looking into ways to copy a 10GB table. A easy way is to do:
create tableb as select * from tablea;
or
create tableb as select /*+ APPEND +/ * from tablea;
Is it the same as DML that goes into rollback segment? I don't have 10GB of rbs and I don't want to increase my rbs just to do this.
Also, if I want to use the APPEND hint, do I need to say "insert /*+ APPEND */..." or I can simply do "create table /*+ APPEND */ ? What's the difference?
Thanks in advance.
ewong Received on Sun Apr 21 2002 - 02:16:38 CDT
![]() |
![]() |