Good question we receive quite often:
Is “imp” still supported in Oracle Database 12.2?
For clarification: I don’t talk about “impdp” but about old “imp” (import). And yes, it is still supported in Oracle 12.2.
The old “exp” got desupported with Oracle Database 11.1.0.6 – but “imp” is still supported, even in Oracle Database 12.2.0.x. You should be able to import your old dumps into the newest release of the database and migrate even VERY old releases directly to Oracle Database 12.2.
Actually, the biggest step upwards we’ve heard about a year ago was an exp from Oracle V5 and migration into Oracle 12.1.0.2 Single Tenant. No joke – and it worked!
Only real pitfall we are aware of right now: The MOS Note 132904.1 (Compatibility Matrix for Export And Import Between Different Oracle Versions) hasn’t been updated recently for whatever reason.
–Mike
After upgrade performance on the following went from 3 minutes to over 25 minutes:
impdp system/’xxxxxxxxx’ FULL=N DIRECTORY=DATA_PUMP_DIR LOGFILE=EPIC_NP.log NETWORK_LINK=DEV1 TABLES=I2B2STDETL.EPIC_NP REMAP_SCHEMA=I2B2STDETL:RDI2B2METADATA REMAP_TABLESPACE=RDMF_DAT:I2B2DATA,RDMF_IDX:I2B2INDX TABLE_EXISTS_ACTION=APPEND TRANSFORM=TABLE_COMPRESSION_CLAUSE:NOCOMPRESS
Terrible performance on Oracle 12.2.0.2 still. This was running in three minutes before with over 3 million rows, this was run on SE2 pulling from Oracle EE.
Colleen,
are you saying the import via NETWORK_LINK took 3 minutes before (which release to which release) and now takes 25 minutes (which release to which release)?
And 12.2.0.2 isn’t out yet – do you mean 12.1.0.2? If yes, what is your Bundle Patch Level? And did you apply the ADAPTIVE patches I have linked and recommended from the blog? Of if you can’t apply them, did you set any special init.ora parameters yet?
Cheers
Mike