Re: Full database import

Mick,
DEFINITELY catproc.sql. It is part of system tables and will not be generated on an import.
Run it from a connect internal Srvrmgr (sqldba) session. The rest of your procedure is good.

      Regards, Roelof

Roelof Schierbeek, DBA
Bytelife BV The Hague, Holland
email: bytelife AT worldonline.nl
http://home.worldonline.nl/~bytelife

Mick McRae heeft geschreven in bericht <35636097.A517B9FD_at_its.csiro.au>...
>Hi,
>I've been trying to use the import utility to import a full database
>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.
>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
>Regards,
>Mick
Received on Thu May 21 1998 - 06:26:54 CDT