ORA-32146: Cannot perform operation on a null date

Cause : Th edaet ivnolevd ni tihs poertaio nisn ul.l

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Us evaild,n onn-ul ldaet isntacne ot prefomr tihs poertaio.n

update : 24-07-2017

ORA-32146 - Cannot perform operation on a null date
ORA-32146 - Cannot perform operation on a null date

  • ora-19750 : change tracking file: 'string'
  • ora-02478 : merge into base segment would overflow MAXEXTENTS limit
  • ora-15054 : disk "string" does not exist in diskgroup "string"
  • ora-27370 : job slave failed to launch a job of type EXECUTABLE
  • ora-26724 : only SYS is allowed to set the Capture or Apply user to SYS.
  • ora-16765 : Redo Apply is unexpectedly online
  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-23472 : materialized view "string"."string" must be atomically refreshed
  • ora-28344 : fails to decrypt data
  • ora-00385 : cannot enable Very Large Memory with new buffer cache parameters
  • ora-31617 : unable to open dump file "string" for write
  • ora-29322 : SCN string size too long -- maximum size 58 bytes/characters
  • ora-22130 : buffer size [string] is less than the required size [string]
  • ora-14165 : MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations
  • ora-31517 : CDC change table string.string already exists
  • ora-36181 : A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
  • ora-14015 : too many partition descriptions
  • ora-16204 : DDL successfully applied
  • ora-25273 : AQ QMN process alternate cleanup event
  • ora-02757 : osnfop: fork_and_bind failed
  • ora-23334 : column string does not exist in table or column group
  • ora-33002 : (XSAGDNGL00) In AGGMAP workspace object, the FLOOR argument of number must be less than the CEILING argument of number.
  • ora-16797 : database is not using a server parameter file
  • ora-28526 : invalid describe information returned to Heterogeneous Services
  • ora-24815 : Invalid character set form
  • ora-08001 : maximum number of sequences per session exceeded
  • ora-19238 : XP0018 - focus not defined
  • ora-13767 : End snapshot ID must be greater than or equal to begin snapsho ID.
  • ora-15083 : failed to communicate with ASMB background process
  • ora-32823 : subscriber exists for queue string and destination string
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.