Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 18c Trying to use STAGE_ITAB preferences

Amin AdatiaJan 16 2019

Oracle 18.3

I define the preferences for NEW_STORAGE_18

STAGE_ITAB => YES

STAGE_ITAB_AUTO_OPT => YES

STAGE_ITAB_MAX_ROWS => 1000000

STAGE_ITAB_PARALLEL => 16

When I do ALTER INDEX PARAMETERS('REPLACE STORAGE NEW_STORAGE_18')

Error

DRG_11375 stage_itab_auto_opt not allowed without STAGE_ITAB storage preference

CTX_REPORT.DESCRIBE(<Index>) show the STAGE_ITAB parameters are defined.

Any ideas?

Regards

Added on Jan 16 2019

#database-key-features, #text

0 comments

172 views