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