ORA-27483: "string.string" has an invalid END_DATE

Cause : A nattepmtw a smdaet oe nbal eaj o bo rwnidwo hta thsa na nivlai dedn_adt.e iEtehrt h eedn_adt ei sbfeoer htes tratd_aet ro htee n_ddtaei si nt h epsat.

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

Atle rteh ojbo rw idno ws otahtt h eedn adt ebceoemsv aild( psosbil ynlul )adn hte nriesuset h ecmomnad.

update : 20-08-2017

ORA-27483 - "string.string" has an invalid END_DATE
ORA-27483 - "string.string" has an invalid END_DATE

  • ora-38423 : Attribute set created from an ADT may not be extended.
  • ora-29324 : SET COMPATIBILITY release string format is wrong
  • ora-24354 : number fetched too large to fit in COBOL display type buffer.
  • ora-06031 : NETDNT: connect failed, unrecognized object name
  • ora-28365 : wallet is not open
  • ora-29296 : invalid encoded string
  • ora-19107 : invalid XQueryX - unsupported construct - string
  • ora-01097 : cannot shutdown while in a transaction - commit or rollback first
  • ora-14455 : attempt to create referential integrity constraint on temporary table
  • ora-16779 : the destination parameter of a database is set incorrectly
  • ora-12593 : TNS:no registered connection
  • ora-26097 : unsupported conversion for column string (from type number to type number)
  • ora-38473 : cannot drop a type used for Expression Filter attribute set
  • ora-10641 : Cannot find a rollback segment to bind to
  • ora-32006 : %s initialization parameter has been deprecated
  • ora-21603 : property id [string] is invalid
  • ora-29356 : These parameters can be specified only for directives that refer to consumer groups
  • ora-10642 : Found rollback segments in dictionary managed tablespaces
  • ora-08111 : a partitioned index may not be coalesced as a whole
  • ora-01280 : Fatal LogMiner Error.
  • ora-23621 : Operation corresponding to script string is in progress.
  • ora-01224 : group number in header string does not match GROUP string
  • ora-32844 : exceeded maximum number of string values
  • ora-25316 : Late in the current transaction to begin an Enqueue/Dequeue operation
  • ora-32154 : Anydata context not specified
  • ora-28514 : heterogeneous database link initialization could not convert system date
  • ora-38762 : thread string redo log with scn string could not be found
  • ora-13332 : invalid LRS point
  • ora-38425 : attribute set used for an index object may not be unassigned
  • ora-36995 : (XSRELGID12) There are duplicate values in the surrogate dimension gid. Use the levelorder option to resolve the ambiguity.
  • 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.