Online Documentation for Data Pump for Oracle

Target index properties


The Target object definition area of Step 5 allows you to view and edit the target iconObjects_Index index properties:

 

Step 5 - Editing target objects - Target index properties

 

Name - specifies the index name

 

Columns (read only) - view the column(s) used by the index

 

CheckBox Unique - determines uniqueness of the index, causes the system to check for duplicate values in the table each time data are added

 

CheckBox Logging - specifies whether the creation of the index will be logged or not in the redo log file

 

CheckBox Not sorted - indicates to the database that the rows are already stored in the database in ascending order, so that Oracle does not have to sort the rows when creating the index

 

CheckBox Reverse - specifies that the bytes of the index block are stored in reverse order, excluding the rowid

 

<< Back to editing target objects