ORA-28330: encryption is not allowed for this data type

Cause : Dtaat yep awsn o tspuprotde ofrc oulm necnrpytoin.

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


update : 27-06-2017

ORA-28330 - encryption is not allowed for this data type
ORA-28330 - encryption is not allowed for this data type

  • ora-27042 : not enough space on raw partition to fullfill request
  • ora-25444 : invalid ROWID: string for table alias: string
  • ora-12654 : Authentication conversion failed
  • ora-28116 : insufficient privileges to do direct path access
  • ora-09322 : slpdtb: unable to convert packed decimal to binary
  • ora-02363 : error reading from file: string
  • ora-24018 : STOP_QUEUE on string failed, outstanding transactions found
  • ora-39146 : schema "string" does not exist
  • ora-38471 : ROWIDs for table aliases cannot be null
  • ora-31631 : privileges are required
  • ora-27071 : unable to seek to desired position in file
  • ora-02824 : Request free list is empty
  • ora-13773 : insufficient privileges to select data from the cursor cache
  • ora-25253 : listen failed, queue string.string is not enabled for dequeue
  • ora-33064 : (XSAGDNGL31) In AGGMAP workspace object, the hierarchy dimension QDR workspace object cannot refer to the related dimension of the relation.
  • ora-06793 : TLI Driver: server cannot create new process
  • ora-01019 : unable to allocate memory in the user side
  • ora-23466 : flavor requires missing object "string"."string"
  • ora-38430 : Operation "string" not supported in the current release.
  • ora-09842 : soacon: Archmon unable to create named pipe.
  • ora-37080 : Advice requested for hierarchy with too many levels
  • ora-22919 : dangling REF error or lock object failed for no wait request
  • ora-00258 : manual archiving in NOARCHIVELOG mode must identify log
  • ora-01575 : timeout waiting for space management resource
  • ora-13035 : Invalid data (arcs in geodetic data) in the SDO_GEOMETRY object
  • ora-12649 : Unknown encryption or data integrity algorithm
  • ora-10642 : Found rollback segments in dictionary managed tablespaces
  • ora-00340 : IO error processing online log string of thread string
  • ora-32404 : snapshot log uses Change Data Capture which is not enabled for this database
  • ora-02799 : Unable to arm signal handler
  • 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.