Re: Retrieving table name from a user scheam

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 2000/05/26
Message-ID: <8gkcps$1r8$1@perki.connect.com.au>#1/1

There are few tables that you can get the details from. tab

TNAME                           NOT NULL VARCHAR2(30)
TABTYPE                                  VARCHAR2(7)
CLUSTERID                                NUMBER

All_objects

OWNER                           NOT NULL VARCHAR2(30)
OBJECT_NAME                     NOT NULL VARCHAR2(30)
SUBOBJECT_NAME                           VARCHAR2(30)
OBJECT_ID                       NOT NULL NUMBER
DATA_OBJECT_ID                           NUMBER
OBJECT_TYPE                              VARCHAR2(18)
CREATED                         NOT NULL DATE
LAST_DDL_TIME                   NOT NULL DATE
TIMESTAMP                                VARCHAR2(19)
STATUS                                   VARCHAR2(7)
TEMPORARY                                VARCHAR2(1)
GENERATED                                VARCHAR2(1)
SECONDARY                                VARCHAR2(1)


All_tables
 OWNER                           NOT NULL VARCHAR2(30)
 TABLE_NAME                      NOT NULL VARCHAR2(30)
 TABLESPACE_NAME                          VARCHAR2(30)
 CLUSTER_NAME                             VARCHAR2(30)
 IOT_NAME                                 VARCHAR2(30)
 PCT_FREE                                 NUMBER
 PCT_USED                                 NUMBER
 INI_TRANS                                NUMBER
 MAX_TRANS                                NUMBER
 INITIAL_EXTENT                           NUMBER
 NEXT_EXTENT                              NUMBER
 MIN_EXTENTS                              NUMBER
 MAX_EXTENTS                              NUMBER
                AND MORE

SP <spant1_at_aol.com> wrote in message
news:iRfX4.100$Qf6.3530_at_nuq-read.news.verio.net...
> Can anyone suggest me the syntax to select table name from a user schema?
>
> Sp
>
>
Received on Fri May 26 2000 - 00:00:00 CDT