copy a table in oracle 1

[joeythelips]

Hi,

I want to copy a whole table and its contents.

Can i do this in sqlplus?

I need the copy for testing purposes.

 

[THoey]

Try this:

CREATE TABLE MyTable2 AS
SELECT * FROM MyTable1; Terry M. Hoey

 

[alexhu]

Don't do this if you have default values set in any column as they are not carried across. Also this will not work if you have LONG columns.

Alex

 

[carp]

Also, triggers, indexes, and constraints (except NOT NULL) will not be copied.