Thank you everyone for the many alternative
ways of solving this problem. . .

Theresa

-----Original Message-----
From: Todd Pepling [mailto:[Email address protected]
Sent: Thursday, August 30, 2007 11:52 AM
To: Steele, Theresa
Subject: RE: create tbl as select *

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


COPY command is used to copy data from one table to another table
(destination table can be in the same database or another database).
Following is an example of copying data from one table to another table
in
the same database:

COPY FROM [Email address protected] [Email address protected]
CREATE STUDENT (STUDENT_ID, STUDENT_NAME)
USING SELECT ROLL_NO, NAME FROM STUDENTS
WHERE CLASS_ID= 12;

Todd Pepling
[Email address protected]
724-766-3492

________________________________

From: Steele Theresa [Email address protected]
Sent: Wed 8/29/2007 15:39
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






Oracle LazyDBA home page