Home sql table_spaces

Step 1. SQL Script to Check Table Spaces

---

1. Check Table Owners ...
   SELECT owner,COUNT(*) FROM all_tables GROUP BY owner ;
2. Check Table Names by Owner ...
   (HINT : Select only those for the Application)
   SELECT owner,Table_name FROM all_tables ORDER BY owner,Table_name ;
3. 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 ;

  ---

  [ Home Page | Search & Site Map | What's New ]

  ---

  <!-- End of Standard Footer>