SQL> create table t (val number)
2 partition by range (val)
3 ( partition p1 values less than (10) tablespace ts_d01,
4 partition p2 values less than (maxvalue) tablespace ts_i01 )
5 /
Table created.
SQL> insert into t values (1);
1 row created.
SQL> insert into t values (11);
1 row created.
SQL> select val, tablespace_name
2 from t, dba_data_files
3 where dbms_rowid.rowid_to_absolute_fno(t.rowid,user,'T') = file_id
4 /
VAL TABLESPACE_NAME
---------- ------------------------------
1 TS_D01
11 TS_I01
2 rows selected.
Regards
Michel