SQL+: Oracle Control Tables

Oracle Certification, Database Administration, SQL, Application, Programming Reference Books SQL⁺: Oracle Control Tables

Internally, Oracle keeps its data catalog in the form of tables. There are quite a number of these tables. The following are some that might be useful for you.

Some Useful Control Tables:

User_Catalog: user table catalog (e.g., table name, type --table, view)
User_Tables: table detail (e.g., Identification, Space, Statistics-related)
User_Views: views detail
User_TS_Quotas: space allocation
User_Users: your account information
User_Sys_Privs: your privilege

You can use 'describe' to show the structures of these tables and use 'select' to view their contents.

Exit to : Oracle Hints and Tips