Another one to file under “Not sexy but flippin’ awesome!”
If you are a DBA, you are going to spend a lot of time with Data Pump. All roads seem to lead back to it. 🙂 There are some more headline worthy features, like transportable database, but the two that jumped out at me were actually pretty small, but awesome.
- “TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y” – Switches table and/or index imports to NOLOGGING for the lifespan of the import operation.
- “LOGTIME=ALL” – Puts a timestamp in the output message so you can see how long individual operations took.
I wrote up an article about it here.
Cheers
Tim…
Tim Hall: Data Pump Enhancements in Oracle Database 12c: Another one to file under “Not sexy but flippin’ awes… http://t.co/7Gc5mWD4cq
RT @orafaq: Tim Hall: Data Pump Enhancements in Oracle Database 12c: Another one to file under “Not sexy but flippin’ awes… http://t.co/7…
RT @orafaq: Tim Hall: Data Pump Enhancements in Oracle Database 12c: Another one to file under “Not sexy but flippin’ awes… http://t.co/7…
Data Pump Enhancements in Oracle Database 12c http://t.co/mQdgluzL3G #oracle
RT @orafaq: Tim Hall: Data Pump Enhancements in Oracle Database 12c: Another one to file under “Not sexy but flippin’ awes… http://t.co/7…
Data Pump Enhancements in Oracle 12c : http://t.co/9i9DtWLla8
RT @oraclebase: Data Pump Enhancements in Oracle 12c : http://t.co/9i9DtWLla8
“Data Pump Enhancements in Oracle Database 12c” http://t.co/ernzJnMEac
nice one, but while doing the import, mostly we stop archive, but with this feature, its really Great and second one time, is little more Fancy.. but yeah helps sometime