Datapump Import fails with ORA-39083 ORA-6550 ORA-00911 Errors When Duplicating Schema (Doc ID 2003501.1)

Last updated on MAY 29, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Datapump Import is failing with the following errors:

Import: Release 10.2.0.4.0 - 64bit Production on Wednesday, 22 April, 2015 12:19:51

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01":  "/******** AS SYSDBA" parfile=crdhkuo1_import_20150422.par
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"CRDHKUA12" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

ORA-39082: Object type ALTER_PROCEDURE:"CRDHKUA12"."HSBC_UPD_OPEN_UNIT_BATCH" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"CRDHKUA12"."HSBC_UPD_HKOPEN_UNIT_BATCH" created with compilation warnings
ORA-39082: Object type ALTER_PROCEDURE:"CRDHKUA12"."HSBC_PRC_CFD" created with compilation warnings

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39083: Object type TABLE_STATISTICS failed to create with error:
ORA-06550: line 3224, column 143:
PL/SQL: ORA-00911: invalid character
ORA-06550: line 3220, column 256:
PL/SQL: SQL Statement ignored

Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
Job "SYS"."SYS_IMPORT_FULL_01" completed with 35 error(s) at 14:37:49

 

The export as such has apparently been completed without any issue:

Export: Release 10.2.0.4.0 - 64bit Production on Wednesday, 22 April, 2015 12:12:38

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Starting "SYS"."SYS_EXPORT_SCHEMA_01":  "/******** AS SYSDBA" parfile=crdhkuo1_export_20150422.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 108.4 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
  /hsbc/crd/DB_dump_backup/crdhkuo1_00.dmp
 
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 12:19:04

 

Changes

The source and destination belong to the same database. Basically it is intended to duplicate the schema in the same database.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms