DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Partition Deletion - Resize probelm

Hybrid View

  1. #1
    Join Date
    Mar 2003
    Posts
    38

    Partition Deletion - Resize probelm

    Hi,

    Perhaps this would be very simple for you, could anyone give Corrections to this problem.

    Two tables (Table_x and Table_y) write to a partition called Test_Partition200604

    The objective is to truncate the data form these two tables (which are specific to the partition) and then reclaim space

    Commands used are:

    Alter table Table_x truncate partition Test_Partition200604 update global indexes;

    Alter table Table_y truncate partition Test_Partition200604 update global indexes;

    Alter database datafile '/u02/oradata/MySystem/db02/MySystem_TestPartition200604.dbf' resize 1100M;

    (the first two commands the tables were successfully truncated)
    - The Resize command fails and displays the following error message:

    *
    ERROR at line 1:
    ORA-03297: file contains used data beyond requested RESIZE value



    I have found the observation as :

    The tablespace map is checked and we find a block is still occuppied in the initial space; how do we remove this block id so the truncate will truly be successful.

    Thanks to everyone.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Have you looked at dba_extents to check what objects are represented by extents that encroach into the area you're trying to remove?

    It could be that the first extent of opne of those partitions is "higher" than you think, in which case you could execute a move to get it closer to the start of the data file.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Mar 2003
    Posts
    38

    Partitions Problem

    Thanks very much. It has solved most of the problem.
    __________________________________
    PVKDBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width