Showing posts with label Oracle Utilities. Show all posts
Showing posts with label Oracle Utilities. Show all posts
Monday, September 16, 2019

How to work around ORA-03206 when running the RCU (Repository Creation Utility) used by ODI

›
During installation you may encounter the error ORA-03206: maximum file size of (13107200) blocks in AUTOEXTEND clause is out of range I...
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...
Wednesday, March 2, 2016

How to identifiy whether or not Oracle Configuration Manager is in use

›
Change directory to $ORACLE_HOME # cd $ORACLE_HOME # ls ccr bin config doc hosts inventory lib README.pdf state If the directory cc...
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:
Thursday, March 6, 2014

How to deal with impdp error ORA-29913: error in executing ODCIEXTTABLEOPEN callout

›
I recently hit this error from one of my customers during import of a schema: ORA-31693: Table data object "SH"."SALES_REG1...
2 comments:
Thursday, January 16, 2014

How does Oracle Data Pump Import handles referential integrety constraint violations?

›
How does Oracle Data Pump Import handles referential integrety constraint violations? To find out, let's use the two tables SHIPS and ...
Tuesday, November 19, 2013

Errors ORA-31693 and ORA-29913 thrown during import

›
Yesterday when importing some test data from production to test, I encountered the following error during import: . . imported " ...
Thursday, November 7, 2013

Some useful asmcmd commands

›
When you need to work with ASM disks, you can use the asmcmd (ASM Command Line Utility) utility. I have found the following commands very us...
Friday, November 1, 2013

How to create a consistent dump set using expdp

›
Use the FLASHBACK_TIME or FLASHBACK_SCN directives. The simplest approach: FLASHBACK_TIME="to_timestamp(to_char(sysdate,'ddmmyy...
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:

How to only export specific partitions using Oracles data pump utility

›
In your parameter file, use the following notation: TABLES=SCOTT.TABLE1:PART_1 You can export more partitions in the same run: TABLES=...