DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Hybrid View

  1. #1
    Join Date
    Jan 2003

    Reference table.


    I have to transfer a oracle 8i database to another machine.
    Recreation of all tables/views/users ...

    There is a problem this database acts as a reference DB, so other db's are connected and they have views/synonyms on this DB.

    How can I see which table/views are used by other DB, without checking every DB?
    So that I also can recreate these views/synonyms.

    Kind Regards,


  2. #2
    Join Date
    Jan 2002
    Up s**t creek
    If the hardware platform you are moving to is the same there should be no problem with this. Do you keep the reference DB open 24/7 or do you have a predefined window to close it down for backups/maintainance. If so you should be able to move it and simply update the additonal servers with the new tns alias.

    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jan 2003
    We will take the proccessing down, and there both HP-UNIX systems.


    You have a table on machine A.
    Machine B as a view on that table on machine A.

    Is there a way to see only at machine A that there 's a view on machine B?

    Last edited by wstroop; 01-09-2003 at 09:24 AM.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.