Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create same table (all constraints)

427828Dec 19 2006 — edited Mar 17 2007

Hi all
I have a table and I want to duplicate this table. Including all constraints...
I used
create table new_table as
select * from old_table

I created this table, but there's no constraints...

Thanks...

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2007

Added on Dec 19 2006

#general-database-discussions

13 comments

952 views