Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: create one view to control tables or columns

    I have 2 instances oracle 'MYDB' and 'DBX' with 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 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
    Jan 2004
    Location
    North Haven, CT
    Posts
    110

    Re: create one view to control tables or columns

    this link might help
    http://asktom.oracle.com/pls/ask/f?p...:941629680330,

    Originally posted by raf
    I have 2 instances oracle 'MYDB' and 'DBX' with 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 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!

Posting Permissions

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