Why bother with import/export, if what you want to end up with is a
table with lots of empty space, rely on updates or deletes. For
example,
Create table t1 (c1 number primary key, c2 varchar2(30), c3
varchar2(30), c4 varchar2(2000), c5 varchar2(2000));
Insert into t1 (c1,c2,c3,c4,c5)
Select rownum, object_name,
object_type,rpad('big1',2000,'.'),rpad('big2',2000,'.')
from all_objects where rownum < 50000;
commit;
Update t1 set c4='small1',c5='small2';
and/or
Delete t1 where mod(c1,3)=1;
Unless you are thinking of a table that has many segments, then you
should be thinking of creating a dummy table with a small initial and
next extent size, unless you are using locally managed tablespace, in
which case ...
Received on Mon Jan 10 2005 - 11:13:24 CST
