Datapump IMPDP Partition_Options = MERGE , DEPARTITION Examples

Partition_Options parameter is available with data pump impdp utility.  This parameter determines how the partitions available in the export dump are handled in the import operation.

Duplicate Command Failed: RMAN-05001: auxiliary filename %s conflicts with a file used by the target database

Error Description:

RMAN Duplicate database command failed with RMAN-05001 error message

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 21/10/2012 23:09:54
RMAN-05501: aborting duplication of target database

OC4J Connection Pool Error Message: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Error Description:

OC4J connection pool configuration testing to Oracle 11g database is giving following error.

OC4J Error message: Exception occurred testing connection. Exception: java.sql.SQLException: ORA-01017: invalid username/password; logon denied 

Fix ORA-02032: clustered tables cannot be used before the cluster index is built

Error Description:

Insert SQL statement fails with following error message.

SQL> insert into emp values (7369, 'smith', 'clerk', 7902,to_date('17-dec-1980', 'dd-mon-yyyy'), 800, null, 20);

Truncate Failed: ORA-03292: Table to be truncated is part of a cluster

Error Description:

Truncate table command failed with following error message.

SQL> TRUNCATE TABLE DEPT;

TRUNCATE TABLE DEPT

               *

Shell Script to Run RMAN Backup in Background with nohup

Step 1. Prepare a RMAN command file

vi bkup.cmd

run

Move Subpartition for an Interval Partitioned Table Failed: ORA-00600 [kkpod nextFrag]

Error Description:

Alter table move subpartition on an interval partitioned table is failed with following error. Also the session got disconnected.

Fix IMP-00013: only a DBA can import a file exported by another DBA

Error Description:

Import using imp utility is failing with following error.

Export file created by EXPORT:V11.02.00 via conventional path

IMP-00013: only a DBA can import a file exported by another DBA

IMP-00000: Import terminated unsuccessfully

Fix IMP-00058: ORACLE error 1950 encountered

Error Description:

Import using conventional imp utility is failing with following error.

IMP-00058: ORACLE error 1950 encountered

ORA-01950: no privileges on tablespace 'USERS'

Import terminated successfully with warnings.

Blogger Blogspot Page views Reset to Zero Today - Resolved

It is a surprise to me that my blogger page views are reset to zero today(15-Oct-2012) and a fresh counter started. This is the first time I am seeing this problem in my blogging life. As per the blogger support team it is a known issue.

Rail Radar: How to Live Locate Indian Railway Trains in Google Map!!

Indian railway launched live locator for the trains running on the Indian railway tracks with the help of the Google Maps. When you launch the web site you will get the Indian map with train indicators and you can zoom-in and zoom-out as like in Google Maps.

Index Rebuild Online Failed Oracle 11gR2: ORA-01450: maximum key length (3215) exceeded

Problem Description: Index creation or rebuild with online clause failed with following error in Oracle 11gR2.

ORA-00604: error occurred at recursive SQL level 1

ORA-01450: maximum key length (3215) exceeded

Fix Oracle 11g Client sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Error Description:

Oracle 11g Client SQL* PLUS is failing with following error.

$ORACLE_HOME/bin/sqlplus
/opt/oracle/client_11_2/bin/sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

How to Find out / Check / Set Values for Hidden Underscore _ Parameters in Oracle?

Short Note on Hidden/Undocumented Parameters:

Undocumented parameters need to be tested in test database before implementing in production. Also, better to get support from oracle before going to production. Hidden parameters are for internal purpose of the oracle. You have to be very careful before implementing as they are very dangerous. It starts with ‘_’.

Validate Exception Queue: ORA-24017: cannot enable enqueue on QUEUE

Error Description:

exec DBMS_AQADM.START_QUEUE('AQ$_TEST_TABQ_E'); command is failing with following error.

SQL>  exec DBMS_AQADM.START_QUEUE('AQ$_TEST_TABQ_E');

BEGIN DBMS_AQADM.START_QUEUE('AQ$_TEST_TABQ_E'); END;