Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problems whit import

Re: Problems whit import

From: Jeff Hunter <jeffh_at_btitelecom.net>
Date: Tue, 14 Dec 1999 10:01:14 -0500
Message-ID: <38565bd6@defiant.btitelecom.net>


from svrmgrl connected as internal run
?/rdbms/admin/catproc.sql

Henrik Meldgaard Frisk wrote in message <83516o$e8g$1_at_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 - 09:01:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US