Hi!
No, data blocks below partitions high-high water mark can never be used for
another segment.
Unformatted blocks above (high)-high water mark can be used for another
segment only when you trim the extent(s) using alter table deallocate unused
(but this feature is useful only if you have lots
RDBMS Version: 9.2.0.1.0
Operating System and Version: Solaris 8
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): Partitioned Table
Product Version: 9.2.0.1.0
Table partitioning
Hi,
I've a query reg. space usage in context of partitioned tables.
I've a table with
more to the point, are the partitions all in the same tablespace?
--- John Weatherman [EMAIL PROTECTED] wrote:
Vikas,
Are you asking if deallocated extent space can be reused by the
current partition or wether new dates will suddenly go into a
partition that explicitly excludes them?
Vikas,
Are you asking if deallocated extent space can be reused by the current partition or
wether new dates will suddenly go into a partition that explicitly excludes them?
John P Weatherman
Oracle Database Administrator
Replacements, Ltd.
-Original Message-
Sent: Friday, October
Is the table hash-partitioned, range-partitioned, or list-partitioned?
-Original Message-
Vikas S
RDBMS Version: 9.2.0.1.0
Operating System and Version: Solaris 8
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): Partitioned Table
Product Version: 9.2.0.1.0