1. Why the problem

Racle 11 g has a new feature, when countless according to the table, not distribution segment, to save space, when we exp is used to derive the empty table, unable to export, the solution is to two aspects, one is to deal with the existing empty table, can let its export; Second, set parameters, make the follow-up of new empty table can also export,
2. The solution
1.) deal with the problem when building user!
Set the system parameter, make the follow-up new table automatically assigned segment, query the system parameter, the parameter value is TRUE by default, when to FALSE, empty table or not empty table, is assigned segment.
Query: show the parameter deferred_segment_creation;

Amend the this parameter to FALSE, the modified statement is:
The alter system set deferred_segment_creation=false;

Query again confirm whether parameter modify success:
Show parameter deferred_segment_creation;

To implement export problem has been solved!

2. Before to modify parameters, empty table in the subsequent use individual found empty table can't export,

Login need to export the current user, perform the following statement
The alter table empty table shows that the allocate the extend;
Export change table can!

CodePudding user response:

2.
1.) deal with the problem when building user!


Not build user when processing, the other is good, suggest records in a blog post,

CodePudding user response:

Novice thank you help to correct, please attention

CodePudding user response:

This is the oracle of the bug

CodePudding user response:

Is, to build the library Settings once it doesn't matter when

CodePudding user response:

The

reference CKC reply: 3/f

this is oracle bug

reference 4 floor u014525726 response:

is, to build the library Settings once it doesn't matter when

This is not a bug, it is a new feature, that is specially made,

The purpose is to faster response the create table command,

CodePudding user response:

Bug, of course, I'm not saying that this new feature has a problem, in order to faster affect the create table table not allocate space under construction is reasonable, but this new feature need to consider the impact on other functions, and its impact on backup now, it is a serious bug, oracle purposely make backup problem?

CodePudding user response:

How can this say BUG... Oracle clearly the impact of this feature, and gives a method to solve, and 10 g oracle has recommended use data pump, of course, have to say the BUG, but in this day and age, oracle had time to modify the code, it is better to solve the BUG of rman backup time, a lot, after all, this is the real backup just auxiliary logical backup tool,

CodePudding user response:

refer to 7th floor minsic78 response:

this how can you say it's a BUG... Oracle clearly the impact of this feature, and gives a method to solve, and 10 g oracle has recommended use data pump, of course, have to say the BUG, but in this day and age, oracle had time to modify the code, it is better to solve the BUG of rman backup time, a lot, after all, this is the real backup logical backup tool just auxiliary,

Absolutely right should use expdp

CodePudding user response:

To execute the SQL:
Select 'alter table' | | table_name | | 'the allocate among; 'the from user_tables where num_rows=0 or num_rows is null;
The query of results posted it is ok to perform