OraFAQ Forum: SQL & PL/SQL » creating a new table from another table

Home » SQL & PL/SQL » SQL & PL/SQL » creating a new table from another table (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

creating a new table from another table [message #440380]

Sat, 23 January 2010 01:29

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi all,

I am creating a new table test1 from the table test as below

create table test1 as select * from test;

Here the table is created and all the records have populated.
but the constraints and the primary key aren't created ,normally using above query it creates only NOT NULL columns in the table from one table to another table

My question:-
Is there is possible to create table using the above condition and also need to create all other objects like referential,primary keys etc...

Thanks in advance..

Report message to a moderator