Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> lost table name

lost table name

From: Jerry Preston <g-preston1_at_ti.com>
Date: Wed, 12 Feb 2003 22:38:30 -0600
Message-ID: <b2f7da$m4o$1@tilde.itg.ti.com>


Hi!

I am trying to get the table name.

I have ran sql in sqlplus on the server the oracle 7.1.3 is installed:

 select table_name from all_tables;

I get the following:

TABLE_NAME



DUAL
SYSTEM_PRIVILEGE_MAP
TABLE_PRIVILEGE_MAP
STMT_AUDIT_OPTION_MAP
AUDIT_ACTIONS
PSTUBTBL
USER_PROFILE
ROSSTRINGS
ROSLFDESC
ROSTFDESC
ROSOBJMAP TABLE_NAME

ROSSEQUENCES I have looked under oracle/oradata/xxx/rbs and found rbs01.dbf.

Any ideas on how I can find the owner and tables for the oners?

Thanks,

Jerry Received on Wed Feb 12 2003 - 22:38:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US