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 -> Re: lost table name

Re: lost table name

From: Andrew Allen <ajallen_at_mailhost.det.ameritech.net>
Date: Thu, 13 Feb 2003 05:42:12 GMT
Message-ID: <3E4B21C4.171392A5@mailhost.det.ameritech.net>


Jerry Preston wrote:
>
> 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?
>

Login as system or any user with dba role and . . . select owner, table_name from dba_tables;

rbs01.dbf is a/the file upon which resides the rbs (rollback) tablespace. What is rollback? Read the book, any oracle book.

-- 
Andrew Allen
Received on Wed Feb 12 2003 - 23:42:12 CST

Original text of this message

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