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_at_ottawa.com>
Date: Wed, 01 Dec 1999 21:43:05 GMT
Message-ID: <38459597.EF33CB5_at_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 - 22:43:05 CET