Oracle Database 12c: Implement Partitioning

направление: Oracle
вендор:
Даты проведения курса
Array
(
    [0] => Array
        (
            [PRICES] => Array
                (
                    [BASE] => Array
                        (
                            [PRICE_ID] => 1
                            [ID] => 60046
                            [CAN_ACCESS] => Y
                            [CAN_BUY] => Y
                            [MIN_PRICE] => Y
                            [CURRENCY] => RUB
                            [VALUE_VAT] => 44700
                            [VALUE_NOVAT] => 44700
                            [DISCOUNT_VALUE_VAT] => 44700
                            [DISCOUNT_VALUE_NOVAT] => 44700
                            [ROUND_VALUE_VAT] => 44700
                            [ROUND_VALUE_NOVAT] => 44700
                            [VALUE] => 44700
                            [UNROUND_DISCOUNT_VALUE] => 44700
                            [DISCOUNT_VALUE] => 44700
                            [DISCOUNT_DIFF] => 0
                            [DISCOUNT_DIFF_PERCENT] => 0
                            [VATRATE_VALUE] => 0
                            [DISCOUNT_VATRATE_VALUE] => 0
                            [ROUND_VATRATE_VALUE] => 0
                            [PRINT_VALUE_NOVAT] => 44 700 руб.
                            [PRINT_VALUE_VAT] => 44 700 руб.
                            [PRINT_VATRATE_VALUE] => 0 руб.
                            [PRINT_DISCOUNT_VALUE_NOVAT] => 44 700 руб.
                            [PRINT_DISCOUNT_VALUE_VAT] => 44 700 руб.
                            [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
                            [PRINT_VALUE] => 44 700 руб.
                            [PRINT_DISCOUNT_VALUE] => 44 700 руб.
                            [PRINT_DISCOUNT_DIFF] => 0 руб.
                        )

                )

            [PRICE_MATRIX] => 
            [MIN_PRICE] => Array
                (
                    [PRICE_ID] => 1
                    [ID] => 60046
                    [CAN_ACCESS] => Y
                    [CAN_BUY] => Y
                    [MIN_PRICE] => Y
                    [CURRENCY] => RUB
                    [VALUE_VAT] => 44700
                    [VALUE_NOVAT] => 44700
                    [DISCOUNT_VALUE_VAT] => 44700
                    [DISCOUNT_VALUE_NOVAT] => 44700
                    [ROUND_VALUE_VAT] => 44700
                    [ROUND_VALUE_NOVAT] => 44700
                    [VALUE] => 44700
                    [UNROUND_DISCOUNT_VALUE] => 44700
                    [DISCOUNT_VALUE] => 44700
                    [DISCOUNT_DIFF] => 0
                    [DISCOUNT_DIFF_PERCENT] => 0
                    [VATRATE_VALUE] => 0
                    [DISCOUNT_VATRATE_VALUE] => 0
                    [ROUND_VATRATE_VALUE] => 0
                    [PRINT_VALUE_NOVAT] => 44 700 руб.
                    [PRINT_VALUE_VAT] => 44 700 руб.
                    [PRINT_VATRATE_VALUE] => 0 руб.
                    [PRINT_DISCOUNT_VALUE_NOVAT] => 44 700 руб.
                    [PRINT_DISCOUNT_VALUE_VAT] => 44 700 руб.
                    [PRINT_DISCOUNT_VATRATE_VALUE] => 0 руб.
                    [PRINT_VALUE] => 44 700 руб.
                    [PRINT_DISCOUNT_VALUE] => 44 700 руб.
                    [PRINT_DISCOUNT_DIFF] => 0 руб.
                )

            [CATALOG_GROUP_ID_1] => 1
            [~CATALOG_GROUP_ID_1] => 1
            [CATALOG_GROUP_NAME_1] => Базовая цена
            [~CATALOG_GROUP_NAME_1] => Базовая цена
            [CATALOG_CAN_ACCESS_1] => Y
            [~CATALOG_CAN_ACCESS_1] => Y
            [CATALOG_CAN_BUY_1] => Y
            [~CATALOG_CAN_BUY_1] => Y
            [CATALOG_PRICE_ID_1] => 60046
            [~CATALOG_PRICE_ID_1] => 60046
            [CATALOG_PRICE_1] => 44700.00
            [~CATALOG_PRICE_1] => 44700.00
            [CATALOG_CURRENCY_1] => RUB
            [~CATALOG_CURRENCY_1] => RUB
            [CATALOG_QUANTITY_FROM_1] => 
            [~CATALOG_QUANTITY_FROM_1] => 
            [CATALOG_QUANTITY_TO_1] => 
            [~CATALOG_QUANTITY_TO_1] => 
            [CATALOG_EXTRA_ID_1] => 
            [~CATALOG_EXTRA_ID_1] => 
            [ID] => 57490
            [~ID] => 57490
            [IBLOCK_ID] => 24
            [~IBLOCK_ID] => 24
            [PROPERTY_85_VALUE] => 48322
            [~PROPERTY_85_VALUE] => 48322
            [PROPERTY_85_VALUE_ID] => 4167533
            [~PROPERTY_85_VALUE_ID] => 4167533
            [PROPERTY_DATE_FROM_VALUE] => 09.10.2019
            [~PROPERTY_DATE_FROM_VALUE] => 09.10.2019
            [PROPERTY_DATE_FROM_VALUE_ID] => 4167540
            [~PROPERTY_DATE_FROM_VALUE_ID] => 4167540
            [NAME] => Oracle Database 12c: Implement Partitioning
            [~NAME] => Oracle Database 12c: Implement Partitioning
            [PREVIEW_PICTURE] => 
            [~PREVIEW_PICTURE] => 
            [DETAIL_PICTURE] => 
            [~DETAIL_PICTURE] => 
            [CATALOG_QUANTITY] => 0
            [~CATALOG_QUANTITY] => 0
            [CATALOG_QUANTITY_RESERVED] => 0
            [~CATALOG_QUANTITY_RESERVED] => 0
            [CATALOG_QUANTITY_TRACE] => N
            [~CATALOG_QUANTITY_TRACE] => N
            [CATALOG_QUANTITY_TRACE_ORIG] => D
            [~CATALOG_QUANTITY_TRACE_ORIG] => D
            [CATALOG_CAN_BUY_ZERO] => N
            [~CATALOG_CAN_BUY_ZERO] => N
            [CATALOG_CAN_BUY_ZERO_ORIG] => D
            [~CATALOG_CAN_BUY_ZERO_ORIG] => D
            [CATALOG_NEGATIVE_AMOUNT_TRACE] => N
            [~CATALOG_NEGATIVE_AMOUNT_TRACE] => N
            [CATALOG_NEGATIVE_AMOUNT_ORIG] => D
            [~CATALOG_NEGATIVE_AMOUNT_ORIG] => D
            [CATALOG_SUBSCRIBE] => N
            [~CATALOG_SUBSCRIBE] => N
            [CATALOG_SUBSCRIBE_ORIG] => D
            [~CATALOG_SUBSCRIBE_ORIG] => D
            [CATALOG_AVAILABLE] => Y
            [~CATALOG_AVAILABLE] => Y
            [CATALOG_WEIGHT] => 0
            [~CATALOG_WEIGHT] => 0
            [CATALOG_WIDTH] => 
            [~CATALOG_WIDTH] => 
            [CATALOG_LENGTH] => 
            [~CATALOG_LENGTH] => 
            [CATALOG_HEIGHT] => 
            [~CATALOG_HEIGHT] => 
            [CATALOG_MEASURE] => 
            [~CATALOG_MEASURE] => 
            [CATALOG_VAT] => 
            [~CATALOG_VAT] => 
            [CATALOG_VAT_ID] => 
            [~CATALOG_VAT_ID] => 
            [CATALOG_VAT_INCLUDED] => N
            [~CATALOG_VAT_INCLUDED] => N
            [CATALOG_PRICE_TYPE] => S
            [~CATALOG_PRICE_TYPE] => S
            [CATALOG_RECUR_SCHEME_TYPE] => D
            [~CATALOG_RECUR_SCHEME_TYPE] => D
            [CATALOG_RECUR_SCHEME_LENGTH] => 
            [~CATALOG_RECUR_SCHEME_LENGTH] => 
            [CATALOG_TRIAL_PRICE_ID] => 
            [~CATALOG_TRIAL_PRICE_ID] => 
            [CATALOG_WITHOUT_ORDER] => N
            [~CATALOG_WITHOUT_ORDER] => N
            [CATALOG_SELECT_BEST_PRICE] => N
            [~CATALOG_SELECT_BEST_PRICE] => N
            [CATALOG_PURCHASING_PRICE] => 
            [~CATALOG_PURCHASING_PRICE] => 
            [CATALOG_PURCHASING_CURRENCY] => 
            [~CATALOG_PURCHASING_CURRENCY] => 
            [CATALOG_TYPE] => 4
            [~CATALOG_TYPE] => 4
            [CATALOG_BUNDLE] => N
            [~CATALOG_BUNDLE] => N
            [SORT_HASH] => 5eaabb94140c7c1ad4d14ba2869b7c16
            [LINK_ELEMENT_ID] => 48322
            [PROPERTIES] => Array
                (
                    [CML2_LINK] => Array
                        (
                            [ID] => 85
                            [IBLOCK_ID] => 24
                            [NAME] => Элемент каталога
                            [ACTIVE] => Y
                            [SORT] => 5
                            [CODE] => CML2_LINK
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => E
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => CML2_LINK
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 25
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => Y
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => SKU
                            [USER_TYPE_SETTINGS] => Array
                                (
                                    [VIEW] => A
                                    [SHOW_ADD] => N
                                    [MAX_WIDTH] => 0
                                    [MIN_HEIGHT] => 24
                                    [MAX_HEIGHT] => 1000
                                    [BAN_SYM] => ,;
                                    [REP_SYM] =>  
                                    [OTHER_REP_SYM] => 
                                    [IBLOCK_MESS] => N
                                )

                            [HINT] => 
                            [~NAME] => Элемент каталога
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 48322
                            [PROPERTY_VALUE_ID] => 4167533
                            [DESCRIPTION] => 
                            [~VALUE] => 48322
                            [~DESCRIPTION] => 
                        )

                    [CITY] => Array
                        (
                            [ID] => 92
                            [IBLOCK_ID] => 24
                            [NAME] => Город проведения
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => CITY
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => Y
                            [FILTRABLE] => Y
                            [IS_REQUIRED] => Y
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Город проведения
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => Москва
                            [PROPERTY_VALUE_ID] => 4167542
                            [DESCRIPTION] => 
                            [~VALUE] => Москва
                            [~DESCRIPTION] => 
                        )

                    [MAX_COUNT] => Array
                        (
                            [ID] => 100
                            [IBLOCK_ID] => 24
                            [NAME] => Исходное количество мест
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => MAX_COUNT
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => N
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Исходное количество мест
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                        )

                    [DATE_FROM] => Array
                        (
                            [ID] => 101
                            [IBLOCK_ID] => 24
                            [NAME] => Начало курса
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => DATE_FROM
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => Y
                            [FILTRABLE] => Y
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => DateTime
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Начало курса
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 09.10.2019
                            [PROPERTY_VALUE_ID] => 4167540
                            [DESCRIPTION] => 
                            [~VALUE] => 09.10.2019
                            [~DESCRIPTION] => 
                        )

                    [DATE_TO] => Array
                        (
                            [ID] => 102
                            [IBLOCK_ID] => 24
                            [NAME] => Окончание курса
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => DATE_TO
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => Y
                            [FILTRABLE] => Y
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => DateTime
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Окончание курса
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 10.10.2019
                            [PROPERTY_VALUE_ID] => 4167541
                            [DESCRIPTION] => 
                            [~VALUE] => 10.10.2019
                            [~DESCRIPTION] => 
                        )

                    [FLAG_SALE] => Array
                        (
                            [ID] => 141
                            [IBLOCK_ID] => 24
                            [NAME] => Скидки
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => FLAG_SALE
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => L
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => C
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Скидки
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                            [VALUE_ENUM_ID] => 
                        )

                    [IN_ACTION] => Array
                        (
                            [ID] => 142
                            [IBLOCK_ID] => 24
                            [NAME] => Участвует в акциях
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => IN_ACTION
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => E
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => Y
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 30
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => EList
                            [USER_TYPE_SETTINGS] => Array
                                (
                                    [size] => 1
                                    [width] => 0
                                    [group] => N
                                    [multiple] => N
                                )

                            [HINT] => 
                            [~NAME] => Участвует в акциях
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                        )

                    [NEW] => Array
                        (
                            [ID] => 144
                            [IBLOCK_ID] => 24
                            [NAME] => Новинка
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => NEW
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => L
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => C
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Новинка
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                            [VALUE_ENUM_ID] => 
                        )

                    [DURATION_HOURS] => Array
                        (
                            [ID] => 174
                            [IBLOCK_ID] => 24
                            [NAME] => Длитеность, часов
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => DURATION_HOURS
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => N
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Длитеность, часов
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 16
                            [PROPERTY_VALUE_ID] => 4167536
                            [DESCRIPTION] => 
                            [~VALUE] => 16
                            [~DESCRIPTION] => 
                        )

                    [DURATION_DAYS] => Array
                        (
                            [ID] => 175
                            [IBLOCK_ID] => 24
                            [NAME] => Длитеность, дней
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => DURATION_DAYS
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => N
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Длитеность, дней
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 2
                            [PROPERTY_VALUE_ID] => 4167537
                            [DESCRIPTION] => 
                            [~VALUE] => 2
                            [~DESCRIPTION] => 
                        )

                    [COURSE_CODE] => Array
                        (
                            [ID] => 176
                            [IBLOCK_ID] => 24
                            [NAME] => Код курса
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => COURSE_CODE
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Код курса
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => O12cIP
                            [PROPERTY_VALUE_ID] => 4167538
                            [DESCRIPTION] => 
                            [~VALUE] => O12cIP
                            [~DESCRIPTION] => 
                        )

                    [ACTION_NUMBER] => Array
                        (
                            [ID] => 177
                            [IBLOCK_ID] => 24
                            [NAME] => Номер акции
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => ACTION_NUMBER
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Номер акции
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                        )

                    [MARKER] => Array
                        (
                            [ID] => 178
                            [IBLOCK_ID] => 24
                            [NAME] => Маркер
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => MARKER
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Маркер
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => Or
                            [PROPERTY_VALUE_ID] => 4167539
                            [DESCRIPTION] => 
                            [~VALUE] => Or
                            [~DESCRIPTION] => 
                        )

                    [HINT] => Array
                        (
                            [ID] => 179
                            [IBLOCK_ID] => 24
                            [NAME] => Примечание
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => HINT
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Примечание
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                        )

                    [B_SPECIAL_PRICE] => Array
                        (
                            [ID] => 180
                            [IBLOCK_ID] => 24
                            [NAME] => B_SPECIAL_PRICE
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => B_SPECIAL_PRICE
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => N
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => B_SPECIAL_PRICE
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 0
                            [PROPERTY_VALUE_ID] => 4167534
                            [DESCRIPTION] => 
                            [~VALUE] => 0
                            [~DESCRIPTION] => 
                        )

                    [NORMAL_PRICE] => Array
                        (
                            [ID] => 181
                            [IBLOCK_ID] => 24
                            [NAME] => Стандартная цена для 1 чел.
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => NORMAL_PRICE
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => N
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Стандартная цена для 1 чел.
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 44700
                            [PROPERTY_VALUE_ID] => 4167535
                            [DESCRIPTION] => 
                            [~VALUE] => 44700
                            [~DESCRIPTION] => 
                        )

                    [SECTION_CODE] => Array
                        (
                            [ID] => 186
                            [IBLOCK_ID] => 24
                            [NAME] => Подкатегория курса 4
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => SECTION_CODE
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Подкатегория курса 4
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 20
                            [PROPERTY_VALUE_ID] => 4167543
                            [DESCRIPTION] => 
                            [~VALUE] => 20
                            [~DESCRIPTION] => 
                        )

                    [SHOW_TO_MAIN] => Array
                        (
                            [ID] => 189
                            [IBLOCK_ID] => 24
                            [NAME] => Показывать на главной
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => SHOW_TO_MAIN
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => L
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => C
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => N
                            [FILTRABLE] => N
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => 
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Показывать на главной
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 
                            [PROPERTY_VALUE_ID] => 
                            [DESCRIPTION] => 
                            [~DESCRIPTION] => 
                            [~VALUE] => 
                            [VALUE_ENUM_ID] => 
                        )

                )

            [DISPLAY_PROPERTIES] => Array
                (
                    [DATE_TO] => Array
                        (
                            [ID] => 102
                            [IBLOCK_ID] => 24
                            [NAME] => Окончание курса
                            [ACTIVE] => Y
                            [SORT] => 500
                            [CODE] => DATE_TO
                            [DEFAULT_VALUE] => 
                            [PROPERTY_TYPE] => S
                            [ROW_COUNT] => 1
                            [COL_COUNT] => 30
                            [LIST_TYPE] => L
                            [MULTIPLE] => N
                            [XML_ID] => 
                            [FILE_TYPE] => 
                            [MULTIPLE_CNT] => 5
                            [LINK_IBLOCK_ID] => 0
                            [WITH_DESCRIPTION] => N
                            [SEARCHABLE] => Y
                            [FILTRABLE] => Y
                            [IS_REQUIRED] => N
                            [VERSION] => 1
                            [USER_TYPE] => DateTime
                            [USER_TYPE_SETTINGS] => 
                            [HINT] => 
                            [~NAME] => Окончание курса
                            [~DEFAULT_VALUE] => 
                            [VALUE_ENUM] => 
                            [VALUE_XML_ID] => 
                            [VALUE_SORT] => 
                            [VALUE] => 10.10.2019
                            [PROPERTY_VALUE_ID] => 4167541
                            [DESCRIPTION] => 
                            [~VALUE] => 10.10.2019
                            [~DESCRIPTION] => 
                            [DISPLAY_VALUE] => 10.10.2019
                        )

                )

            [PRODUCT] => Array
                (
                    [TYPE] => 4
                    [AVAILABLE] => Y
                    [MEASURE] => 
                    [VAT_ID] => 
                    [VAT_RATE] => 
                    [VAT_INCLUDED] => N
                    [QUANTITY] => 0
                    [QUANTITY_TRACE] => N
                    [CAN_BUY_ZERO] => N
                    [SUBSCRIPTION] => 
                    [BUNDLE] => N
                )

            [ITEM_PRICE_MODE] => S
            [ITEM_PRICES] => Array
                (
                    [0] => Array
                        (
                            [UNROUND_BASE_PRICE] => 44700
                            [UNROUND_PRICE] => 44700
                            [BASE_PRICE] => 44700
                            [PRICE] => 44700
                            [ID] => 60046
                            [PRICE_TYPE_ID] => 1
                            [CURRENCY] => RUB
                            [DISCOUNT] => 0
                            [PERCENT] => 0
                            [VAT] => 0
                            [QUANTITY_FROM] => 
                            [QUANTITY_TO] => 
                            [QUANTITY_HASH] => ZERO-INF
                            [MEASURE_RATIO_ID] => 
                            [PRINT_BASE_PRICE] => 44 700 руб.
                            [RATIO_BASE_PRICE] => 44700
                            [PRINT_RATIO_BASE_PRICE] => 44 700 руб.
                            [PRINT_PRICE] => 44 700 руб.
                            [RATIO_PRICE] => 44700
                            [PRINT_RATIO_PRICE] => 44 700 руб.
                            [PRINT_DISCOUNT] => 0 руб.
                            [RATIO_DISCOUNT] => 0
                            [PRINT_RATIO_DISCOUNT] => 0 руб.
                            [PRINT_VAT] => 0 руб.
                            [RATIO_VAT] => 0
                            [PRINT_RATIO_VAT] => 0 руб.
                            [MIN_QUANTITY] => 1
                        )

                )

            [ITEM_QUANTITY_RANGES] => Array
                (
                    [ZERO-INF] => Array
                        (
                            [HASH] => ZERO-INF
                            [QUANTITY_FROM] => 
                            [QUANTITY_TO] => 
                            [SORT_FROM] => 0
                            [SORT_TO] => INF
                        )

                )

            [ITEM_MEASURE_RATIOS] => Array
                (
                    [0] => Array
                        (
                            [ID] => 0
                            [RATIO] => 1
                            [IS_DEFAULT] => Y
                        )

                )

            [ITEM_MEASURE] => Array
                (
                    [ID] => 
                    [TITLE] => место
                    [~TITLE] => место
                )

            [ITEM_MEASURE_RATIO_SELECTED] => 0
            [ITEM_QUANTITY_RANGE_SELECTED] => ZERO-INF
            [ITEM_PRICE_SELECTED] => 0
            [CHECK_QUANTITY] => 
            [CATALOG_MEASURE_NAME] => место
            [~CATALOG_MEASURE_NAME] => место
            [CAN_BUY] => 1
            [ITEM_PRICES_CAN_BUY] => 1
            [~BUY_URL] => /courses/O12cIP/?ELEMENT_CODE=O12cIP&action=BUY&id=57490
            [BUY_URL] => /courses/O12cIP/?ELEMENT_CODE=O12cIP&action=BUY&id=57490
            [~ADD_URL] => /courses/O12cIP/?ELEMENT_CODE=O12cIP&action=ADD2BASKET&id=57490
            [ADD_URL] => /courses/O12cIP/?ELEMENT_CODE=O12cIP&action=ADD2BASKET&id=57490
            [~SUBSCRIBE_URL] => /courses/O12cIP/?ELEMENT_CODE=O12cIP&action=SUBSCRIBE_PRODUCT&id=57490
            [SUBSCRIBE_URL] => /courses/O12cIP/?ELEMENT_CODE=O12cIP&action=SUBSCRIBE_PRODUCT&id=57490
            [~COMPARE_URL] => /courses/O12cIP/?ELEMENT_CODE=O12cIP&action=ADD_TO_COMPARE_LIST&id=57490
            [COMPARE_URL] => /courses/O12cIP/?ELEMENT_CODE=O12cIP&action=ADD_TO_COMPARE_LIST&id=57490
            [~COMPARE_DELETE_URL] => /courses/O12cIP/?ELEMENT_CODE=O12cIP&action=DELETE_FROM_COMPARE_LIST&id=57490
            [COMPARE_DELETE_URL] => /courses/O12cIP/?ELEMENT_CODE=O12cIP&action=DELETE_FROM_COMPARE_LIST&id=57490
            [CATALOG_MEASURE_RATIO] => 1
            [OFFER_GROUP] => 
            [RATIO_PRICE] => Array
                (
                    [VALUE] => 44700
                    [DISCOUNT_VALUE] => 44700
                    [PRINT_VALUE] => 44 700 руб.
                    [PRINT_DISCOUNT_VALUE] => 44 700 руб.
                    [DISCOUNT_DIFF] => 0
                    [PRINT_DISCOUNT_DIFF] => 0 руб.
                    [DISCOUNT_DIFF_PERCENT] => 0
                    [CURRENCY] => RUB
                )

            [MORE_PHOTO] => Array
                (
                    [0] => Array
                        (
                            [SRC] => /bitrix/templates/.default/components/bitrix/catalog.element/course/images/no_photo.png
                            [WIDTH] => 150
                            [HEIGHT] => 150
                        )

                )

            [MORE_PHOTO_COUNT] => 1
        )

)


Описание:

Курс Oracle Database 12c: Внедрение  Секционирования  посвящен тому, как  управлять секционированием в Oracle Database 12c. Инструктор покажет преимущества секционирования для различных типов рабочих нагрузок и обучит применению синтаксиса команд для обслуживания операций секционирования.

На курсе изучаются:

  • Применение стратегии секционирования для повышения производительности приложений.
  • Использования техники секционирования для уменьшения влияния на операции обслуживания таблиц и индексов
  • Использование секционирования для уменьшения времени обновления данных в материализованном представлении
  • Секции LOB сегментов, вложенных таблиц и объектных таблиц
  • Общие положения методов секционирования в Oracle для таблиц, индексов, материализованных представлений, доступных в Oracle Database 12c Release 1.

  • Цель курса:

  • Описание архитектуры на основании секционирования, ее использование и преимущества
  • Описание типов секцинирования, поддерживаемых в Oracle СУБД
  • Список всех опций при создании секционированных таблиц
  • Создание секционированных таблиц
  • Описание отношения таблиц и секционированных индексов
  • Список всех опций при создании секционированных индексов
  • Создание секцинированных индексов
  • Список всех возможностей внесения изменений в таблицы при работе с атрибутами секционированных таблиц и индексов
  • Описане накладных расходов, связанных с каждой командой обслуживания
  • Использование словаря данных при верификации структуры секционирования
  • Создание материализованных представлений, которые могут быть секционированы
  • Описание преимуществ секцинированых материализованных представлений
  • Демонстрация увеличения производительности при использовании материализованных представлений
  • Выбор необходимых атрибутов секционирования в зависимости от различных требований приложений
  • Понять как соотносятся опции секцинирования с другими возможностями СУБД
  • Описание как Oracle Enterprise Manager'ом поддерживаются секцинированные объекты

  • Аудитория курса:

  • Администраторы СУБД
  • Проектировщики РСУБД
  • Системные архитекторы