Re: [suse-oracle] Help : how to rebuild the catalog on oracle9i

From: Harald Maier (maierh@myself.com)
Date: Tue Sep 23 2003 - 05:09:28 CEST

Next message: harry302: "[suse-oracle] getting oracle 8i for class"
Previous message: Hollis, Les: "RE: [suse-oracle] Help : how to rebuild the catalog on oracle9i"
In reply to: German Amaro: "[suse-oracle] Help : how to rebuild the catalog on oracle9i"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

From: Harald Maier <maierh@myself.com>
Date: Tue, 23 Sep 2003 05:09:28 +0200
Message-ID: <m38yogtd3r.fsf@ate.maierh>
Subject: Re: [suse-oracle] Help : how to rebuild the catalog on oracle9i

"German Amaro" <german_sin@hotmail.com> writes:

> Hi,
> it is possible to rebuild the catalog(or something ) to rescue the
> data dictionary?.
> my database is oracle9ir2.
>
> I ran the catalog.sql after my database was created(i thought it was
> needed to do export) and i think it was the problem.
> i can do select but i cant do describe to any table, i get errors.

You need only the export/import tables. In this case run only:
,----
| SQL> @?/rdbms/admin/catexp.sql
`----

Harald

---------------------------------------------------------------------
To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
For additional commands, e-mail: suse-oracle-help@suse.com
Please see http://www.suse.com/oracle/ before posting

Next message: harry302: "[suse-oracle] getting oracle 8i for class"
Previous message: Hollis, Les: "RE: [suse-oracle] Help : how to rebuild the catalog on oracle9i"
In reply to: German Amaro: "[suse-oracle] Help : how to rebuild the catalog on oracle9i"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.7 : Tue Sep 23 2003 - 05:11:00 CEST