Use nologging also


Regards

Somaraju.I
Oracle DBA
Infotech Enterprises Limited
Ext :530, Cell # : 98494 20302


-----Original Message-----
From: Mahapatra Himanshu (*IC)
[mailto:oracledba-ezmlmshield-x28310374.[Email address protected]
Sent: Thursday, August 30, 2007 2:41 PM
To: LazyDBA Discussion
Subject: RE: create tbl as select *



Create table <New Table_name> as select /*+ parallel(a,8) */ * from
table_1 a unrecoverable;

Thanks & Regards,
Himanshu Mahapatra
Oracle DBA
Warner Bros Entertainment UK Ltd

-----Original Message-----
From: Steele Theresa
[mailto:oracledba-ezmlmshield-x73641496.[Email address protected]
Sent: 29 August 2007 20:40
To: LazyDBA Discussion
Subject: create tbl as select *

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.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page