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: Urgent! Need rollback/recover after running CATALOG.SQL

Re: Urgent! Need rollback/recover after running CATALOG.SQL

From: Serguei Stroganov <sergueis_at_ottawa.com>
Date: Wed, 01 Dec 1999 21:43:05 GMT
Message-ID: <38459597.EF33CB5@ottawa.com> 





> CATALOG.SQL needs to be run as SYS - NOT System !!


> Since System actually owns no tables, I would re-run CATALOG.SQL as SYS and


> drop all objects owner by SYSTEM and then run CATDBSYN as SYSTEM





How to "drop all objects owner by SYSTEM"?



Will the whole system restore access to other users' tables/objects?
Received on Wed Dec 01 1999 - 15:43:05 CST












Original text of this message













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