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

From: Guang Ju YANG <yangg_at_club-internet.fr>
Date: Wed, 1 Dec 1999 22:27:23 +0100
Message-ID: <8243i7$8vk$1@front7.grolier.fr>

The catalog.sql must be run under sys account.

After that, you can create a user and give him severals righs as 'create session, create table' etc.

With the new user, you can make tests of your sample tables.

HTH.
Yang

Serguei Stroganov wrote in message <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:27:23 CST