Re: How to check Table's Owner

There is a table called ALL_TABLES. Here are its columns:

SQL> desc all_tables

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL CHAR(30)
 TABLE_NAME                      NOT NULL CHAR(30)
 TABLESPACE_NAME                 NOT NULL CHAR(30)
 CLUSTER_NAME                    NOT NULL CHAR(30)
 PCT_FREE                        NOT NULL NUMBER
 PCT_USED                        NOT NULL NUMBER
 INI_TRANS                       NOT NULL NUMBER
 MAX_TRANS                       NOT NULL NUMBER
 INITIAL_EXTENT                           NUMBER
 NEXT_EXTENT                              NUMBER
 MIN_EXTENTS                     NOT NULL NUMBER
 MAX_EXTENTS                     NOT NULL NUMBER
 PCT_INCREASE                    NOT NULL NUMBER
 BACKED_UP                                CHAR(1)

Richard

In article <4aiqg3$1lh_at_news.csus.edu>, wchow_at_sfsu.edu (Walter Chow) writes:
|> Hi,
|>
|> Is there a way that I can check who is the owner of a
|> table? Thank you very much.
|>
|> wchow_at_apollo.sfsu.edu

-- 
Richard G. Ramirez, Ph. D.
Assistant Professor of MIS
Iowa State University