any suggestions on how to create a table from a select without its constraints??? i have the following :

create table int_segurohogar_BAK as (select * from int_segurohogar where 1=2);

it creates the table but creates NOT NULL constraints on all the columns, not exactly as the NOT NULL constraints from the original table. How can i avoid creating this constraints????

thank you very much for your support.

regards,

dgc

05-02-2006, 12:31 PM

davey23uk

create the table as you want it, then insert /*+APPEND*/ into ....

05-02-2006, 12:56 PM

dgcampos

Quote:

Originally Posted by davey23uk

create the table as you want it, then insert /*+APPEND*/ into ....

what do you mean by that? i want to create the table from a select without the NOT NULL constraints, APPEND hit only affects the watermark point when inserting. is it possible to disable the constraints after the create table statement? im trying with this with little result :