Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.1 ALL_ALL_TABLES

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.1 ALL_ALL_TABLES

The ALL_ALL_TABLES view provides information about the tables accessible by the current user.

Name

Type

Description

owner

TEXT

User name of the table’s owner.

schema_name

TEXT

Name of the schema in which the table belongs.

table_name

TEXT

The name of the table.

tablespace_name

TEXT

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

temporary

TEXT

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

status

VARCHAR2

Included for compatibility only; always set to VALID.

Previous PageTable Of ContentsNext Page