Hi All,
Recently we have moved to Oracle 12c Orras (Oracle as service)cloud database.We use export import (exp/imp) feature of oracle in our application to take backup and restore data.However we are facing issue in 12c with same export and import command which were running fine in 11g. Following are the details about error.
Export Command Used :
exp username/pwd@db FILE=**** TABLES=(test) LOG=****** ROWS=Y CONSTRAINTS=N GRANTS=N BUFFER=1000000 DIRECT=Y
Error (in 12c database) in Export and command :
EXP-00091: Exporting questionable statistics.
EXP-00008: ORACLE error 1455 encountered
ORA-01455: converting column overflows integer datatype
EXP-00000: Export terminated unsuccessfully
Error (in 12c database) in Import command :
While we import same dump (which was exported above) we got following errors in import command and getting terminated.
IMP-00020: long column too large for column buffer size (22)
IMP-00009: abnormal end of export file
IMP-00033: Warning: Tables not found in export file.
IMP-00051: Direct path exported dump file contains illegal column length
IMP-00008: unrecognized statement in the export file:
_
IMP-00008: unrecognized statement in the export file: Because of this so many tables are missing 12C database.
To overcome above issue we had removed "DIRECT=Y" and added INDEXES=N , STATISTICS=NONE in export command. With these changes export and import working as expected.However performance is degraded in 12c as we removed "DIRECT=Y".
Please suggest an appropriate command where we can take export and import data without any error and with improved performance(without removing DIRECT=Y).
Note: we cannot use expdp/impdp command as we need dmp files at client machine.Thus we need to go with traditional export and import (exp/imp) feature only.
Regards,
Vivek