Re: Full database import

Any objects belonging to SYS are not exported even with a full export. You have to precreate the database and run all the cat* scripts needed and then import.

Venkat

>export without a great deal of success.
>
>I created a database, with various tablespaces (ie rbs, tools, users,
>etc), added a few users with tables/views indexes etc. I then did a
>full database export.
>
>I then removed the database(all database files) and re-created it using
>the 'create database' command.
>I then ran the catalog.sql script.which also calls the catexp.sql script
>which is required for the import.
>
>I ran the import specifying 'full=y' and it sort of worked. A whole
>bunch of errors when trying to create dba_ synonyms, all_ synonyms,
>etc, as they had all ready been created from running catalog.
>
>It did import all the users objects, but then on entering sqlplus after
>the import had finished, I recieved the following errors.
>ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
>
>Error accessing package DBMS_APPLICATION_INFO
>ERROR:
>ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
>
>Maybe I should have run catproc also. But I assumed the import, imports
>all system objects and that I should not need to run catproc or catalog.
>
>Can anyone tell me the exact procedure for importing using the 'full=y'
>option, to re-create a database to the identical state of the database
>that the export was run from?
>
>Any help would be appreciated
>Regards,
>Mick
>
Received on Thu May 21 1998 - 09:23:12 CDT