- Because ORACLE11G has a new feature, command line exp will only export tables that have been assigned segment, and if the number of table data bars in the database is 0 o'clock not assigned segment, it cannot be exported to solve this problem there are many ways to combine online and own practice, Give me a personal solution, with some tips ...
- Modify Deferred_segment_creation to False to disable this feature, but the existing table is not affected, and the modification is guaranteed to be valid only for the table created later
- alter system set DEFERRED_SEGMENT_CREATION=FALSE;
- First, check which tables are empty:
- Select table_name from user_tables where num_rows=0;
- Let's create an ALTER statement using SELECT
- Select ' ALTER TABLE ' | | table_name| | ' allocate extent; ' from User_tables where num_rows=0
- The function of this sentence is to generate some statements that help us to assign segment to the empty table above, so we are going to execute the following result SQL statement
- Here's a little trick, how many W records do you have to join the query? Is it a single piece of execution?
- We can do this.
- Click Export result set to generate a SQL file
- You can get this result by finding a replacement to put the public insert into User_tables (' altertable ' | | table_name| | ' All), values (', '), replace them with null characters, and execute the statements
oracle11g command Line Export table not fully resolved