Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: lost table name
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 AllenReceived on Wed Feb 12 2003 - 23:42:12 CST