-
but really the question - how can i tell what databases are on my server, only arises when it isn't properly managed. Or you have taken over management and not got any docs or anyone who knows
-
-
I know this is not sql but in unix, you could do a
ps -ef |grep oracle - this will show all the oracle database processes running
or even still
ps -ef |grep smon
-
and 2 of my databases are shut down - but they are still there?
Or I could even have an instance but no database
-
Can we all agree that if we were required to use SQLPLUS ONLY to determine the databases on a system, we'd ask for our coat and hat.
(and recommend they use sql server?)
Maybe we should just let this thread unravel. It was good, stimulating thought.
-
deal
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|