Q

Each table in import giving errors

I am attempting to import an Oracle dump file supplied by a customer into a database to replicate reported issues. The import starts and recognizes the tables; however each table gives errors. I have successfully imported export files from this customer in the past.

I am attempting to import an Oracle dump file supplied by a customer into a database to replicate reported issues. Both the source db and target db are running 9.2.0.4.0. The import command being used is:
imp system/sysdb2 file=exp_db1.dmp log=imp_db2.log ignore=y 
constraints=n indexes=n fromuser=CMS30 touser=cms30
The import starts and recognizes the tables; however each table errors with the 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; "
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 119:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

   begin case declare end exception exit for goto if loop mod
   null pragma raise return select update while with
   <an identifier> <a double-quoted delimited-identifier>
   <a bind variable> << close current delete fetch lock insert
   open rollback savepoint set sql execute commit forall merge
   <a single-quoted SQL string> pipe
I have successfully imported export files from this customer in the past. I'm puzzled by this problem occurring now, and any pointers would be extremely helpful. Thanks.
The most common reason for the PLS-00103 error is that the dump file was transferred to you in ASCII mode. If you are using FTP to perform the transfer, ensure the FTP program is transferring the file in binary mode. Some FTP programs try to automatically determine the file type and they incorrectly determine the dump file is an ASCII file, which it is not. I always tell my FTP program to transfer in BINARY mode.
This was first published in March 2006

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close