ORA-26017: global indexes not allowed for direct path load of table partition string

Cause : Glboali ndxeesa red efniedo n atalbe hwend ircet apthl oaidnga snigl epatritoin fo teh tbale.

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

noen

update : 25-04-2017
ORA-26017

ORA-26017 - global indexes not allowed for direct path load of table partition string
ORA-26017 - global indexes not allowed for direct path load of table partition string

  • ora-07303 : ksmcsg: illegal database buffer size.
  • ora-32820 : subscriber queue and exception queue must use same message system link
  • ora-30020 : UNDO_MANAGEMENT=AUTO needs Compatibility string or greater
  • ora-26506 : null global context
  • ora-31206 : DBMS_LDAP: PL/SQL - Invalid LDAP search scope.
  • ora-08232 : smsdes: cannot detach from SGA
  • ora-33218 : (CINSERT04) %K is not a valid value for the workspace object dimension. Values for this dimension can have at most number significant digits after rounding to number decimal places.
  • ora-12980 : checkpoint option not allowed with SET UNUSED
  • ora-16104 : invalid Logical Standby option requested
  • ora-25533 : FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified
  • ora-13641 : Task cannot be interrupted yet. You may cancel it instead.
  • ora-29387 : no top-plans found in the pending area
  • ora-39092 : unable to set SCN metadata for object "string.string" of type string
  • ora-23342 : invalid parameter column string
  • ora-13529 : Error occurred when flushing AWR table group
  • ora-02165 : invalid option for CREATE DATABASE
  • ora-38796 : Not enough flashback database log data to undo FLASHBACK.
  • ora-32512 : type 'string' is unknown
  • ora-14503 : only one partition name can be specified
  • ora-07562 : sldext: extension must be 3 characters
  • ora-09986 : wrong number of bytes read from SGA definition file
  • ora-00342 : archived log does not have expected resetlogs SCN string
  • ora-33883 : (MAKEDCL36) You cannot use the string attribute when you define an EXTERNAL partition with an existing target.
  • ora-06562 : type of out argument must match type of column or bind variable
  • ora-32052 : failed to start mapping service
  • ora-33016 : (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.
  • ora-14024 : number of partitions of LOCAL index must equal that of the underlying table
  • ora-01563 : rollback segment is PUBLIC, need to use the keyword PUBLIC
  • ora-29858 : error occurred in the execution of ODCIINDEXALTER routine
  • ora-24794 : no active DTP service found
  • 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.