Map Oracle to Information Schema

less than 1 minute read

How to map Oracle DBA tables to an Information Schema.

Overview

Schemata:

SELECT DISTINCT OWNER
FROM ALL_OBJECTS
WHERE OWNER NOT LIKE '%SYS'

Base Tables:

SELECT * 
FROM ALL_TABLES
WHERE OWNER NOT LIKE '%SYS'

Views:

SELECT * 
FROM ALL_VIEWS
WHERE OWNER NOT LIKE '%SYS'

Columns:

SELECT * 
FROM ALL_TAB_COLUMNS
WHERE OWNER NOT LIKE '%SYS'

Routines:

SELECT * 
FROM ALL_PROCEDURES
WHERE OWNER NOT LIKE '%SYS'

QED

19 August 2024