Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.18 DBA_ALL_TABLES

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.18 DBA_ALL_TABLES

The DBA_ALL_TABLES view provides information about all tables in the database.

Name

Type

Description

owner

VARCHAR2

User name of the table’s owner.

schema_name

VARCHAR2

Name of the schema in which the table belongs.

table_name

VARCHAR2

Name of the table.

tablespace_name

VARCHAR2

Name of the tablespace in which the table resides if other than the default tablespace.

status

VARCHAR2

Included for compatibility only; always set to VALID.

temporary

TEXT

Y if the table is temporary; N if the table is permanent.

Previous PageTable Of ContentsNext Page