Sign in or 

-- parameters:begin
p_owner varchar2(30) := 'IDEEV'; --<-- owner
p_object_name varchar2(30) := 'CL_DATA'; --<-- table name
p_extent_id number := 0; --<-- extent number
-- variables
v_tablespace_name varchar2(30);
v_block_size number := 8192;
v_object_id number;
v_file_id number;
v_block_id number; -- first block number
v_blocks number; -- number of blocks
v_rowid_first rowid;
v_rowid_second rowid;
-- object_id
beginselect o.object_id into v_object_idexception
from dba_objects o
where o.owner = p_owner
and o.object_name = p_object_name
and o.object_type = 'TABLE';
when no_data_found
then dbms_output.put_line('Table not found: '||p_owner||'.'||p_object_name);
return;
end;
-- extent paramsend;
beginselect e.file_id, e.block_id, e.blocks, e.tablespace_nameexception
into v_file_id, v_block_id, v_blocks, v_tablespace_name
from dba_extents e
where e.owner = p_owner
and e.segment_name = p_object_name
and e.extent_id = p_extent_id;
when no_data_found
then dbms_output.put_line('Extent '||to_char(p_extent_id)||' of table '||p_owner||'.'||p_object_name||' not found');return;
-- db blcok size
-- first rowid
-- res
|
ideev |
Latest page update: made by ideev
, May 8 2008, 12:50 PM EDT
(about this update
About This Update
2 words added 1 word deleted view changes - complete history) |
|
Keyword tags:
extents
parallel export
partitioning
rowid
More Info: links to this page
|