28 июл. 2014 г.

on Leave a Comment

Display all Tables, Tablespaces in Database

How to display all Tables, Tablespaces in Database. Some examples:

At first you should connect to the Database:
 sqlplus username/password@database-name 
To display all tables owned by the current user:
 select tablespace_name, table_name from user_tables;
To display all tables in a database:
 select tablespace_name, table_name from dba_tables;
To list all tables accessible to the current user, type:
 select tablespace_name, table_name from all_tables;

Also You can find more info about views here: all_tablesuser_tables, and dba_tables in Oracle Documentation.

0 коммент.:

Отправить комментарий

Технологии Blogger.