dba_constraints script

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

~

version of oracle?

dbms_metadata might help you if on 9i

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

Thanks, ST2000

use export/import

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

create db link between them and compare

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

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

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

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

ST2000