|
-
Use this to identify all files:
select name from v$controlfile
union all
select member from v$logfile
union all
select name from v$datafile
union all
select name from v$tempfile;
Nobody seemed to mention v$tempfile.
And be careful with the listener. Some other DBs might be using it.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: [email protected]
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
|