Blog Search
About Me
-
Recent Posts
- MySQL in Oracle Environments Part 1: Quick Start for the Oracle DBA
- ICACLS – A magic command
- ORA-01791: not a SELECTed expresssion
- Patching through OEM 12c in Offline mode
- XDB.DBMS_XDBUTIL_INT.SYSTEM_INFO_EXP – Export Error
- Opatch Apply on Windows failed with CheckActiveFilesAndExecutables
- scp – lost connection
- ora-201 and Checker run found %n% new persistent data failures
- ORA-00001: unique constraint violated
- Recovering from rm -rf on a datafile
- Sangam 13 – Oracle Users Conference in India
- Tools to aggregate Oracle CRS logfiles in one file, filter it, sort it, and display it.
- Oracle 12c RAC On your laptop By Yury Velikanov
- Restore and Recover Table Using RMAN
- Oracle Database 12c – Released
- MS-Excel Trick
- TNS-12557 TNS-12560 TNS-00527
- Oracle Configuration Manager – Is it installed or configured ?
- Switchover and Failover with TIME Delay
- Data Guard – Concepts
Categories
Archives
Blogroll
- Charles Hoopers's Blog
- Christian Antognini
- Coskan's Blog
- Jaffar Hussain's Blog
- Jonathan Lewis's Blog
- Julian Dyke's Blog
- Karl Arao's Blog
- Kerry Osborne’s Blog
- Kevin Closson's Blog
- Kyle Hailey
- Neeraj Bhatia's Blog
- Oracle Optimizer
- Randolf Geist's Blog
- Richard Foote’s Blog
- Riyaj Shamsudeen's Blog
- Tanel's Blog
- Tom Kyte's Blog
- Uwe Hesse's Blog
- Wissem's Blog
- Wordpress.com
Twitter
Tweets by raheelhsyed-
Raheel’s Cloud
- 10.2.0.4
- 10.2.0.4 ora-600 internal error
- 10.2.0.5
- 10.2.0.5 patch set
- 10.2.0.5.6 PSU
- 153788.1
- 727363.1
- 731678.1
- 756764.1
- 7189984.8
- aioug
- alexgorbatchev
- all control files are lost
- archivelog backup to disk
- argument kjbmprlst:shadow
- backup and recovery
- backup on more than one mount point
- Bug 7189984
- catbundle.sql
- catupgrd.sql
- compressed RMAN
- cpu utilization
- CSS
- current open window
- dbms_scheduler jobs do not run
- fix dbms_scheduler jobs
- formatting
- High Disk IO
- issues after 10.2 upgrade
- know how
- knowledge sharing
- Linux
- Linux load average
- list backup
- LMS1: terminating instance due to error 484
- LMS error
- mailx
- Manual Upgrade
- MTU could not be verified
- netbackup issue
- No backup
- no control file backup
- nohup
- OPatch 6880880
- Operating Systems
- ORA-00600:arguments: [kjbmprlst:shadow]
- ORA-00603 skgxpvfymmtu
- ORA-01110
- ORA-01157
- ORA-07445:core dump [kprccu()+54] [SIGSEGV]
- ora-600
- oracle
- oracle conference
- oracle dba
- p8202632
- PSU on RAC
- RAC
- raheel
- read only tablespace recovery
- restore archivelog from disk
- RMAN
- sar
- send email from linux
- shell script
- source code
- SQL
- startup upgrade
- syntax highlight
- SyntaxHighlighter
- TOAD
- TOAD scheduler job
- top
- UNDO recovery
- weekend window
- wordpress
Feeds
Stats
- 135,190 hits
- Views expressed on this blog are my experiences or findings, not necessarily match with others, please test it before use.
Tag Archives: 11gR2 new features
ORA-00001: unique constraint violated
IGNORE_ROW_ON_DUPKEY_INDEX hint is on rescue. This is the NEW feature in 11gR2 applied on INSERT statements, wherein duplicate values will be ignored rather causing ORA-00001 error. Scenario: Development team wanted one of the STAGING table to be refreshed from PROD table … Continue reading
Posted in 11gR2, New Features
Tagged 11gR2 new features, ora-00001, pk violated, unique constraint violated
Leave a comment
Raheel's Blog 