Home » RDBMS Server » Server Administration » compare db objects and syn missing objects in target database ( database)
compare db objects and syn missing objects in target database [message #581848] Thu, 11 April 2013 04:44
Messages: 2
Registered: March 2012
Junior Member

I need your help. I had an requirement to compare db objects from QA instance to Stage instance, find out missing objects and syn up the databases. Import was done by DBA at our work location using impdp command as below. Only metadata was imported from QA to STG instance. After import few of db objects like materialized views, tables, triggers, package, procedure , views and indexes........are missing. I had a requirement to compare db objects and syn up the objects in schemas in two databases based on last_ddl executed. But there are around 100+ schemas with 1000's of db objects. What was the best and preferable way to compare and could some one explain me the process.

impdp system/xxxx dumpfile=dmp.dmp logfile=impdp.log CONTENT=METADATA_ONLY TRANSFORM=SEGMENT_ATTRIBUTES:n

I had used TOAD to compare the db objects but cannot compare schemas as i am looking for a output comparison based on last ddl executed.

There are custom schemas.

How can we compare custom schemas and seeded schemas using dbms metadata.get_ddl API...

Can we compare db objects based on last_ddl_time?

Previous Topic: Setting up UTL_MAIL
Next Topic: Grid control installation
Goto Forum:

Current Time: Sun Feb 18 13:13:09 CST 2018

Total time taken to generate the page: 0.00988 seconds