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

Home -> Community -> Usenet -> c.d.o.server -> Re: Question about SQL Plus and Net 8 Assistant

Re: Question about SQL Plus and Net 8 Assistant

From: Antoine Brunel <antoinebrunel_at_yahoo.fr>
Date: Fri, 21 May 1999 10:57:58 +0200
Message-ID: <7i3733$e9a$1@minus.oleane.net>


>4. I connected to the SQL Plus in NORMAL mode to create a table. But
>when I connected as SYSDBA next time and issue "desc table_name", why
>does it say that there is no such table.

Connecting as INTERNAL, as sysdba or sysoper place you in the SYS schema. You muse call your object with owner.obejct, or create a public synomym or view to access it. Received on Fri May 21 1999 - 03:57:58 CDT

Original text of this message

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