{"id":1919,"date":"2016-04-23T10:08:29","date_gmt":"2016-04-23T07:08:29","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1919"},"modified":"2016-10-26T10:10:30","modified_gmt":"2016-10-26T07:10:30","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-14500-to-ora-14700","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-14500-to-ora-14700\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-14500 to ORA-14700"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-14500 to ORA-14700<\/strong><\/p>\n

\n
ORA-14500: LOCAL option not valid without partition name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Incorrect syntax specified<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the command<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14501: object is not partitioned<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Table or index is not partitioned. Invalid syntax.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the command with correct syntax.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14503: only one partition name can be specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0More than one partition name has been specified for analyze<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify one partition name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14504: syntax not supported for analyze<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A partition\/subpartition number or bind variable has been used<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a valid partition\/subpartition name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14505: LOCAL option valid only for partitioned indexes<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Incorrect syntax specified<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the command<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14506: LOCAL option required for partitioned indexes<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Incorrect syntax specified<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the command<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14507: partition corrupt. all rows do not fall within partition bounds<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The partition contains rows which should really be in some other partition. Possibly due to an exchange partition without validation<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Delete rows in partition which do not qualify<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14508: specified VALIDATE INTO table not found<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified table either does not exist or user does not have the proper privleges.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the correct table to use.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14509: specified VALIDATE INTO table form incorrect<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified table does not have the proper field definitions.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify the correct table to use. See utlvalid.sql for more information.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14510: can specify VALIDATE INTO clause only for partitioned tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The VALIDATE INTO has been specified for a non partitioned table or cluster or index.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use syntax correctly<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14511: cannot perform operation on a partitioned object<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform an operation that is not allowed on partitioned tables or indexes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the command with correct syntax.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14512: cannot perform operation on a clustered object<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to perform an operation that is not allowed on clustered tables or indexes.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the command with correct syntax.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14513: partitioning column may not be of object datatype<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Partitioning column specified by the user was an object datatype (object, REF, nested table, array) which is illegal.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that no partitioning column is an object datatype.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14514: LOCAL option not valid without subpartition name<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Incorrect syntax specified<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the command<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14515: only one aubpartition name can be specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0More than one subpartition name has been specified for analyze<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify one subpartition name.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-14516: subpartition corrupt. all rows do not fall within subpartition bounds<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The subpartition contains rows which should really be in some other subpartition. Possibly due to an exchange subpartition without validation<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Delete rows in subpartition which do not qualify<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14517: subpartition of index ‘string<\/i>.string<\/i>‘ is in unusable state<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt has been made to access an index subpartition that has been marked unusable by a direct load or by a DDL operation<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0REBUILD the unusable index subpartition<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14518: partition contains rows corresponding to values being dropped<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0table partition contains rows for the values being dropped.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0DELETE all rows for the values being dropped and reissue statement<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14519: Conflicting tablespace blocksizes for\u00a0string<\/i>\u00a0string<\/i>: Tablespace\u00a0string<\/i>\u00a0block size\u00a0string<\/i>\u00a0[string<\/i>] conflicts with previously specified\/implied tablespace\u00a0string<\/i>\u00a0block size\u00a0string<\/i>[string<\/i>]<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt has been made to create a partitioned object in a manner that would require the partitioned object to span tablespaces of more than one block size.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that all tablespaces specified in the DDL command for the given object as well as any tablespaces implicitly assigned to partitions or subpartitions of the object being created are all of the same block size.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14520: Tablespace\u00a0string<\/i>\u00a0block size [string<\/i>] does not match existing object block size [string<\/i>]<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A DDL statement was issued that would require a tablespace of a block size different from the block size of the specified partitioned object to be assigned either: (1) As the object’s default tablespace (or one of the object’s partition-level default tablespaces, if composite partitioning is being used) OR (2) To one of the object’s partitions\/subpartitions.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a tablespace of the same block size as the partitioned object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14521: Default tablespace\u00a0string<\/i>\u00a0block size [string<\/i>] for\u00a0string<\/i>\u00a0string<\/i>\u00a0does not match existing\u00a0string<\/i>\u00a0block size [string<\/i>]<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A DDL statement was issued that would require creation of a new partition\/subpartition in the object-level default tablespace of an existing partitioned object. However, the object-level default tablespace block size does not match the block size of the partitioned object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either (1) Modify the default tablespace of the partitioned object to a tablespace of the same block size as the object and then retry the DDL command, OR (2) Ensure that tablespaces of the correct block size are specified for all new partitions\/subpartitions being created.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14522: Partition-level default tablespace\u00a0string<\/i>\u00a0block size [string<\/i>] for\u00a0string<\/i>\u00a0string<\/i>\u00a0does not match existing\u00a0string<\/i>\u00a0block size [string<\/i>]<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A DDL statement was issued that would require creation of a new subpartition in one of the partition-level default tablespaces of an existing composite partitioned object. However, the partition-level default tablespace block size does not match the block size of the partitioned object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either (1) Modify the partition-level default tablespace of the appropriate partition of the partitioned object to a tablespace of the same block size as the object and then retry the DDL command, OR (2) Ensure that tablespaces of the correct block size are specified for all new subpartitions being created.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14523: Cannot co-locate [sub]partition of\u00a0string<\/i>\u00a0string<\/i>\u00a0with table [sub]partition because\u00a0string<\/i>\u00a0block size [string<\/i>] does not match table block size [string<\/i>]<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A DDL statement was issued that would require a partition\/subpartition of a local index\/LOB column to be co-located with the corresponding partition\/subpartition of the base table. However, this is not possible because the block sizes of the table and the LOB column\/local index are different.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either (1) Specify an object-level default tablespace (or partition-level default tablespace for the appropriate partition, if composite partitioning is used) for the partitioned local index\/LOB column and then retry the DDL command, OR (2) Ensure that tablespaces of the correct block size are specified for all new partitions\/subpartitions being created. Also ensure that neither of TABLESPACE DEFAULT and STORE IN (DEFAULT) is specified for a local index whose block size does not match that of the base table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14530: row mismatches found in table\u00a0string<\/i>.string<\/i>\u00a0and index\u00a0string<\/i>.string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0rows in table and index inconsistent<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0run complete analyze to determine corrupt rows<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14551: cannot perform a DML operation inside a query<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0DML operation like insert, update, delete or select-for-update cannot be performed inside a query or under a PDML slave.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the offending DML operation is not performed or use an autonomous transaction to perform the DML operation within the query or PDML slave.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0DDL operations like creation tables, views etc. and transaction control statements such as commit\/rollback cannot be performed inside a query or a DML statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the offending operation is not performed or use autonomous transactions to perform the operation within the query\/DML operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14553: cannot perform a lob write operation inside a query<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A lob write operation cannot be performed inside a query or a PDML slave.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the offending lob write operation is not performed or use an autonomous transaction to perform the operation within the query or PDML slave.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14554: cannot perform requested operation during database startup<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Requested operation requires the Cost Based Optimizer(CBO) which is not available during database startup. Features like partitioning, IOTs, grouping sets, and flashback cursor require the CBO.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the query after the database is open.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14601: Illegal to specify SUBPARTITIONS or STORE-IN while specifying a subpartition template<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Cannot specify these clauses while specifying a template<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the subpartition template clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14602: SUBPARTITION TEMPLATE is legal only for a composite partitioned table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0SUBPARTITION TEMPLATE can be specified only for composite partitioned tables<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not use SUBPARTITION TEMPLATE on non-partitioned or non-composite partitioned tables.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14603: [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This syntax is valid only if subpartitioning dimension is hash<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14604: During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Once a subpartition template has been specified during a CREATE TABLE it is illegal to specify SUBPARTITIONS or STORE IN anywhere else<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove either the SUBPARTITIONS | STORE IN or remove the SUBPARTITION TEMPLATE clause<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14605: Name missing for subpartition \/ lob segment in template<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A subpartition \/ lob segment was not specified a name in the template descriptions<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0All subpartitions \/ lob segments must have names specified in the template<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14606: Tablespace was specified for previous subpartitions in template but is not specified for\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Tablespaces may either be specified for all subpartitions or must not be specified for any subpartitions<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either specify tablespaces for all or for none of the subpartitions<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14607: Tablespace was not specified for previous subpartitions in template but is specified for\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Tablespaces may either be specified for all subpartitions or must not be specified for any subpartitions<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either specify tablespaces for all or for none of the subpartitions<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14608: Tablespace was specified for the previous lob segments of column\u00a0string<\/i>\u00a0in template but is not specified for\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Tablespaces may either be specified for all lob segments of a column or must not be specified for any lob segments of this column<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either specify tablespaces for all or for none of the lob segments<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14609: Tablespace was not specified for the previous lob segments of column\u00a0string<\/i>\u00a0in template but is specified for\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Tablespaces may either be specified for all lob segments of a column or must not be specified for any lob segments of this column<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Either specify tablespaces for all or for none of the lob segments<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14610: Lob attributes not specified for lob column\u00a0string<\/i>\u00a0for subpartition\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Lob attributes of a column must be specified for all subpartitions or must not be specified at all<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure lob attributes of a column are specified for all subpartitions or not specified at all<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14611: Duplicate subpartition name\u00a0string<\/i>\u00a0in template<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A subpartition name cannot be duplicated within the template<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Rename one of the subpartitions.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14612: Duplicate lob segment name\u00a0string<\/i>\u00a0for lob column\u00a0string<\/i>\u00a0in template<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Two lob segments of the same column were given the same name in the template<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Rename one of the lob segments<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14613: Attempt to generate name from parent name\u00a0string<\/i>\u00a0and template name\u00a0string<\/i>\u00a0failed as the combine named would have been longer than allowed<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Any name generated from a partition name and template name must be less than the maximum permissible name for an identifier<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Shorten either partition or template name.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14614: List value ‘string<\/i>‘ specified twice in subpartition ‘string<\/i>‘<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A list value cannot be specified more that once<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove one of the specifications of the value<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14615: List value ‘string<\/i>‘ specified twice in subpartitions ‘string<\/i>‘, ‘string<\/i>‘<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A list value cannot be specified more that once<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove one of the specifications of the value<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14616: table is not subpartitioned by List method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A subpartition maintenance operation, such as ALTER TABLE MODIFY SUBPARTITION ADD|DROP VALUES, was performed on a non-List subpartitioned object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reissue the command against a List subpartitioned object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14617: cannot add\/drop values to DEFAULT subpartition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A ADD\/DROP VALUES operation is being done on the default subpartition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that ADD\/DROP VALUES is not done on the DEFAULT subpartition<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14618: cannot drop the last value of subpartition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER TABLE DROP VALUES tried to drop the last value of the subpartition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Cannot execute the command, unless two or more values exist for subpartition<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14619: resulting List subpartition(s) must contain at least 1 value<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0After a SPLIT\/DROP VALUE of a list subpartition, each resulting subpartition(as applicable) must contain at least 1 value<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that each of the resulting subpartitions contains atleast 1 value<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14620: DEFAULT subpartition already exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A subpartition already exists with DEFAULT value<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the DEFAULT value from the list specified<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14621: cannot add subpartition when DEFAULT subpartition exists<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An ADD SUBPARTITION operation cannot be executed when a subpartition with DEFAULT values exists<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Issue a SPLIT of the DEFAULT subpartition instead<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14622: Value\u00a0string<\/i>\u00a0already exists in subpartition\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One of the list values in the ADD SUBPARTITION or ADD VALUES statement already exists in another subpartition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the duplicate value from the statement and try again<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14623: Value\u00a0string<\/i>\u00a0does not exist in subpartition\u00a0string<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0One of the list values in the SPLIT PARTITION or DROP VALUES statement does not exist in the subpartition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the value from the statement and try again<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14624: DEFAULT subpartition must be last subpartition specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A subpartition description follows the one describing the default subpartition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the DEFAULT subpartition is the last subpartition description<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14625: subpartition contains rows corresponding to values being dropped<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0table subpartition contains rows for the values being dropped.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0DELETE all rows for the values being dropped and reissue statement<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14626: values being added already exist in DEFAULT subpartition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An ADD VALUE operation cannot be executed because the values being added exist in the DEFAULT subpartition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Issue a SPLIT of the DEFAULT subpartition and then MERGE the split subpartition into the subpartition to which values need to be added<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14627: Invalid operation was specified on a GLOBAL partitioned index<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid operation such as ALTER INDEX DROP|SPLIT SUBPARTITION was specified on the global index<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that subpartition level operations are not specified on a GLOBAL index, since these are only RANGE partitioned<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14628: specification of bounds is inconsistent with LIST method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An operation such as ALTER TABLE SPLIT|ADD SUBPARTITION specified bounds that were inconsistent with List subpartitioning method<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify VALUES\/subpartition descriptions correctly for SPLIT\/ADD of List subpartitions<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14629: cannot drop the only subpartition of a partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A drop subpartition command is being executed when there is only one subpartition in the partition<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14630: subpartition resides in offlined tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted an operation requiring that we access data in a subpartition which resides in a tablespace which was taken offline. Such operations include trying to drop a tablespace of a table which has indices defined on it or is referenced by a constraint.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Bring tablespace online before attempting the operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14631: the partition bounds do not match the subpartition bounds of the partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0When exchanging a partitioned table with a composite partition the bounds that describe the partitions of the table must match the bounds that describe the subpartitions of the composite partition.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the bounds describing partitions in the partitioned table is the same as the bounds of the subpartitions in the the composite partition.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14632: cannot specify PARALLEL clause when adding a List subpartition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User issued ALTER TABLE ADD SUBPARTITION statement with PARALLEL clause for a List subpartition of a Range\/List partitioned object which is illegal<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the PARALLEL clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14633: Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The clause INVALIDATE or UPDATE GLOBAL INDEXES is allowed only for ADD hash subpartition to a composite partitioned table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove clause and reissue operation<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14634: Subpartition descriptions cannot be specified during the SPLIT\/MERGE of a partition of a Range-List partitioned table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0During a split or a merge of a partition of a range list partitioned table you cannot specify any subpartitioning information for the resulting partition (s)<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove all subpartitioning information from the DDL.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14635: only one resulting subpartition can be specified for MERGE SUBPARTITIONS<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER TABLE MERGE SUBPARTITIONS contained more than one resulting subpartition for the MERGE<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the statement describes exactly one subpartition as the target that need to be MERGEd<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14636: only 2 resulting subpartition can be specified for SPLIT SUBPARTITION<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER TABLE SPLIT SUBPARTITION contained more than 2 resulting subpartition for the SPLIT<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the statement describes exactly 2 subpartitions as the target of the SPLIT operation<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14637: cannot merge a subpartition with itself<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The same subpartition name was specified twice for the merge operation<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-submit operation with 2 distinct subpartition names within the same composite partition<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14638: cannot MERGE subpartitions in different Range Composite partitions<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to MERGE subpartitions in different Range Composite partitions<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reissue the command after ensuring that the 2 subpartitions being merged lie in the same composite partition<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14639: SUBPARTITIONS clause can be specfied only for Hash, Composite Range Hash table\/partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to specify SUBPARTITIONS clause on table that is not partitioned by the Composite Range-Hash method<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Reissue the command after ensuring that the SUBPARTITIONS clause is not specified, to specify a template for a Composite Range List object use the SUBPARTITION TEMPLATE clause<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14640: add\/coalesce index partition operation is valid only for hash partitioned global indexes<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted to add or coalesce an index partition of a global index not partitioned by hash method.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Issue the statement on a global index partitioned by hash method. or if the index is partitioned by range method consider using split\/drop instead of add\/coalesce.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14641: STORE-IN clause can be specified only for a Hash, Composite Range Hash table\/partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Specifying a STORE-IN clause during CREATE\/ALTER of a Range, Composite Range List partitioned table which is not allowed”<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-issue the stament after removing the STORE-IN clause<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14642: Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The two tables in the EXCHANGE have usable bitmap indexes, and the INCLUDING INDEXES option has been specified and the tables have different hakan factors.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Perform the exchange with the EXCLUDING INDEXES option or alter the bitmap indexes to be unusable.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14643: Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Either records_per_block has been minimized for one of the tables to be exchanged, but not the other, or the hakan factors for the tables to be exchanged are not equal.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If records_per_block has been minimized for one of the tables, but not the other, either perform alter table with the NOMINIMIZE RECORDS_PER_BLOCK option for both tables, or perform alter table with the MINIMIZE RECORDS_PER_BLOCK for both tables. If the hakan factors do not match perform alter table with the NOMINIMIZE RECORDS_PER_BLOCK option for both tables.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14644: table is not subpartitioned by Hash method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A subpartition maintenance operation such as ALTER TABLE MODIFY PARTITION COALESCE SUBPARTITION can only be performed on Hash subpartitioned objects<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-issue the command against a Hash subpartitioned object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14645: STORE IN clause cannot be specified for Range List objects<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A STORE IN clause was specified for Range List partitioned object<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-issue the command after removng the STORE IN clause<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14646: Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The first time a table is altered to include compression, it cannot have a usable bitmap index (partition). Subsequent alter table statements involving compression do not have this same restriction.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0A) Drop any bitmap indexes defined on the table, and re-create them once the operation is complete or, B) Mark all index fragments of all bitmap indexes defined on the table UNUSABLE and rebuild them once the operation is complete.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14650: operation not supported for reference-partitioned tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to perform an operation on a reference-partitioned table that was not supported.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not perform the unsupported operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14651: reference partitioning constraint is not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified partitioning constraint was not supported for reference-partitioned tables. The partitioning constraint must be enabled, validated, and not deferrable. The partitioning constraint must not have ON DELETE SET NULL semantics.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the statement to specify a supported partitioning constraint.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14652: reference partitioning foreign key is not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified partitioning foreign key was not supported for reference-partitioned tables. All columns of the partitioning foreign key must be constrained NOT NULL with enabled, validated, and not deferrable constraints. Furthermore, a virtual column cannot be part of the partitioning foreign key.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the statement to specify a supported partitioning foreign key.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14653: parent table of a reference-partitioned table must be partitioned<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to create a reference-partitioned table with a non-partitioned parent table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the statement and reenter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14654: number of partitions of reference-partitioned table must equal that of the parent table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to create a reference-partitioned table with a number of partitions which was different from that of the parent table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the CREATE TABLE statement to specify a correct number of partitions.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14655: reference partitioning constraint not found<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Partitioning constraint specified in CREATE TABLE … PARTITION BY REFERENCE was not one of the referential constraints on the table being created.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that the specified partitioning constraint is one of the referential constraints on the table being created.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14656: cannot drop the parent of a reference-partitioned table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to drop the parent of a reference-partitioned table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop all reference-partitioned child tables before dropping the parent table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14657: cannot cascade row migration to reference-partitioned child table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Update of a parent key may require migration of rows in reference-partitioned child tables, however this is not supported because the parent key was not suitably indexed.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Replace the existing index on the parent key with a unique index that does not contain any columns in addition to the parent key.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14658: specified dependent table is not affected by this operation<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A table has been specified in the DEPENDENT TABLES clause that is not a reference-partitioned table affected by the operation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the statement and reenter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14659: Partitioning method of the parent table is not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create a reference-partitioned table with an interval partitioned parent table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not create a reference-partitioned table with an interval partitioned parent table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14660: parent table of a reference-partitioned table cannot be index-organized<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to create a reference-partitioned table with a index-organized parent table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the statement and reenter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14661: row movement must be enabled<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to disable row movement for a reference-partitioned table, although row movement was enabled for its parent table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Disable row movement for parent table before disabling row movement for the reference-partitioned table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14662: row movement cannot be enabled<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to enable row movement for a partitioned table, although row movement was disabled for a reference-partitioned child table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Enable row movement for reference-partitioned child tables before enabling row movement for the parent table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14663: reference partitioning parent key is not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Parent key of the reference-partitioned table’s partitioning constraint contained virtual columns.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the statement to specify a partitioning constraint with supported parent key and reenter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14664: Cannot use PL\/SQL expressions in reference partitioning parent key<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Parent key of the reference partitioned table’s partitioning constraint contained a virtual column that referenced a PL\/SQL expression.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the statement to specify a partitioning constraint with supported parent key and reenter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14665: Cannot use expressions involving ROWID data type in reference partitioning parent key<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Parent key of the reference partitioned table’s partitioning constraint contained a virtual column that involved the ROWID data type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the statement to specify a partitioning constraint with supported parent key and reenter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14666: Cannot use expressions involving BLOB or CLOB data types in reference partitioning parent key<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Parent key of the reference partitioned table’s partitioning constraint contained a virtual column that involved a BLOB or CLOB data type.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the statement to specify a partitioning constraint with supported parent key and reenter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14667: Cannot use expressions involving object data types in reference partitioning parent key<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Parent key of the reference partitioned table’s partitioning constraint contained a virtual column that involved an object data type (object, REF, nested table, array).<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct the statement to specify a partitioning constraint with supported parent key and reenter.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14668: Cannot drop a unique or primary key referenced by the partitioning constraint of a reference-partitioned table.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a unique or primary key referenced by the partitioning constraint of a reference-partitioned table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop all reference-partitioned child tables before dropping the unique or primary key of the parent table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to issue a LOCK TABLE statement on SYS owned object(s) by a non-SYS user, user should minimally have DML privileges<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-issue LOCK TABLE statement for non-SYS user after granting DML privileges on object, or non-SYS user should connect as SYS<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-14500 to ORA-14700 ORA-14500: LOCAL option not valid without partition name Cause:\u00a0Incorrect syntax specified Action:\u00a0Retry the command ORA-14501: object is not partitioned Cause:\u00a0Table or index is not partitioned. Invalid syntax. Action:\u00a0Retry the command with correct syntax. ORA-14503: only one partition name can be specified Cause:\u00a0More than one…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1919","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-uX","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1919","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1919"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1919\/revisions"}],"predecessor-version":[{"id":1920,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1919\/revisions\/1920"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1919"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}