Is there any way to know particular record in a table is in which data file..?
Sure - row's ROWID will tell you exactly which file a particular row is comming from.
Jurij Modic ASCII a stupid question, get a stupid ANSI 24 hours in a day .... 24 beer in a case .... coincidence?
How to map this ROWID with the data file name..? create table t1(f1 number); insert into t1 values(1); commit; SQL> select rowid from t1; ROWID ------------------ AAAHojAAMAAAAAOAAA
dbms_rowid.rowid_relative_fno()
Forum Rules