Import/Export Problem

From: <iamrakeshp_at_yahoo.com>
Date: 7 Oct 2004 09:09:13 -0700
Message-ID: <dd6dcab0.0410070809.43628a26@posting.google.com>

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

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 Thu Oct 07 2004 - 11:09:13 CDT