Hi Theresa,

What I did on the same situation is to create the same structure for the destination table first, and then I applied HINTS to do the job... as follow:
insert /*+ APPEND PUSH_SUBQ*/ into {DEST_TABLE} SELECT * FROM {SRC_TABLE}

As my experience, sometimes such a query will save you a lot of times.
Hope it helps,

MinhTD
----- Original Message -----
From: "Steele Theresa " <oracledba-ezmlmshield-x73641496.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, August 30, 2007 2:39 AM
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
>
>
>
>

Oracle LazyDBA home page