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 scott/[Email Address Removed] <mailto:scott/[Email Address Removed]
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 [mailto:oracledba-ezmlmshield-x73641496.[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