Hi All-

What is an alternative way to
do: "create table as select * from table1;"?

Can anyone send me sample code?

The problem is table1 has 1.2 million rows.

I think doing the above will create a single, enormous
transaction that doesn't commit until the end.

Thanks in advance.

Theresa Corral-Steele

MDS Global Services
Sr. Oracle Database Administrator



This email and any files transmitted with it may contain privileged or confidential information and may be read or used only by the intended recipient. If you are not the intended recipient of the email or any of its attachments, please be advised that you have received this email in error and any use, dissemination, distribution, forwarding, printing or copying of this email or any attached files is strictly prohibited. If you have received this email in error, please immediately purge it and all attachments and notify the sender by reply email or contact the sender at the number listed.

Oracle LazyDBA home page