René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

dbms_space_admin

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
);