Oracle Database full backup recovery and partial Backup Recovery continuation oracle11gr2

Source: Internet
Author: User

Today, when I used exp/imp for a small backup and recovery operation, I encountered a problem. Many empty tables cannot be expressed. I didn't understand it at the beginning, later, I went to the Oracle official website and read ORACLE data. I sent oracle11g R2 with a new feature. When exp and IMP are used, no segment is allocated when the table has no data, to save space. This will prevent the empty table data from being expressed. I want to say something in shit.

Okay. solution:

Solution 1: set the system parameter to take effect only for the table created after the parameter is updated.

Alter system set deferred_segment_creation = false scope = both;

The default value of this parameter is true. When it is set to false, segment is assigned to both empty tables and non-empty tables. It should be noted that the value setting does not affect the empty tables previously imported and cannot be exported. It can only be used for the newly added tables. To export an empty table, you can only use the first method.

Then execute solution 2.

Solution 2: manually allocate space for empty tables

Select 'alter table' | table_name | 'allocate extent; 'from user_tables where num_rows = 0;

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.