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
Printable View
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
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,
Sam