Problems whit import

From: Henrik Meldgaard Frisk <hfr_at_bang-olufsen.dk>
Date: Tue, 14 Dec 1999 10:04:19 +0100
Message-ID: <83516o$e8g$1@news.inet.tele.dk>

Hi

I am working on a project where I have to move a database from a version 7.1.6.2.0. into a 8.0.4.

I have created my new database. The instance is startet. I have run the script catalog.sql that repares to new database to import. My export file was made whitout warnings.

Now I just have to import, but here I get into trouble. My export file is created in USER MODE.

The import parameter file look like this: USERID=< >
FILE=< >
FROMUSER=< >
TOUSER=< >
LOG=< >
IGNORE=Y I get the following errors:

ORA-06554: package DBMS_STANDARD must be created before using PL/SQL
IMP-00017:  following statement failed with ORACLE error 4043
ORA-04043: object "tablename" does not exist

etc..
etc..

I thing it is this missing DBMS package that is causing all the trouble. Do I need to run a script that repare the database for PL/SQL ? Dos someone know that this DBMS_STANDARD package is, and that can I do to avoid this error, or is it something else ?

Otherwise I have to start all over again.

Henrik
Denmark Received on Tue Dec 14 1999 - 03:04:19 CST