imp system/sysdb2 file=exp_db1.dmp log=imp_db2.log ignore=y constraints=n indexes=n fromuser=CMS30 touser=cms30The 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> pipeI 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.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.