-- Step 1: Collect the file locations for control, redo log, and data files:
-- Step 2: Check file permission
Select 'Control Files: '||value from v$parameter where name= 'control_files';
Select 'Control Files: '||value from v$parameter where name= 'spfile';
select 'Logfile: '||member from v$logfile;
select 'Datafile: '||name from v$datafile;
Want to post your scripts here in this blog ? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment