Advanced Queue Quickie: Errors and Privileges

File this one under the misleading-errors department. One of my developers was working with a new queue. He pinged me when he got this error trying to create a job that used the queue:ERROR at line 1:ORA-27373: unknown or illegal event source queueORA-06512: at "SYS.DBMS_ISCHED", line 124ORA-06512: at "SYS.DBMS_SCHEDULER", line... [Read More]

NOFILENAMECHECK Parameter Causes DUPLICATE DATABASE To Ignore DB_CREATE_FILE_DEST?

Last week I was creating a new testing database from a backup of our demo database, both under Oracle 11.2.0.3. I grabbed one of my old scripts to handle the duplicate function, which looked similar to this:connect auxiliary /;run {        duplicate database to testdb                backup location '$BACKUPDIR'                nofilenamecheck;}One important difference... [Read More]
Tags: 11gR2 rman oracle

ORA-14048 When Adding Composite Partition

Fresh off the heels of my earlier composite partitioning post, I just ran into this confusing issue:SQL> alter table p_objects  2          add partition p201410  3                  values less than (to_date('2014/11/01','yyyy/mm/dd'))  4          (  5    ... [Read More]