how to take backup of a table including constraints
469832May 10 2006 — edited May 10 2006Hi All,
I have got a table A with 200 columns, many of them as FK.
I have to take backup of this table including the constraints settings for all the tables.
If i use
create table B as select * from A
In the script of this table B i found that no constraints have been created as they weere in table A except not null.
How can i also get them.
Also how on oracle 8i can i see the DDL of create table A from sql* plus as i don't have dbms_metadata there.
Regards