doh, I knew that.
thanks!
yes - it would be an issue if you truncate:
ops$tkyte%ORA10GR2> CREATE TABLE t
2 (
3 dt date,
4 x int,
5 y varchar2(30)
6 )
7 PARTITION BY RANGE (dt)
8 (
9 PARTITION part1 VALUES LESS THAN (to_date('13-mar-2003','dd-mon-yyyy')) ,
10 PARTITION part2 VALUES LESS THAN (to_date('14-mar-2003','dd-mon-yyyy')) ,
11 PARTITION junk VALUES LESS THAN (MAXVALUE)
12 )
13 /
Table created.
ops$tkyte%ORA10GR2> select subobject_name, object_id, data_object_id from user_objects where object_name = 'T';
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID
------------------------------ ---------- --------------
JUNK 153914 153914
PART1 153912 153912
PART2 153913 153913
153911
ops$tkyte%ORA10GR2> insert into t select to_date( '11-mar-2003', 'dd-mon-yyyy' )+rownum, rownum, rownum from all_users where rownum <= 3;
3 rows created.
ops$tkyte%ORA10GR2> truncate table t;
Table truncated.
ops$tkyte%ORA10GR2> select subobject_name, object_id, data_object_id from user_objects where object_name = 'T';
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID
------------------------------ ---------- --------------
JUNK 153914 153917
PART1 153912 153915
PART2 153913 153916
153911
ops$tkyte%ORA10GR2> insert into t select to_date( '11-mar-2003', 'dd-mon-yyyy' )+rownum, rownum, rownum from all_users where rownum <= 3;
3 rows created.
ops$tkyte%ORA10GR2> select t.dt, uo.subobject_name, dbms_rowid.rowid_object(t.rowid)
2 from t, user_objects uo
3 where dbms_rowid.rowid_object(t.rowid) = uo.object_id(+)
4 /
DT SUBOBJECT_NAME DBMS_ROWID.ROWID_OBJECT(T.ROWID)
--------- ------------------------------ --------------------------------
14-MAR-03 153917
13-MAR-03 153916
12-MAR-03 153915
ops$tkyte%ORA10GR2>
ops$tkyte%ORA10GR2> select t.dt, uo.subobject_name, dbms_rowid.rowid_object(t.rowid)
2 from t, user_objects uo
3 where dbms_rowid.rowid_object(t.rowid) = uo.data_object_id(+)
4 /
DT SUBOBJECT_NAME DBMS_ROWID.ROWID_OBJECT(T.ROWID)
--------- ------------------------------ --------------------------------
13-MAR-03 PART2 153916
12-MAR-03 PART1 153915
14-MAR-03 JUNK 153917
ops$tkyte%ORA10GR2>