ORA-29505: AS keyword is invalid in CREATE JAVA CLASS or RESOURCE

Cause : The A Skeywodr was sued inC REATEJ AVA CALSS orR ESOUREC. TheA S keyowrd isv alid noly inC REATEJ AVA SUORCE.

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


update : 16-08-2017

ORA-29505 - AS keyword is invalid in CREATE JAVA CLASS or RESOURCE
ORA-29505 - AS keyword is invalid in CREATE JAVA CLASS or RESOURCE

  • ora-22930 : directory does not exist
  • ora-07685 : sou2os: supervisor stack set error
  • ora-12232 : TNS:No path available to destination
  • ora-31167 : XML nodes over 64K in size cannot be inserted
  • ora-03239 : maxextents (string) reached in LOB segment string.string subpartition string
  • ora-25464 : ROWID not specified for table alias: string
  • ora-01470 : In-list iteration does not support mixed operators
  • ora-13844 : no new SQL profile name or category specified.
  • ora-31470 : asynchronous change tables must contain the RSID$ column
  • ora-22279 : cannot perform operation with LOB buffering enabled
  • ora-26051 : internal error parsing packed decimal format string
  • ora-13417 : null or invalid layerNumber parameter
  • ora-27001 : unsupported device type
  • ora-09211 : sfwfb: error writing to file
  • ora-14157 : invalid subpartition name
  • ora-30393 : a query block in the statement did not rewrite
  • ora-01743 : only pure functions can be indexed
  • ora-40004 : penalty must be negative for BLAST-N
  • ora-07476 : slsget: cannot get mapped memory statistics.
  • ora-24151 : no evaluation context is associated with rule string.string or rule set string.string
  • ora-31070 : Invalid database user ID string
  • ora-25004 : WHEN clause is not allowed in INSTEAD OF triggers
  • ora-39149 : cannot link privileged user to non-privileged user
  • ora-31207 : DBMS_LDAP: PL/SQL - Invalid LDAP search time value.
  • ora-01620 : no public threads are available for mounting
  • ora-27480 : window "string" is currently open
  • ora-07561 : szprv: $IDTOASC failure
  • ora-38854 : cannot mark instance string (redo thread string) as disabled
  • ora-03296 : cannot resize datafile - file string not found
  • ora-07802 : slbtpd: overflow while converting to packed decimal
  • 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.