Today even the remote database export old project database
Finish with exp guide then import found that there are many table didn't guide come in
These tables should be empty table
Internet a similar problem with what the allocate the content not tried..
Is there any way to worship you a great god

CodePudding user response:

You can put your EXP command post and see

Can also use PLDEV directly export only the definition of user objects

CodePudding user response:

To the table to insert a record, don't commit and rollback directly can;

CodePudding user response:

The parameters of the 11 g deferred_segment_creation default is true
Create objects such as tables, no data will not immediately create segments
Exp, no segments of the object will not be exported,
Can use the method of the webmaster, this parameter can be set to false, then create a new object, will immediately create segments,

CodePudding user response:

After 11 g with this limit,

For the existing data, batch, refresh a
Select 'alter table' | | table_name | | 'the allocate among; 'the from user_tables;

CodePudding user response:

With the DDL can't data

CodePudding user response:

 select 'alter table' | | table_name | | 'the allocate among; 'the from user_tables where num_rows=0; 

Perform this copy result set out under the will be ready to export

CodePudding user response:

reference 1st floor sych888 response:

can put your EXP command post and see

Can also use PLDEV directly export only the definition of user objects

Exp arch/arch @ former file owner==XXX arch rows=n remember is like this

CodePudding user response:

reference 4 floor jdsnhan response:

after 11 g with this limit,

For the existing data, batch, refresh a
Select 'alter table' | | table_name | | 'the allocate among; 'the from user_tables;

I tried this but the batch I know refresh to do

CodePudding user response:

reference 1st floor sych888 response:

can put your EXP command post and see

Can also use PLDEV directly export only the definition of user objects

Finally, I seemed to do the guide table structure data are inserted again

CodePudding user response:

The simplest way, change expdp