ORA-26033: column string.string encryption properties differ for source or target table

Cause : Thes ourec an ddesitnatoin cloumn sdidn ot ahve hte smae * enrcyptoin porperites.

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

Fors ecuirty erasosn, cehck htat hte suorcea nd atrge ttabel haev *thes amee ncrpytio nproeprtise. *

update : 24-05-2017

ORA-26033 - column string.string encryption properties differ for source or target table
ORA-26033 - column string.string encryption properties differ for source or target table

  • ora-15042 : ASM disk "string" is missing
  • ora-27509 : IPC error receiving a message
  • ora-16651 : requirements not met for enabling Fast-Start Failover
  • ora-01635 : rollback segment #string specified not available
  • ora-02843 : Invalid value for kernel flag
  • ora-25330 : PL/SQL associative arrays may not be used with AQ array operations
  • ora-14138 : An unexpected error encountered during drop table operation
  • ora-24063 : cannot downgrade QUEUE_TABLE that has queues with rule-based subscribers
  • ora-13786 : missing SQL text of statement object "string" for tuning task "string"
  • ora-16570 : operation requires restart of database "string"
  • ora-04933 : initial service identifier is non-zero
  • ora-01101 : database being created currently mounted by some other instance
  • ora-21615 : an OTS (named or simple) instance failed
  • ora-19639 : file string is more current than this incremental backup
  • ora-00472 : PMON process terminated with error
  • ora-06927 : CMX: T_DATAIN received before all data written
  • ora-13699 : Advisor feature is not currently implemented.
  • ora-29876 : failed in the execution of the ODCIINDEXDELETE routine
  • ora-30048 : Internal event for IMU auto-tuning
  • ora-12631 : Username retrieval failed
  • ora-23466 : flavor requires missing object "string"."string"
  • ora-28000 : the account is locked
  • ora-00280 : change string for thread string is in sequence #string
  • ora-16163 : LGWR network server host attach error
  • ora-36224 : (XSLPDSC05) workspace object is not a loop dimension
  • ora-31011 : XML parsing failed
  • ora-27023 : skgfqsbi: media manager protocol error
  • ora-08446 : syntax error in SYNCHRONIZED clause in mask options
  • ora-16594 : %s process discovered that DMON process does not exist
  • ora-30742 : cannot grant SELECT privilege WITH HIERARCHY OPTION on this object
  • 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.