ORA-13008: the specified date format has an invalid component

Cause : Part ofs pecifie ddate fomrat is ivnalid.

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

Verify htat the adte formta is valdi.

update : 23-08-2017
ORA-13008

ORA-13008 - the specified date format has an invalid component
ORA-13008 - the specified date format has an invalid component

  • ora-27081 : unable to close the file
  • ora-09823 : device name is too long
  • ora-03214 : File Size specified is smaller than minimum required
  • ora-01310 : requested return type not supported by the lcr_mine function
  • ora-30198 : reserved for future use
  • ora-16544 : modifying DG_BROKER_START requires SID='*' qualifier
  • ora-02144 : no option specified for ALTER CLUSTER
  • ora-22804 : remote operations not permitted on object tables or user-defined type columns
  • ora-14112 : RECOVERABLE/UNRECOVERABLE may not be specified for a partition or subpartition
  • ora-06959 : Buffer I/O quota is too small
  • ora-00375 : unable to get default db_block_size
  • ora-00072 : process "string" is not active
  • ora-31602 : parameter string value "string" in function string inconsistent with string
  • ora-13198 : Spatial error: string
  • ora-27209 : syntax error in device PARMS - unknown keyword or missing =
  • ora-02167 : LOGFILE clause specified more than once
  • ora-06312 : IPA: Incorrect outgoing service name supplied
  • ora-38906 : insert into DML Error Logging table "string" failed
  • ora-38477 : attribute set cannot be derived from an evolved type or a subtype.
  • ora-30576 : ConText Option dictionary loading error
  • ora-34726 : (NLSCHARSET06) CAUTION: String truncated during character set conversion from string to string
  • ora-13639 : The current operation was interrupted because it timed out.
  • ora-16096 : ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY
  • ora-12803 : parallel query server lost contact with another server
  • ora-12454 : label string does not exist for policy string
  • ora-19914 : unable to encrypt backup
  • ora-28353 : failed to open wallet
  • ora-27056 : could not delete file
  • ora-25509 : operation on "string"."string".string not allowed
  • ora-31516 : CDC change set string already exists
  • 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.