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 : 28-04-2017
ORA-27483

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

  • ora-09320 : szrfc: unable to obtain the list of valid OS roles
  • ora-12001 : cannot create log: table 'string' already has a trigger
  • ora-07479 : scgcmn: cannot open or convert lock.
  • ora-38454 : attribute set not defined for the column being indexed
  • ora-02262 : ORA-string occurs while type-checking column default value expression
  • ora-16552 : an error occurred when generating the CLIENT OPERATION table
  • ora-19511 : Error received from media manager layer, error text: string
  • ora-37176 : argument string is not valid for the sparsity advisor
  • ora-25103 : NOPARALLEL option can only be used with ALTER INDEX REBUILD
  • ora-30011 : Error simulated: psite=string, ptype=string
  • ora-24404 : connection pool does not exist
  • ora-06000 : NETASY: port open failure
  • ora-02202 : no more tables permitted in this cluster
  • ora-02231 : missing or invalid option to ALTER DATABASE
  • ora-19707 : invalid record block number - string
  • ora-10900 : extent manager fault insertion event #string
  • ora-28604 : table too fragmented to build bitmap index (string,string,string)
  • ora-06133 : NETTCP: file not found
  • ora-30038 : Cannot perform parallel insert on non-partitioned object
  • ora-23405 : refresh group number string does not exist
  • ora-31662 : metadata transform name can not be defaulted
  • ora-00706 : error changing format of file 'string'
  • ora-38422 : invalid datatype for the attribute: string
  • ora-16099 : internal error ORA-00600 occurred at standby database
  • ora-36403 : (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.
  • ora-19239 : XP0019 - step expression must return sequence of nodes
  • ora-10580 : Can not modify datafile header during test recovery
  • ora-12830 : Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE
  • ora-16796 : one or more properties could not be imported from the database
  • ora-32140 : cannot peform this operation on stream
  • 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.