Re: Problems whit import

1. rerun dbmsstdx.sql in your $ORACLE_HOME/rdbms/admin
2. rerun catproc.sql
3. if doesn't work rerun catalog.sql and go back to step 1

I have problems with OraPackages all the time. On Tue, 14 Dec 1999 10:04:19 +0100, "Henrik Meldgaard Frisk" <hfr_at_bang-olufsen.dk> wrote:

>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 ?

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email