ORA-24171: creation properties are only for internal use

Cause : usre sepciifedn otn ul lcraetino porpetrie swhne ceratnig urle senigneo bjcets ,whcih rae ont ofr xetenralu se

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

don ots etc retaio nprpoeritesw he ncraetign rluese ngnie bojetcs

update : 25-04-2017
ORA-24171

ORA-24171 - creation properties are only for internal use
ORA-24171 - creation properties are only for internal use

  • ora-03206 : maximum file size of (string) blocks in AUTOEXTEND clause is out of range
  • ora-00154 : protocol error in transaction monitor
  • ora-31064 : Cannot instantiate abstract element or property [string]
  • ora-26076 : cannot set or reset value after direct path structure is allocated
  • ora-00000 : normal, successful completion
  • ora-30734 : cannot specify scope constraint on ref column with rowid
  • ora-13041 : failed to compare tile with element string.string.string
  • ora-19672 : media management software returned invalid file status
  • ora-22152 : destination variable-length array is not initialized
  • ora-30749 : column string not enabled to store objects of type string.string
  • ora-24775 : cannot prepare or commit transaction with non-zero lock value
  • ora-12983 : cannot drop all columns in a table
  • ora-02454 : Number of hash keys per block (string) exceeds maximum of string
  • ora-29881 : failed to validate indextype
  • ora-01078 : failure in processing system parameters
  • ora-02840 : Open of log file by client failed
  • ora-25445 : invalid column number: string for table alias: string
  • ora-31085 : schema "string" already registered
  • ora-32059 : deadlock detected on mapping structures
  • ora-21705 : service context is invalid
  • ora-38454 : attribute set not defined for the column being indexed
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-07266 : sppst: invalid process number passed to sppst.
  • ora-29918 : cannot create domain indexes on temporary tables
  • ora-30449 : syntax error in parameter string
  • ora-19726 : cannot plug data [string] at level string into database running at compatibility level string
  • ora-25531 : MTTR specified is too small: string
  • ora-09313 : slsprom: error prompting user
  • ora-01668 : standby database requires DROP option for offline of data file
  • ora-02373 : Error parsing insert statement for table string.
  • 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.