Alter Table Truncate Partition Drop Storage

Best Wallpaper Ideas website. Search anything about Wallpaper Ideas in this website.

Alter Table Truncate Partition Drop Storage. Alter table to_archive_from truncate partition to_empty_it. This method is most appropriate for small tables or for large tables when the partition being truncated contains a small percentage of the total data in the table.

Partitioning Concepts
Partitioning Concepts from docs.oracle.com

It worked for me. How to release the storage when truncating the partition oracle 10g. SELECT owner table_name TRUNCsumbytes 1024 1024 Meg FROM SELECT segment_name table_name owner bytes FROM.

I check the dba_free_space it shows the free space but while checking the HWM in dba_extent It is still set as high value and not showing free space in tablespace.

These clauses are parsed and ignored. How to release the storage when truncating the partition oracle 10g. For example the statement in the example shown below drops multiple partitions from the Range-partitioned table sales. SQL ALTER TABLE owner_nameSAMPLE_PARTITIONED_TBL 2 TRUNCATE PARTITION SMPL_201001 DROP STORAGE.