Oracle Data pump scenarios that do not use direct path loading

Source: Internet
Author: User

Situations in which Direct Path Load are not used

If any of the following conditions exist for a table, then Data Pump uses external tables rather than direct path to load The data for that table:

  • A global index on multipartition tables exists during a single-partition load. This includes object tables is partitioned.

  • A domain index exists for a LOB column.

  • A table is in a cluster.

  • There is an active trigger on a preexisting table.

  • Fine-grained access control is enabled with insert mode on a preexisting table.

  • A table contains BFILE columns or columns of opaque types.

  • A referential integrity constraint is present on a preexisting table.

  • A table contains VARRAY columns with an embedded opaque type.

  • The table has encrypted columns.

  • The table into which data is being imported are a preexisting table and at least one of the following conditions exists:

    • There is an active trigger

    • The table is partitioned

    • Fine-grained access control is in insert mode

    • A referential integrity constraint exists

    • A Unique index exists

  • Supplemental logging is enabled and the table have at least one LOB column.

  • The Data Pump command for the specified table used the QUERY , SAMPLE , or REMAP_DATA parameter.

  • A table contains a column (including a VARRAY column) with a datatype and the version of the time TIMESTAMP WITH TIME ZONE zone data file is D Ifferent between the export and import systems.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.