FilesExpand file tree

 master

/

dba_controlfiles.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

18 lines (13 loc) · 537 Bytes

 master

/

dba_controlfiles.sql

Copy path

Top

File metadata and controls

• Code
• Blame

18 lines (13 loc) · 537 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

-- | PURPOSE : Query all control files from the database. |

-- | NOTE : As with any code, ensure to test this script in a development |

-- | environment before attempting to run it in production. |

-- +----------------------------------------------------------------------------+

SET PAGESIZE 9999

COLUMN name FORMAT A45 HEADING "Controlfile Name"

COLUMN status HEADING "Status"

SELECT

name

, LPAD(status, 7) status

FROM v$controlfile

ORDER BY name

/