You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for SKIP_UNUSABLE_INDEXES


1 to 20 of 28 results. Previous page Prev  Next next page


Database Utilities, 12c Release 1 (12.1)

SKIP_UNUSABLE_INDEXES

SKIP_UNUSABLE_INDEXESDefault: the value of the Oracle Database configuration parameter, SKIP_UNUSABLE_INDEXES. Purpose … state (by either the system or the user). Syntax and Description SKIP_UNUSABLE_INDEXES=[YES | NO] If … SKIP_UNUSABLE_INDEXES is set to YES, and a table or partition with an index in the Unusable state is … not exist. If SKIP_UNUSABLE_INDEXES

Database Utilities, 12c Release 1 (12.1)

SKIP_UNUSABLE_INDEXES

SKIP_UNUSABLE_INDEXESDefault: The value of the Oracle Database configuration parameter, SKIP_UNUSABLE_INDEXES, as … SKIP_UNUSABLE_INDEXES parameter specifies whether to skip an index encountered in an Index Unusable state … and continue the load operation. Syntax and Description SKIP_UNUSABLE_INDEXES=[TRUE | FALSE] A value … of TRUE for SKIP_UNUSABLE_INDEXES

Database Utilities, 12c Release 1 (12.1)

SKIP_UNUSABLE_INDEXES

SKIP_UNUSABLE_INDEXESDefault: the value of the Oracle database configuration parameter, SKIP_UNUSABLE_INDEXES, as … SKIP_UNUSABLE_INDEXES parameter. The Import SKIP_UNUSABLE_INDEXES parameter is specified at the Import command … line. The Oracle database SKIP_UNUSABLE_INDEXES parameter is specified as a configuration parameter in

Database Reference, 12c Release 1 (12.1)

SKIP_UNUSABLE_INDEXES

1.264 SKIP_UNUSABLE_INDEXESSYSTEM Modifiable in a PDB Yes Range of values true | false Basic No SKIP_UNUSABLE_INDEXES enables or … initialization parameter settings, including SKIP_UNUSABLE_INDEXES. If the optimizer chooses an unusable

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Indexes

21.2.11 Understand When to Use Unusable or Invisible IndexesSKIP_UNUSABLE_INDEXES initialization parameter. When SKIP_UNUSABLE_INDEXES is TRUE (the default), then: DML … SKIP_UNUSABLE_INDEXES is FALSE, then: If any unusable indexes or index partitions are present, then

Database Utilities, 12c Release 1 (12.1)

DATA_ONLY

DATA_ONLY, IGNORE, INDEXES, INDEXFILE, ROWS=n, SHOW, SKIP_UNUSABLE_INDEXES, STATISTICS, STREAMS_CONFIGURATION

Database Utilities, 12c Release 1 (12.1)

Importing Partitioned Tables

Importing Partitioned TablesSKIP_UNUSABLE_INDEXES = y, inserting the exported data into the target table fails if Import cannot update a

Database Error Messages, 12c Release 1 (12.1)

SQL*Loader-00100 to SQL*Loader-03120

SQL*Loader-00121: Invalid skip_unusable_indexes option\\nCause: The command line argument for skip_unusable_indexes is incorrect. Action: Use only TRUE or … FALSE as the value for the skip_unusable_indexes option.

Database Utilities, 12c Release 1 (12.1)

Index Creation and Maintenance Controls

Index Creation and Maintenance ControlsIf SKIP_UNUSABLE_INDEXES=y, then the Import utility postpones maintenance on all indexes that were

Database Utilities, 12c Release 1 (12.1)

Index Creation and Maintenance Controls

Example of Postponing Index Maintenancefollowing Import command: imp scott FILE=expdat.dmp TABLES = (t:p1, t:p2) IGNORE=y SKIP_UNUSABLE_INDEXES … =y This example executes the ALTER SESSION SET SKIP_UNUSABLE_INDEXES=y statement before performing

Database Error Messages, 12c Release 1 (12.1)

ORA-24280 to ORA-28709

ORA-26024: SKIP_UNUSABLE_INDEXES requested and index segment was initially unusableCause: User requested SKIP_UNUSABLE_INDEXES option, and the index segment * was in unusable state

Database Utilities, 12c Release 1 (12.1)

Specifying Command-Line Parameters in the Control File

OPTIONS Clause| PARTITIONS | ALL} SKIP = n SKIP_INDEX_MAINTENANCE = {TRUE | FALSE} SKIP_UNUSABLE_INDEXES = {TRUE

Database SQL Language Reference, 12c Release 1 (12.1)

UPDATE

UPDATEUPDATE statement will fail unless the SKIP_UNUSABLE_INDEXES session parameter has been set to TRUE. See … Also: ALTER SESSION for information on the SKIP_UNUSABLE_INDEXES session parameter update_set_clause

Database Utilities, 12c Release 1 (12.1)

Avoiding Index Maintenance

Avoiding Index Maintenanceload and use the SKIP_UNUSABLE_INDEXES parameter. Use the SKIP_INDEX_MAINTENANCE parameter (direct

Database SQL Language Reference, 12c Release 1 (12.1)

DELETE

DELETE, then the DELETE statement will fail unless the SKIP_UNUSABLE_INDEXES initialization parameter has

Database Reference, 12c Release 1 (12.1)

Modifiable Parameters

1.4.2 Modifiable ParametersSKIP_UNUSABLE_INDEXES SMTP_OUT_SERVER SORT_AREA_RETAINED_SIZE SORT_AREA_SIZE SPATIAL_VECTOR_ACCELERATION … SHARED_SERVER_SESSIONS SHARED_SERVERS SKIP_UNUSABLE_INDEXES SMTP_OUT_SERVER SPATIAL_VECTOR_ACCELERATION SPFILE

Database SQL Language Reference, 12c Release 1 (12.1)

INSERT

INSERTunless the SKIP_UNUSABLE_INDEXES session parameter has been set to TRUE. Refer to ALTER SESSION for … information on the SKIP_UNUSABLE_INDEXES session parameter. partition_extension_clause Specify the

Database SQL Language Reference, 12c Release 1 (12.1)

CREATE INDEX

CREATE INDEXfail unless the index is also marked UNUSABLE and the parameter SKIP_UNUSABLE_INDEXES is set to

Database Utilities, 12c Release 1 (12.1)

Database Utilities - Contents

ContentsREMAP_SCHEMA REMAP_TABLE REMAP_TABLESPACE REUSE_DATAFILES SCHEMAS SERVICE_NAME SKIP_UNUSABLE_INDEXES … RESUMABLE_TIMEOUT ROWS SILENT SKIP SKIP_INDEX_MAINTENANCE SKIP_UNUSABLE_INDEXES STREAMSIZE TRIM USERID … SKIP_UNUSABLE_INDEXES STATISTICS STREAMS_CONFIGURATION STREAMS_INSTANTIATION TABLES Table Name Restrictions

Database PL/SQL Packages and Types Reference, 12c Release 1 (12.1)

DBMS_DATAPUMP

SET_PARAMETER ProceduresSKIP_UNUSABLE_INDEXES NUMBER Import If nonzero, rows will be inserted into tables having unusable … indexes. SKIP_UNUSABLE_INDEXES is not supported in Transportable mode. Default=1 SOURCE_EDITION TEXT