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

From: MV1 <bpremote1_at_bpremote1.mv.com>
Date: Wed, 1 Dec 1999 16:09:49 -0500
Message-ID: <8242rm$msk$1@pyrite.mv.net>

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

Alan E. Vervaeke
Oracle Certified Professional

Serguei Stroganov <sergueis_at_ottawa.com> wrote in message news:38458895.6FC44D5A_at_ottawa.com...
> Hi guys,
>
> I know almost nothing Oracle insides (C++|Java developer). I needed to
> create dump file with two sample tables. According to Oracle manual of
> Export utility, I run CATALOG.SQL script in sqlplus.exe (maybe, using
> system/manager account), then made dump file (it went fine). After that
> all tables in all schemas became unaccessable. The error messages are
> "insuffisient privileges" or "table/view does not exist".
>
> What the problem? How to fix it?
Received on Wed Dec 01 1999 - 15:09:49 CST