Oracle export times wrong exp-00011:table does not exist

Source: Internet
Author: User

ORACLE11G, when backing up the database with the EXP command, if there is no datagram EXP-00011 error in the table, the corresponding table does not exist. This causes the corresponding empty table to not be backed up.

Cause: 11g Creating a table by default does not allocate segment, which is only produced when data is inserted (and, of course, can be forcibly allocated) to conserve disk space.

For empty table workarounds that already exist:

is to make the empty table has segment.

The first type: You can insert data by the way (do not want these data can be rolled back), as long as there is insert action will be allocated segment;

The second type: Forced distribution: ALTER TABLE TableName ALLOCATE extent;

If you use the second option, you can use the following methods:

1. Find the empty table using the following sentence:

select ' ALTER TABLE ' | | table_name| | ' allocate extent; ' from User_tables where num_rows=0;

技术分享

2. Export the query results, execute the exported statements;

for tables created later, you can assign segment directly:

Log in to the database with the system account, modify the parameter deferred_segment_creation (11g new). This parameter refers to whether to delay the creation of segment, which is true by default. If you want to assign segment when the table is created, you should modify the parameter to False, which is the alter system set DEFERRED_SEGMENT_CREATION=FALSE. As follows:

技术分享

Oracle export times wrong exp-00011:table does not exist

Related Article

Cloud Intelligence Leading the Digital Future

Alibaba Cloud ACtivate Online Conference, Nov. 20th & 21st, 2019 (UTC+08)

Register Now >

Starter Package

SSD Cloud server and data transfer for only $2.50 a month

Get Started >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.