declare
tn number;
type t_c is ref cursor;
l_c t_c;
v varchar2(400);
begin
for t_name in (select segment_name from dba_segments where tablespace_name='TOOLS') loop
v:='select 1 from '||t_name.segment_name||' where dbms_rowid.rowid_relative_fno(rowid)=4 and rownum<2';
open l_c for v;
fetch l_c into tn;
exit when l_c%notfound;
dbms_output.put_line(t_name.segment_name);
close l_c;
end loop;
end;
/
TOOLS是你的 datafile 在的表空间 dbms_rowid.rowid_relative_fno(rowid)=4这个 4 是datafile 的no
tn number;
type t_c is ref cursor;
l_c t_c;
v varchar2(400);
begin
for t_name in (select segment_name from dba_segments where tablespace_name='TOOLS') loop
v:='select 1 from '||t_name.segment_name||' where dbms_rowid.rowid_relative_fno(rowid)=4 and rownum<2';
open l_c for v;
fetch l_c into tn;
exit when l_c%notfound;
dbms_output.put_line(t_name.segment_name);
close l_c;
end loop;
end;
/
TOOLS是你的 datafile 在的表空间 dbms_rowid.rowid_relative_fno(rowid)=4这个 4 是datafile 的no