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
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.
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,
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width