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 : 26-07-2017
ORA-13008

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

  • ora-06802 : TLI Driver: could not open the /etc/netware/yellowpages file
  • ora-23348 : cannot replicate procedure string; only IN parameters supported
  • ora-30158 : The OCIFileWrite causes the file to exceed the maximum allowed size
  • ora-16652 : Fast-Start Failover target standby database is disabled
  • ora-30006 : resource busy; acquire with WAIT timeout expired
  • ora-24173 : nested query not supported for rule condition
  • ora-33016 : (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.
  • ora-25462 : evaluation context not specified
  • ora-27163 : out of memory
  • ora-30506 : system triggers cannot be based on tables or views
  • ora-39115 : %s is not supported over a network link
  • ora-38468 : column "string" is not identified as a column storing expressions.
  • ora-13799 : threshold not found
  • ora-39112 : Dependent object type string skipped, base object type string creation failed
  • ora-33922 : (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.
  • ora-34358 : (MXDSS14) number other users reading
  • ora-37076 : (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT, NTEXT, ID, NUMBER, and CONCAT with the UNIQUE attribute.
  • ora-01697 : control file is for a clone database
  • ora-14190 : only one ENABLE/DISABLE ROW MOVEMENT clause can be specified
  • ora-13296 : incorrect coordinate system specification
  • ora-07244 : ssfccf: create file failed, file size limit reached.
  • ora-14071 : invalid option for an index used to enforce a constraint
  • ora-12527 : TNS:listener: all instances are in restricted mode or blocking new connections
  • ora-15169 : destination 'string' is a subdirectory of 'string'
  • ora-12511 : TNS:service handler found but it is not accepting connections
  • ora-09798 : Label comparison failed.
  • ora-32843 : value for string is outside the valid range of string to string
  • ora-31059 : Cannot insert root XML document node if it already exists
  • ora-13186 : fixed tile size tessellation failed
  • ora-37600 : (XSPGERRPERMDETACH) Parallel updating analytic workspace string failed
  • 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.