16Feb/100
Listing key Oracle Database files
To get a list of all datafiles, redo-log files and control-files, run the following in SQL*Plus (database must be mounted):
1 2 3 | SELECT MEMBER FROM V$LOGFILE; SELECT NAME FROM V$DATAFILE; SELECT VALUE FROM V$PARAMETER WHERE NAME = 'control_files'; |
An easier way of displaying your control-files is:
1 | SHOW PARAMETER control_files; |
Related posts: