Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_REPAIR, 6 of 8
This procedure rebuilds the freelists for the specified object. All free blocks are placed on the master freelist. All other freelists are zeroed.
If the object has multiple freelist groups, then the free blocks are distributed among all freelists, allocating to the different groups in round-robin fashion.
DBMS_REPAIR.REBUILD_FREELISTS ( schema_name IN VARCHAR2, partition_name IN VARCHAR2 DEFAULT NULL, object_type IN BINARY_INTEGER DEFAULT TABLE_OBJECT);
Parameter | Description |
---|---|
schema_name |
Schema name. |
object_name |
Name of the object whose freelists are to be rebuilt. |
partition_name |
Partition or subpartition name whose freelists are to be rebuilt. If this is a partitioned object, and partition_name is not specified, then all partitions and subpartitions are processed. If this is a partitioned object, and the specified partition contains subpartitions, then all subpartitions are processed. |
object_type |
Type of the object to be processed. This must be either See "Enumeration Types". |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|