Procedures/Functions
segment_corrupt
procedure segment_corrupt (
tablespace_name in varchar2 ,
header_relative_file in binary_integer ,
header_block in binary_integer ,
corrupt_option in binary_integer default
);
segment_drop_corrupt
procedure segment_drop_corrupt (
tablespace_name in varchar2 ,
header_relative_file in binary_integer ,
header_block in binary_integer
);
segment_dump
procedure segment_dump (
tablespace_name in varchar2 ,
header_relative_file in binary_integer ,
header_block in binary_integer ,
dump_option in binary_integer default
);
segment_moveblocks
procedure segment_moveblocks (
segment_owner in varchar2 ,
segment_name in varchar2 ,
partition_name in varchar2 ,
segment_type in varchar2 ,
group_id in binary_integer ,
minimum_size in binary_integer ,
move_count in binary_integer ,
pause_time in binary_integer ,
iterations in binary_integer
);
segment_number_blocks
function segment_number_blocks returns number(126)
(
header_tablespace_id in binary_integer ,
header_relative_file in binary_integer ,
header_block in binary_integer ,
segment_type in binary_integer ,
buffer_pool_id in binary_integer ,
dictionary_flags in binary_integer ,
data_object_id in number ,
dictionary_blocks in number
);
segment_number_extents
function segment_number_extents returns number(126)
(
header_tablespace_id in binary_integer ,
header_relative_file in binary_integer ,
header_block in binary_integer ,
segment_type in binary_integer ,
buffer_pool_id in binary_integer ,
dictionary_flags in binary_integer ,
data_object_id in number ,
dictionary_extents in number
);
segment_verify
procedure segment_verify (
tablespace_name in varchar2 ,
header_relative_file in binary_integer ,
header_block in binary_integer ,
verify_option in binary_integer default
);
tablespace_fix_bitmaps
procedure tablespace_fix_bitmaps (
tablespace_name in varchar2 ,
dbarange_relative_file in binary_integer ,
dbarange_begin_block in binary_integer ,
dbarange_end_block in binary_integer ,
fix_option in binary_integer
);
tablespace_fix_segment_extblks
procedure tablespace_fix_segment_extblks (
tablespace_name in varchar2
);
tablespace_fix_segment_states
procedure tablespace_fix_segment_states (
tablespace_name in varchar2
);
tablespace_migrate_from_local
procedure tablespace_migrate_from_local (
tablespace_name in varchar2
);
tablespace_migrate_to_local
procedure tablespace_migrate_to_local (
tablespace_name in varchar2 ,
unit_size in binary_integer default,
rfno in binary_integer default
);
tablespace_rebuild_bitmaps
procedure tablespace_rebuild_bitmaps (
tablespace_name in varchar2 ,
bitmap_relative_file in binary_integer default,
bitmap_block in binary_integer default
);
tablespace_rebuild_quotas
procedure tablespace_rebuild_quotas (
tablespace_name in varchar2
);
tablespace_relocate_bitmaps
procedure tablespace_relocate_bitmaps (
tablespace_name in varchar2 ,
filno in binary_integer ,
blkno in binary_integer
);
tablespace_verify
procedure tablespace_verify (
tablespace_name in varchar2 ,
verify_option in binary_integer default
);
|