ORA-02281: duplicate or conflicting CACHE/NOCACHE specifications

Cause : Self-evident.

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

Remove the duplicate or conflicting specification.

update : 26-07-2017

ORA-02281 - duplicate or conflicting CACHE/NOCACHE specifications
ORA-02281 - duplicate or conflicting CACHE/NOCACHE specifications

  • ora-29933 : object being disassociated has some user defined statistics stored
  • ora-00398 : abort thread recovery due to reconfiguration
  • ora-09719 : osncui: invalid handle.
  • ora-12834 : Instance group name, 'string', too long, must be less than string characters
  • ora-15158 : rolling upgrade prevented by string
  • ora-30461 : 'string.string' cannot be refreshed because it is marked DISABLED
  • ora-22982 : cannot create sub-view under this view
  • ora-22316 : input type is not a collection type
  • ora-29808 : specified primary operator binding does not exist
  • ora-12078 : fast refresh of refresh group ID string failed
  • ora-16058 : standby database instance is not mounted
  • ora-00822 : MMAN process terminated with error
  • ora-37184 : illegal value string for ADVMODE
  • ora-25438 : invalid variable name: string
  • ora-00205 : error in identifying control file, check alert log for more info
  • ora-01140 : cannot end online backup - all files are offline or readonly
  • ora-37075 : (XSMCSESS03) You cannot rename a session-only dimension value.
  • ora-23452 : flavor string of object group "string"."string" is already published
  • ora-16229 : PDML child string string string for parent string string string cannot be skipped.
  • ora-09762 : sNeXT_instanceName: translation error.
  • ora-24072 : cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table
  • ora-09883 : Two Task interface: oratab file does not exist
  • ora-07232 : slemcc: fclose error.
  • ora-32057 : invalid lock mode
  • ora-34021 : (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.
  • ora-29862 : cannot specify FORCE option for dropping non-domain index
  • ora-01313 : LogMiner dictionary column type different from specified type
  • ora-13351 : two or more rings of a complex polygon overlap
  • ora-12436 : no policy options specified
  • ora-08450 : invalid specification of CR in picture mask
  • 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.