Showing posts with label Export and Import. Show all posts
Showing posts with label Export and Import. Show all posts
Wednesday, September 22, 2021

How to resolve ORA-48128 during export

›
Applicable to Oracle 19.3 and onwards. The following error may occur when you export data using Data Pump Parameter file: userid=sys...
Tuesday, June 8, 2021

Workaround for ORA-39358 during import

›
When running import, you may sometimes run into the problem below: impdp parfile=myparfile.par Import: Release 12.2.0.1.0 - Production on...
Friday, April 30, 2021

How to instruct data pump import to load whatever it can from a corrupted source

›
Oracle 18c introduces a new option to the parameter DATA_OPTIONS: CONTINUE_LOAD_ON_FORMAT_ERROR. This option will tell data pump import to ...
Thursday, May 16, 2019

How to compress tables on import

›
Oracle 12c introduces a way to compress tables on the fly, during import using impdp. Use the directive transform=table_compression_cla...
Monday, June 25, 2018

How to move data using Transportable Tablespaces

›
Mission: * Move schema FXMART with all of its data from source database proddb01 to destination database testdb01 * In the same operati...
Friday, March 31, 2017

How to import only users over a network link

›
Use the following parameter file to import only the user definitions from your source database to your test database: Remember that the d...
Thursday, March 9, 2017

Errors ORA-39083 and ORA-28365 during import

›
During an import you get: ORA-39083: Object type TABLE:"SCOTT"."EMP" failed to create with error: ORA-28365: wallet is...
Tuesday, June 14, 2016

How to compare the number of objects per schema in two databases

›
After a migration of a database to a new server, or after any kind of replication, you would like to get some verification that your objects...
Monday, June 1, 2015

How to fix error >>> DBMS_AW_EXP: BIN$DdyrY during export

›
During export using data pump, you see the following: Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TAB...
3 comments:
Monday, October 28, 2013

Examples of expdp and impdp parameter files, and some useful directives

›
Export: USERID='/ as sysdba' DIRECTORY=DPUMP DUMPFILE=file_name_%U.dmp LOGFILE=expdp_log_file_name.log JOB_NAME=EXP_DATA PARALLEL...
1 comment: