Saturday, February 7, 2015

Segmentation fault - During IMP from 11g Database - EXP & IMP Utility Version 9iR2

Scenerio 
Oracle IMP gives 'Segmentation fault' error . EXP  was taken from 11g R2 database using 9iR2 export utility. Import utility is also of 9iR2 version.
---------------------------------------------------------------------------------------------------------------
Import: Release 9.2.0.6.0 - Production on Sun Feb 8 10:23:48 2015

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Username: system/system

Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning option
JServer Release 9.2.0.6.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by ME, not by you

import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character setSegmentation fault
--------------------------------------------------------------------------------------------------------------- 
Workaround 
1. Connect to database 11g as SYSDBA with SQL*Plus
2. Change the definition of view EXU9DEFPSWITCHES from:

CREATE OR REPLACE VIEW SYS.EXU9DEFPSWITCHES
(COMPFLGS, NLSLENSEM)
AS
SELECT  a.value, b.value
        FROM    sys.v$parameter a, sys.v$parameter b
        WHERE   a.name = 'plsql_compiler_flags' AND
                b.name = 'nls_length_semantics'

to:
CREATE OR REPLACE VIEW SYS.EXU9DEFPSWITCHES
(COMPFLGS, NLSLENSEM)
AS
SELECT  a.value, b.value
        FROM    sys.v$parameter a, sys.v$parameter b
        WHERE   a.name = 'plsql_code_type' AND
                b.name = 'nls_length_semantics'


3. Now take the export using exp utility 9iR2 version
4. Import using imp utility 9iR2 version

---------------------------------------------------------------------------------------------------------------
Oracle Doc ID : 550740.1