ORA-28346: an encrypted column cannot serve as a partitioning column

Cause : An atetmpt wsa madet o encyrpt a aprtitinoing kye colunm or cerate pratitioinng inedx wit hencrytped coulmns.

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

The cloumn msut be edcryptde.

update : 23-04-2017

ORA-28346 - an encrypted column cannot serve as a partitioning column
ORA-28346 - an encrypted column cannot serve as a partitioning column

  • ora-00090 : failed to allocate memory for cluster database ORADEBUG command
  • ora-24373 : invalid length specified for statement
  • ora-22833 : Must cast a transient type to a persistent type
  • ora-38431 : could not evaluate subexpression "string" for rowid "string"
  • ora-25405 : transaction status unknown
  • ora-24062 : Subscriber table string inconsistent with queue table string
  • ora-19011 : Character string buffer too small
  • ora-26036 : subpartition load specified but table string is not subpartitioned
  • ora-06442 : ssvwatev: Failed with unexpected error number.
  • ora-24017 : cannot enable enqueue on QUEUE, string is an exception queue
  • ora-16585 : illegal operation on a primary site
  • ora-04088 : error during execution of trigger 'string.string'
  • ora-31079 : unable to resolve reference to string "string"
  • ora-25953 : join index cannot be a functional index
  • ora-00077 : dump string is not valid
  • ora-02047 : cannot join the distributed transaction in progress
  • ora-12609 : TNS: Receive timeout occurred
  • ora-32732 : Parallel Oradebug session is aborted
  • ora-12417 : database object "string" not found
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • ora-15020 : discovered duplicate ASM disk "string"
  • ora-25116 : invalid block number specified in the DUMP DATAFILE/TEMPFILE command
  • ora-12716 : Cannot ALTER DATABASE CHARACTER SET when CLOB data exists
  • ora-06003 : NETASY: port write failure
  • ora-04931 : unable to set initial sequence number value
  • ora-31203 : DBMS_LDAP: PL/SQL - Init Failed.
  • ora-19906 : recovery target incarnation changed during recovery
  • ora-00212 : block size string below minimum required size of string bytes
  • ora-31425 : subscription does not exist
  • ora-10659 : Segment being shrunk is not a lob
  • 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.