Saturday, January 3, 2009

Export/Import Issue with oracle 8i

While Upgrading the EMS Database to 9.2.0.6, I have faced Some issues while Importing the EMS data Using the Export DMP file that was created with an Oracle 8i (8.1.6) Release Export Utility.

Error Message:
IMP-00017: following statement failed with ORACLE error 6550:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(~,~); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"BOE_DTL"','"BED_EXP_BNK_CODE"', NULL ,NULL,NULL,0"
",0,7209,srec,1,2); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 155:
PLS-00103: Encountered the symbol "~" when expecting one of the following:

IMP-00017: following statement failed with ORACLE error 6550:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL :="
" NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NOVALS := DBMS_STATS.NUMAR"
"RAY(~,~); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STAT"
"S.SET_COLUMN_STATS(NULL,'"BOE_DTL"','"BED_BYR_BNK_CODE"', NULL ,NULL,NULL,0"
",0,7209,srec,1,2); END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 155:
PLS-00103: Encountered the symbol "~" when expecting one of the following:

Solution:
This issue occurs with an Oracle8i, 8.1.7.2 or earlier release export utility Apply the 8.1.7.3 Patch set or Use this Action plan to resolve the Data Migration Issue:
1. Re-run the export without exporting the statistics:

> exp system/password FILE=... STATISTICS=none .... (other parameters)

And re-run the import afterwards.

or:

2. Do not import the statistics that were exported in the export dump file:

a. When importing into an Oracle8i database:
> imp system/password FILE=... ANALYZE=n .... (other parameters)
or:
> imp system/password FILE=... RECALCULATE_STATISTICS=y .... (other p's)

b. When importing into an Oracle9i/Oracle10g database:
> imp system/password FILE=... STATISTICS=none .... (other parameters)
or:
> imp system/password FILE=... STATISTICS=recalculate .... (other params)

6 comments:

  1. Worked well for me.. thanks!

    ReplyDelete
  2. Ѕo in this way majority fоotstep
    frοntwarԁs іn acting Libeгate onlinе games.
    You can Ѕοcialize, crеatе items, Recгеatе pageѕ of a quaffle,
    the categorisаtion hat, hook and Dobby.

    Аlѕo visit my wеb site: easyshopassistant.com

    ReplyDelete
  3. Which brings me to my First Tip when it comes to Teaching An Older Child the Alphabet and English Words:
    Do not assume that an older adopted child is the same
    as an ESL (English as a Second Language) Child.
    Good writing skills ensure professional growth:Good writing skills are essential for professional growth.
    Because of this, it is imperative to determine first their difficulties and needs so that whatever materials a teacher purports to design should be in accordance with these needs.


    my website :: cach hoc tieng anh hieu qua nhat

    ReplyDelete