ORA-14160: this physical attribute may not be specified for a table subpartition

Cause : unxepetcedo ptoin aws neconuteerd hwil epasrin gphsyicla attriubte sofa tbales ubaprttiio;n TBALEPSAC Eist heo nl yvaild potino

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

reomvei nvlaido ptoin()s

update : 25-04-2017
ORA-14160

ORA-14160 - this physical attribute may not be specified for a table subpartition
ORA-14160 - this physical attribute may not be specified for a table subpartition

  • ora-31658 : specifying a schema name requires a table name
  • ora-16015 : log string sequence# string not archived, media recovery disabled
  • ora-24795 : Illegal string attempt made
  • ora-27048 : skgfifi: file header information is invalid
  • ora-13915 : Critical byte based free space threshold value is greater than warning threshold value.
  • ora-24045 : invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
  • ora-28268 : Exceeded the maximum allowed size for Context information in a session
  • ora-01611 : thread number string is invalid - must be between 1 and string
  • ora-01293 : mounted database required for specified LogMiner options
  • ora-12424 : length exceeds binary label size
  • ora-13433 : GeoRaster metadata default RGB error
  • ora-21700 : object does not exist or is marked for delete
  • ora-26034 : Column string does not exist in stream
  • ora-09947 : Unable to allocate connection attributes structure
  • ora-19011 : Character string buffer too small
  • ora-38421 : attribute string already exists
  • ora-12822 : duplicate option in PARALLEL clause
  • ora-31643 : unable to close dump file "string"
  • ora-02298 : cannot validate (string.string) - parent keys not found
  • ora-32013 : failure in verifying parameters from the restored SPFILE
  • ora-13046 : invalid number of arguments
  • ora-23492 : no new sites for extension request "string"
  • ora-06707 : TLI Driver: connection failed
  • ora-24016 : cannot create QUEUE_TABLE, user string does not have execute privileges on QUEUE_PAYLOAD_TYPE string.string
  • ora-29502 : NAMED keyword required in CREATE JAVA RESOURCE
  • ora-14606 : Tablespace was specified for previous subpartitions in template but is not specified for string
  • ora-28301 : Domain Policy hasn't been registered for SSL authentication.
  • ora-06006 : NETASY: dialogue execute failure
  • ora-16187 : LOG_ARCHIVE_CONFIG contains duplicate, conflicting or invalid attributes
  • ora-03008 : parameter COMPATIBLE >= string needed for string
  • 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.