Oracle Export NULL Table workaround

Source: Internet
Author: User

In Oracle 11g, it is found that traditional exp cannot export empty tables

Oracle 11g has a new parameter: deferred_segment_creation, meaning segment delay creation, which is true by default. What does it mean exactly?

If this parameter is set to True, you create a new table T1, and you do not insert data into it, the table will not immediately allocate extent, that is, it does not occupy the data space, only when you insert the data to allocate space. This can save a little space. Workaround if the deferred_segment_creation parameter is set to False, both the empty table and the non-empty table are assigned segment. The next steps refer to:http://inshect.iteye.com/blog/1567504

Oracle Export NULL Table workaround

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.