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: Droping System User

RE: Droping System User

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 04 Oct 2001 13:44:44 -0700
Message-ID: <F001.003A2819.20011004134702@fatcity.com>

No such thing as DBA_ tables. :-)

SQL> select obj#, name
  2  from sys.obj$
  3  where name like 'DBA\_%' escape '\'
  4  and type# = 2 ;

aucune ligne sélectionnée

-----Original Message-----
From: Christopher Spence [mailto:cspence_at_FuelSpot.com]

The DBA_ tables are owned by SYS.
 
But a lot of features such as AQ and such use objects owned by SYSTEM. Received on Thu Oct 04 2001 - 15:44:44 CDT

Original text of this message

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