Import oracle error 23327

Hi all,

CONTEXT: Hardware DIGITAL VMS Server in production :

Oracle7 Server Release 7.3.2.3.2 - Production Release With the distributed, replication, parallel query, Parallel Server and Spatial Data options

Hardware DIGITAL UNIX Server:

Oracle7 Server Release 7.3.2.1.0 with the 64-bit option - Production Release
PL/SQL Release 2.3.2.0.0 - Production

the Data base had been created with:
> create database ......
> Catalog.sql
> create rollback segment r0...
> create tablespace temps...
> create tablespace tools...
>
> INIT_SQL_FILE =(CATALOG.SQL, catarr.sql, catproc.sql,
catrpc.sql, catrep.sql)

no errors in spool trace.lst

On the unix server, there is a restor error :
>
>Connected to: Oracle7 Server Release 7.3.2.1.0 with the 64-bit option -
Production Release
>PL/SQL Release 2.3.2.0.0 - Production
>
>Export file created by EXPORT:V07.03.02 via conventional path
>IMP-00017: following statement failed with ORACLE error 23327:
> "BEGIN

SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('DBPCS.WORLD','AL"
> "PHA/VMS-7.3.x.64'); END;"
>IMP-00003: ORACLE error 23327 encountered
>ORA-23327: imported deferred rpc data does not match GLOBAL NAME and
platform of importing db
>ORA-06512: at "SYS.DBMS_SYS_ERROR", line 83
>ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 29
>ORA-06512: at line 1
>. . importing table "DEF$_CALL" 0 rows
imported
>IMP-00017: following statement failed with ORACLE error 23327:
> "BEGIN

SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('DBPCS.WORLD','AL"
> "PHA/VMS-7.3.x.64'); END;"
>IMP-00003: ORACLE error 23327 encountered
>ORA-23327: imported deferred rpc data does not match GLOBAL NAME and
platform of importing db
>ORA-06512: at "SYS.DBMS_SYS_ERROR", line 83
>ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 29
>ORA-06512: at line 1
>. . importing table "DEF$_CALLDEST" 0 rows
imported
>IMP-00017: following statement failed with ORACLE error 23327:
> "BEGIN

SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('DBPCS.WORLD','AL"
> "PHA/VMS-7.3.x.64'); END;"
>IMP-00003: ORACLE error 23327 encountered
>ORA-23327: imported deferred rpc data does not match GLOBAL NAME and
platform of importing db
>ORA-06512: at "SYS.DBMS_SYS_ERROR", line 83
>ORA-06512: at "SYS.DBMS_DEFER_IMPORT_INTERNAL", line 29
>ORA-06512: at line 1
>. . importing table "DEF$_DEFAULTDEST" 0 rows
imported

My questions are

   1- : how can we restor ALL TABLES ?
   2- : Where did I make the error?

         knowing that : - the export/import on unix server (FULL=yes) is OK.

• the data base is created as explained just before.

My best regards.

JB Received on Fri Sep 18 1998 - 05:55:48 CDT