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.
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.