Compare and Sync the database objects in two different databases
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Compare and Sync the database objects in two different databases

  1. #1
    Join Date
    Sep 2010
    Posts
    1

    Compare and Sync the database objects in two different databases

    Hi,

    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...


    Thanks,
    Dinesh

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Cool

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width