Hi Folks,
We are importing table data from oracle 9i (9.2.0.8) into oracle 11g (11.2.0.3) using the old oracle imp utility, and we're hoping that you can help us speed up the process please.
We have exported one table data; roughly 35 million rows have been exported generating an export dump size of 7.5GB. Please note that this is a subset of the data (one month worth of data to be exact). We do realize that there will be a lot of duplicates within this data sub-set and that the import would reject the duplicated rows through PK constraints (giving the following error):
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (RG_SCHEMA.SSTG010P) violated
Column 1 243113850256342640
The import has been running for over 3 hrs now and is taking quite a while even though we're running it with the following parameters:
statistics=NONE
buffer=12000000
resumable=Y
ignore=Y
constraints=N
indexes=N
We do realize rejecting more than half the rows would slow down the process as there is overhead associated with that; having said that is there anything else we can try to to speed up this dreaded process please.
Appreciate the help.