dba_constraints script

[st2000]

Hello DBAs:

I have a production system with all constraints required on the system and want to duplicate the effort in Development system.

I am looking for a script that can extract code "alter table" statements from Production. I am looking for only Primary and Foreign key constraints and not Check and not null constraints..

I am looking into dba_constraints and dba_cons_cols to achieve this, but if anyone has more ideas, would appreciate it..

Thanks, ST2000

~

[davey23uk]

version of oracle?

dbms_metadata might help you if on 9i

[st2000]

I am on 8i and I need a script to extract data..

Thanks, ST2000

[pando]

use export/import

[st2000]

Pando, I want to know what are the constraints that are not existing in DEV but exists in Production.. Also there could be some tables in production that are not in dev and vice-versa..

Thanks, ST2000

[pando]

create db link between them and compare

[hrishy]

Hi

Go www.google.com and serach and download a nifty tool called oracompare.com.It does exactly what you are asking for.

regards
Hrishy

[st2000]

Pando.. I am NOT only looking for the script to compare betn the Prod and Dev.

I will create DB links in the process.. DB Links only gives me access to the other database from one environment and with a select, I can list the differences between the tables, I can use outer join, but i am looking for a script to generate "alter table add constraints" from selecting from the 2 databases.... (select statement concatinating with alter ....)

Thanks, ST2000

[SANJAY_G]

http://metalink.oracle.com/metalink/...X&id=1016836.6

[st2000]

Thanks Sanjay.. This script is all in one.. I shall start on this..

ST2000