Re: Import/Export Problem

Hi!

I had same problem. I was dropped user DBSNMP in target database and the import gave the same error message. I created the user DBSNMP again and my import went well. My export was made from oracle 8.0.6.2 and target to import was oracle 9.2.0.4.0. I hope this will help you.

Best regards,
George single-v Bush

iamrakeshp_at_yahoo.com wrote:
> hi All,
> i am having problem importing the database .The export is
> done as system and I am importing as system.
> The export is done with direct=Y . I cant even import one table from
> the export file. The file is rcopied from one machine to another so
no
> ftp problems there .
> Changed the NLS_LANG parameter too but nothing works .
>
>
> imp system/rakesh
>
> Import: Release 9.0.1.0.0 - Production on Thu Oct 7 10:42:05 2004
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
>
> Connected to: Oracle9i Enterprise Edition Release 9.0.1.0.0 - 64bit
> Production
> With the Partitioning option
> JServer Release 9.0.1.0.0 - Production
>
> Import file: expdat.dmp > rakesh.dmp
>
> Enter insert buffer size (minimum is 8192) 30720>
>
> Export file created by EXPORT:V08.01.05 via conventional path
> import done in US7ASCII character set and UTF8 NCHAR character set
> export server uses US7ASCII NCHAR character set (possible ncharset
> conversion)
> List contents of import file only (yes/no): no >
>
> Ignore create error due to object existence (yes/no): no >
>
> Import grants (yes/no): yes >
>
> Import table data (yes/no): yes >
>
> Import entire export file (yes/no): no > yes
>
> IMP-00017: following statement failed with ORACLE error 4068:
> "BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;"
> IMP-00003: ORACLE error 4068 encountered
> ORA-04068: existing state of packages has been discarded
> ORA-04067: not executed, package body "SYS.DBMS_REPCAT_UTL" does not
> exist
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 116
> ORA-06512: at line 1
> IMP-00000: Import terminated unsuccessfully
>
> Checked the packages they all seem valid .sys.dbms_repcat_utl does
> exist.
>
> The relevant NLS_parameters from nls_database_parameters are
>
> NLS_CHARACTERSET US7ASCII
> NLS_CALENDAR GREGORIAN
> NLS_DATE_FORMAT DD-MON-RR
> NLS_DATE_LANGUAGE AMERICAN
> NLS_SORT BINARY
> NLS_TIME_FORMAT HH.MI.SSXFF AM
>
> PARAMETER VALUE
> ------------------------------
> ----------------------------------------
> NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
> NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
> NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
> NLS_DUAL_CURRENCY $
> NLS_COMP BINARY
> NLS_LENGTH_SEMANTICS BYTE
> NLS_NCHAR_CONV_EXCP FALSE
> NLS_NCHAR_CHARACTERSET UTF8
> NLS_RDBMS_VERSION 9.0.1.0.0
Received on Mon Jan 17 2005 - 05:15:28 CST