BE SHARING

Data pump

impdp logtime=all metrics=y and 12cR2 parallel metadata

28.11.2017 by Oracle Team

By Franck Pachot . A quick post to show why you should always use LOGTIME=ALL METRICS=Y when using Data Pump. Just look at an example showing the timestamp in front of each line and a message about each task completed(…)

Oracle

impdp content=metadata_only locks the stats

06.09.2017 by Oracle Team

By Franck Pachot . With Oracle you can learn something every day. Today, preparing a migration to 12.2, I found all tables had locked statistics. I learned that it is the expected behavior since 10.2 when importing metadata_only including statistics,(…)

Database management

Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c

22.04.2017 by Oracle Team

By Franck Pachot . Data Pump is a powerful way to save data or metadata, move it, migrate, etc. Here is an example showing few new features in 12cR1 and 12cR2.

Database management

does impdb into a compressed table really compress data?

18.05.2015 by Daniel Westermann

Today at a customer we discussed the following scenario: To refresh a test database a datapump export and import was implemented. To save space on the test system the idea came up to compress the data on the test system.

Database management

How to remap tablespaces using Oracle Import/Export Tool

26.08.2014 by Oracle Team

Since Oracle 10g, Oracle provides a great tool to import and export data from databases: Data Pump. This tool offers several helpful options, particularly one that allows to import data in a different tablespace than the source database. This parameter(…)

Database management

Data Pump in Oracle Database 12c: die wichtigsten Neuigkeiten

29.07.2013 by Jérôme Witt

Letztes Jahr hat Oracle CEO Larry Ellison während der Oracle OpenWorld in San Francisco ein neues Datenbank Release angekündigt, das nun endlich zur Verfügung steht. In diesem Blogbeitrag möchte ich einige der wichtigsten Data Pump-Neuigkeiten vorstellen. Eine komplette Übersicht(…)

Database management

Wie kann ich Indexes und Daten mittels Data Pump trennen?

18.02.2013 by Jérôme Witt

Diese Frage habe ich in den letzten Jahren öfters gehört. Zumindest seitdem die DBAs Oracle Datapump verwenden anstatt des alten Export/Import Tools. Angeblich war es früher mit dem Import-Parameter-Tool „INDEXFILE“ viel einfacher. Tja, die Wahrheit ist: Mit Datapump geht es noch(…)

Database management

How to debug a Data Pump error

01.03.2011 by Hervé Schweitzer

Recently, I had an Oracle error with Data Pump at a Customer, which was not easy to localize. Here is the error I received during a DBIOWNER schema export with Data Pump: Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ORA-39125: Worker(…)