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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SYS vs SYSTEM

Re: SYS vs SYSTEM

From: Stephane Faroult <sfaroult_at_oriole.com>
Date: Thu, 29 Nov 2001 10:34:42 -0800
Message-ID: <F001.003D0D38.20011129101030@fatcity.com>

"Van M. Etheridge" wrote:
>
> Hi Ken,
>
> My guess is that you need to set up sys.dba_all_tables with a public
> synonym.
>
> HTH
>
> Van
>
> -----Original Message-----
> Sent: Thursday, November 29, 2001 11:50 AM
> To: Multiple recipients of list ORACLE-L
>
> 8.1.7 on W2000
>
> select owner, table_name, tablespace_name from dba_all_tables;
>
> When I log into sqlplus as SYS is runs.
>
> When I log into sqlplus as SYSTEM I get the error table or view does not
> exit.
>
> What is happening here and how do I fix it?
>
> Thanks,
>
> Ken
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ken Janusz
> INET: ken.janusz_at_sufsys.com

More precisely, log in as SYSTEM and execute

@$ORACLE_HOME/rdbms/admin/catdbsyn

It creates private, not public, synonyms.

-- 
Regards,

Stephane Faroult
Oriole Corporation
Voice:  +44  (0) 7050-696-269 
Fax:    +44  (0) 7050-696-449 
Performance Tools & Free Scripts
--------------------------------------------------------------
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--------------------------------------------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Nov 29 2001 - 12:34:42 CST

Original text of this message

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