Did I get your attention with the title? Well maybe these parameters are not really life changing, but at least very helpful! When I learned about them, my reaction was really? How come I didn’t know about these earlier…as they are very helpful! Actually one of the parameters is one that I use a lot, however not in this fashion as I will show you.
Let me show you the 3 parameters:
1) REMAP_TABLESPACE
Of course we know what this parameter does. It is used on the import to remap the source tablespace to the target tablespace. Usually, I use it this way:
REMAP_TABLESPACE=HRPRD_DATA1:HRTST_DATA, HRPRD_DATA2:HRTST_DATA
In the example above, I am remaping 2 tablespaces to the same target tablespace. This is pretty easy and fast to write, but when you have 10 tablespaces that you want to remap to only one, it’s becoming more inconvenient.
There is a better way that I discovered! The above remap, can be simplified to:
REMAP_TABLESPACE=%:HRTST_DATA
This means that I remap all the source tablespaces to HRTST_DATA. This is amazing, all in one line!
2) LOGTIME
This parameter can be use for export or import datapump, and specifies that the messages that are displayed during the export or import be timestamped. The values for this parameter could be NONE (the default), STATUS, LOGFILE or ALL. I would use ALL for LOGTIME. If you are using older versions of Oracle, ie 11g, this parameter will not be available for you, as it was introduced with 12c.
If you set LOGTIME=ALL, the output will be similar to: