Oracle Error 6550 Imp-00017
Upgrading the EMS Database to 11g, I have faced Some issues while Importing the EMS data Using the Export DMP file that was created with an Oracle 9i (9.0.2) 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, 9.0.2 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) This entry was posted in Oracle by albjas. Bookmark the permalink. Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOu
the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: Import problem... Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid https://albjas.wordpress.com/2013/10/24/imp-00017-importexport-without-statistics/ Mode Switch to Threaded Mode 11-01-03,17:35 #1 TCR09 View Profile View Forum Posts Registered User Join Date Nov 2003 Posts 5 Unanswered: Import problem... Hi, I have a production database, and a test database which is a copy of the production db. Usually, to update the test db, i do an export of http://www.dbforums.com/showthread.php?963684-Import-problem each user of the prod db, then import them in the test db. And it works.... But now, it seems that my new exports can't be imported anymore. I've tried an old dump file and it's still working. But the new ones keep making errors like the following: IMP-00017: following statement failed with ORACLE error 6550: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '78670A0A092221'; SR" "EC.MAXVAL := '78670A0A0C2427'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NO" "VALS := DBMS_STATS.NUMARRAY(2452923,35662037,2452923,48307 87); SREC.BKVALS " ":= DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NUL" "L,'AUDIT_USAGER_DEMANDE','DATEACTION',NULL,NULL,N ULL,11,,0909090909090909,0" ",srec,7,0); END;" IMP-00003: ORACLE error 6550 encountered ORA-06550: line 1, column 357: PLS-00103: Encountered the symbol "," when expecting one of the following: ( - + mod not null others
Connor McDonald � Last updated: February 11, 2016 - 2:41 am UTC Category: Database � Version: 11g Whilst you are here, https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9526313800346402348 check out some content from the AskTom team: Forever is a long time Latest Followup You Asked I need to import an Oracle9i Release 9.2.0.6.0 dump in http://www.orafaq.com/usenet/comp.databases.oracle.server/2004/07/22/1535.htm an Oracle 11g. Using the import command I have a ton of erros like this: IMP-00017: following statement failed with ORACLE error 6550: "BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;" IMP-00003: oracle error ORACLE error 6550 encountered Th command I use is: imp system/
Database Import On 8.1.7.4 I Get Ora-6550 From: Steve