oracle匯出表不全解決辦法

標籤：

• 原因
  從dbatables查詢導不出的表，會發現他們不佔用空間，segmentcreated=‘NO‘
• 解決辦法
  查詢出來這些表，執行
  alert table xxx move;
  即可

declare
tbl varchar2(100);
s varchar2(1000);
cursor c is
select t.TABLENAME from dbatables t where t.OWNER=‘MES‘ and t.SEGMENTCREATED = ‘NO‘ and t.TABLENAME!=‘SQLNEXPLAINPLAN‘ and t.TABLE_NAME! =‘Sheet1$‘;
begin

open c;
fetch c into tbl;
while(c%FOUND)loop
s := ‘alter table ‘ || tbl || ‘ move ‘;
execute immediate s;
fetch c into tbl;
end loop;

close c;
end;

oracle匯出表不全解決辦法