DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002

    create one view to control tables or columns

    I have 2 instances oracle 'MYDB' and 'DBX' with table's owner 'TOM'

    I'd like to control all the tables and all the columns in order to verify that they are equal in both instances.

    I tried this query on a single instance:

    select owner, table_name, column_name, data_type, data_length, data_precision, nullable, data_default
    from dba_tab_columns
    where owner='TOM'
    order by table_name

    I get more 4000 records.

    but in order to control all the tables in this way are much laborious one.

    Can I create one view o query on both instance to control the table (or col) differences?

    Must I create a dblink?

    Thanks in advance!

  2. #2
    Join Date
    Mar 2001
    See attachement
    Attached Files Attached Files
    Best wishes!

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

By using this site, you agree to the Privacy Policy