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

Thread: finding db

  1. #1
    Join Date
    Feb 2001
    Posts
    23
    hello again

    i have 2 database in my oracle
    is there a way of checking both database in sql/plus in one command...if there is ...pls let me know
    or any other way...

    thank you guys for your help

  2. #2
    Join Date
    Feb 2001
    Posts
    83
    In one command , u can't check both the DB's. U have to connect using service name to connect to a particular DB.

    If u need to view two databases at a time, u open two different command windows (NT env)and connect to different db using service name.
    with regards
    Prasanna S

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    If you get to create a cross dblink between the databases, then you can run the sql to check one database from the other, without loosing the currently connected database.

    Hope this would help you,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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