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


update : 23-05-2017

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-14271 : table is not partitioned by Composite Range method
  • ora-01099 : cannot mount database in SHARED mode if started in single process mode
  • ora-00201 : control file version string incompatible with ORACLE version string
  • ora-30968 : invalid XPATH or NAMESPACE option for XML Index
  • ora-25281 : complete reciever information not provided to non-repudiate reciever
  • ora-01591 : lock held by in-doubt distributed transaction string
  • ora-02796 : Done request is not in correct state
  • ora-06011 : NETASY: dialogue too long
  • ora-38405 : quotes not allowed in the attribute set name
  • ora-27550 : Target ID protocol check failed. tid vers=number, type=number, remote instance number=number, local instance number=number
  • ora-19552 : device type string is invalid
  • ora-13837 : invalid HASH_VALUE
  • ora-01875 : time zone minute must be between -59 and 59
  • ora-09890 : osnTXtt: malloc failed
  • ora-09700 : sclin: maximum number of latches exceeded
  • ora-13334 : LRS segments not connected
  • ora-07582 : spstp: ORA_SID has illegal value
  • ora-07629 : smpall: $EXPREG failure
  • ora-19372 : invalid update condition
  • ora-01262 : Stat failed on a file destination directory
  • ora-16659 : failover operation in progress
  • ora-23340 : incorrect resolution method string
  • ora-12073 : request cannot be processed
  • ora-19377 : no "SQL Tuning Set" with name like "string" exists for owner like "string"
  • ora-32507 : expecting string but found string
  • ora-30358 : summary and materialized view are not in same schema
  • ora-36184 : (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
  • ora-31493 : could not prepare session for LogMiner session
  • ora-39052 : cannot specify SKIP_CURRENT on initial start of a job.
  • ora-02424 : potential circular view references or unknown referenced tables
  • 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.