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 : 18-08-2017
ORA-26033

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-37106 : (XSVPART06) Invalid partition name number.
  • ora-15205 : requested mirror side unavailable
  • ora-19681 : block media recovery on control file not possible
  • ora-12700 : invalid NLS parameter value (string)
  • ora-38481 : ADT "string" is used for a dependent object.
  • ora-31075 : invalid string declaration in XML Schema
  • ora-24773 : invalid transaction type flags
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-01093 : ALTER DATABASE CLOSE only permitted with no sessions connected
  • ora-32104 : cannot retrieve OCI error message
  • ora-02424 : potential circular view references or unknown referenced tables
  • ora-01609 : log string is the current log for thread string - cannot drop members
  • ora-01492 : LIST option not valid
  • ora-38773 : cannot add data file 'string' - file already part of database
  • ora-10656 : Table is in unusable state due to incomplete operation
  • ora-22297 : warning: Open LOBs exist at transaction commit time
  • ora-19273 : XQ0053 - empty string in namespace declaration
  • ora-13117 : [string]_RELATION$ table does not exist
  • ora-01334 : invalid or missing logminer dictionary processes context
  • ora-12615 : TNS:preempt error
  • ora-33052 : (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.
  • ora-31679 : Table data object string has long columns, and longs can not be loaded/unloaded using a network link
  • ora-36920 : (XSVPMVTOPART01) workspace object cannot become anonymous because it has properties.
  • ora-38460 : filtering based on datatype "string" not supported for XML Tags
  • ora-12070 : cannot offline instantiate materialized view "string"."string"
  • ora-01623 : log string is current log for instance string (thread string) - cannot drop
  • ora-02438 : Column check constraint cannot reference other columns
  • ora-16196 : database has been previously opened and closed
  • ora-01417 : a table may be outer joined to at most one other table
  • ora-02435 : cannot disable unique(string) - unique key not defined for table
  • 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.