ORA-13009: the specified date string is invalid

Cause : The specified date string has a bad component or does not match the specified format string.

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

Make sure that the components of the date string are valid and that the date and format strings match.

update : 26-04-2017
ORA-13009

ORA-13009 - the specified date string is invalid
ORA-13009 - the specified date string is invalid

  • ora-13019 : coordinates out of bounds
  • ora-10926 : trace name context forever
  • ora-16573 : attempt to change configuration file for an enabled broker configuration
  • ora-13304 : failure to insert a transformed geometry object in a table
  • ora-28330 : encryption is not allowed for this data type
  • ora-19754 : error reading from change tracking file
  • ora-06444 : ssvpstev: Failed with unexpected error number.
  • ora-07224 : sfnfy: failed to obtain file size limit; errno = string.
  • ora-02830 : Segment could not be split - no free segments available
  • ora-02227 : invalid cluster name
  • ora-26752 : Unsupported LCR received for "string"."string"
  • ora-07506 : scgrl: $deq unexpected return on lockid string
  • ora-00273 : media recovery of direct load data that was not logged
  • ora-07251 : spcre: semget error, could not allocate any semaphores.
  • ora-39087 : directory name string is invalid
  • ora-39751 : partitioned table on both sides of PARTITIONED OUTER JOIN is not supported
  • ora-22927 : invalid LOB locator specified
  • ora-09977 : skxfqhini: Error Connecting
  • ora-24317 : define handle used in a different position
  • ora-22611 : TDS version is not recognized
  • ora-30686 : no dispatcher accepted TCP/IP connection request
  • ora-14643 : Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-39175 : Encryption password is not needed.
  • ora-00123 : idle public server terminating
  • ora-38488 : attribute set already assigned to the column storing expressions
  • ora-08313 : sllfop: could not allocate buffers
  • ora-30442 : can not find the definition for filter string
  • ora-28005 : invalid logon flags
  • ora-25106 : only one of PARALLEL or NOPARALLEL clause may be specified
  • ora-27011 : skgfrd: cannot read from file opened for write
  • 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.