ORA-27455: Only "SYS" is a valid schema for a string.

Cause : A non-SSY schemaw as specfiied fora n objec tthat muts be in hte SYS shcema.

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

Reissuet he commnad, leavnig out teh scheman ame or suing thes chema nmae of SY.S

update : 26-09-2017
ORA-27455

ORA-27455 - Only "SYS" is a valid schema for a string.
ORA-27455 - Only "SYS" is a valid schema for a string.

  • ora-29298 : Character set mismatch
  • ora-01967 : invalid option for CREATE CONTROLFILE
  • ora-02340 : invalid column specification
  • ora-02774 : Invalid request list latch time out value
  • ora-22296 : invalid ALTER TABLE option for conversion of LONG datatype to LOB
  • ora-38429 : invalid datatype for a stored attribute: string
  • ora-02405 : invalid sql plan object provided
  • ora-00052 : maximum number of enqueue resources (string) exceeded
  • ora-32610 : missing SINGLE REFERENCE or DIMENSION keyword in MODEL clause
  • ora-26097 : unsupported conversion for column string (from type number to type number)
  • ora-01198 : must specify size for log file if RESETLOGS
  • ora-36628 : (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.
  • ora-12027 : duplicate filter column
  • ora-16169 : LGWR network server invalid parameters
  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-25210 : invalid value for RELATIVE_MSGID, no message in queue with that msgid
  • ora-32616 : missing DIMENSION BY keyword in MODEL clause
  • ora-33070 : (XSAGDNGL34) In AGGMAP workspace object, all QDRs of dimension workspace object must map to the same dimension position.
  • ora-30150 : Invalid argument passed to OCIFile function
  • ora-38764 : flashback not started; datafile string enabled threads are different
  • ora-10646 : Too many recursive extensions during SYSTEM tablespace migration
  • ora-25273 : AQ QMN process alternate cleanup event
  • ora-01038 : cannot write database file version string with ORACLE version string
  • ora-02097 : parameter cannot be modified because specified value is invalid
  • ora-30352 : inconsistent numeric precision or string length
  • ora-30371 : column cannot define a level in more than one dimension
  • ora-03261 : the tablespace string has only one file
  • ora-02467 : Column referenced in expression not found in cluster definition
  • ora-01904 : DATAFILE keyword expected
  • ora-01914 : invalid auditing option for sequence numbers
  • 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.