creating a table same as table in another schema along with constraints
SudhirAug 21 2008 — edited Aug 21 2008hi,
1. I need to create a table x same as table y in operapps schema along with data and constaints.
2. i am having 3 schema one apps,two operapps,three oper,
in operapps i have created a table x same as y along with data
as create table x as select * from apps.y .but in this i am not getting the constraints that are existing on y in apps schema.
i have created a foreign key reference to another table in schema oper
as
ALTER TABLE OPS_BR_VENDORS ADD ( FOREIGN KEY (VENDOR_ID) REFERENCES operapps.x (VENDOR_ID));
on regular weekly basis the data in x is updated from y using batch.
is there any problem for the table oper.ops_br_vendors.
as security concerns we are not able to create foreign key directly on apps.y
Please advice,