Home
sql scripts
check table owners
Database Answers SQL Scripts
Step 1. SQL Script to Check Table Owners
Check Table Owners ...
SELECT owner,COUNT(*) FROM all_tables GROUP BY owner ;
Check Table Names by Owner ...
(HINT : Select only those for the Application)
SELECT owner,Table_name FROM all_tables ORDER BY owner,Table_name ;
Generate SQL to check Row Counts for all Tables ...
SELECT owner,Table_name FROM all_tables WHERE owner='identified above' ORDER BY owner,Table_name ;
Optionally check Table names & Table Spaces...
SELECT table_name, tablespace_name FROM user_tables ORDER BY table_name,tablespace_name ;
Check Table Spaces & Table Names...
SELECT tablespace_name, table_name FROM user_tables ORDER BY tablespace_name, table_name ;
sql scripts
check table owners
sql scripts
check table owners
