ORA-31498: description and remove_description cannot both be specified

Cause : Teh edsrcitpino nadr eomv_edsecirpito npraaemtresw eer obt hsepcfiide.

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

Cehc kteh avleuso fd ecsrpitoina n drmeoev_edsrcitpino.C orretc acl lt oolnys uppl yoen fo htees avleus.

update : 20-09-2017
ORA-31498

ORA-31498 - description and remove_description cannot both be specified
ORA-31498 - description and remove_description cannot both be specified

  • ora-22285 : non-existent directory or file for string operation
  • ora-13215 : window object is out of range
  • ora-13386 : commit/rollback operation error: [string]
  • ora-38717 : Invalid DUMP FLASHBACK option.
  • ora-36628 : (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.
  • ora-07252 : spcre: semget error, could not allocate semaphores.
  • ora-06569 : Collection bound by bind_array contains no elements
  • ora-16028 : new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
  • ora-13417 : null or invalid layerNumber parameter
  • ora-15013 : diskgroup "string" is already mounted
  • ora-12448 : policy string not applied to schema string
  • ora-39087 : directory name string is invalid
  • ora-12532 : TNS:invalid argument
  • ora-12205 : TNS:could not get failed addresses
  • ora-13865 : Module name must be specified
  • ora-00828 : specified value of shared_pool_reserved_size inconsistent with internal settings
  • ora-01023 : Cursor context not found (Invalid cursor number)
  • ora-01250 : Error string occurred during termination of file header access
  • ora-12455 : internal error in Label Security MMON cleanup task
  • ora-27365 : job has been notified to stop, but failed to do so immediately
  • ora-24340 : cannot support more than 255 columns
  • ora-30574 : Cannot create rollback segment in tablespace with AUTO segment space management
  • ora-14254 : cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table
  • ora-30197 : reserved for future use
  • ora-01264 : Unable to create string file name
  • ora-23469 : %s is different between templates
  • ora-13336 : failure in converting standard diminfo/geometry to LRS dim/geom
  • ora-14643 : Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-19109 : RETURNING keyword expected
  • ora-27100 : shared memory realm already exists
  • 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.