Getting Information on Tables

You can get information about your tables by

• Performing a DESCRIBE command on the table.
• Querying the user_tables view.

Some of the columns in the user_tables view:

Column	Type	Description
table_name	VARCHAR2(30)	Name of the table.
tablespace_name	VARCHAR2(30)	Name of the tablespace
temporary	VARCHAR2(1)	Whether the table is temporary.

SQL> SELECT table_name, tablespace_name, temporary
  2  FROM user_tables
  3  WHERE table_name IN ('MYTABLE');

TABLE_NAME                     TABLESPACE_NAME                T
------------------------------ ------------------------------ -
MYTABLE                                                       Y

SQL>