--在须要导出的用户表里面执行以下语句,保证空表也分配分配segment。当前用登陆plsql,执行下面语句
DECLARE CURSOR EMPTY_TABLES IS SELECT TABLE_NAME FROM USER_TABLES; BEGIN FOR TAB IN EMPTY_TABLES LOOP EXECUTE IMMEDIATE 'alter table ' || TAB.TABLE_NAME || ' allocate extent'; END LOOP; END;
exp BTO/BTO@TESTORCL file='Z:\db\20140901.dmp'