Truncate subpartition doesn't remove data
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Truncate subpartition doesn't remove data

Threaded View

  1. #1
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925

    Truncate subpartition doesn't remove data

    Hi Folks,

    This had been a mystry to me. I created a composite patrtition table on a 9i database, whose primary partition is of RANGE and the subpartition of LIST.

    Now when I issue



    ALTER TABLE table_name
    TRUNCATE SUBPARTITION sub_partition_name
    REUSE/DROP STORAGE;



    it says the "Table truncated". Then when I do a query on the subpartition, it fetches me all the data that was there before the truncate.

    Any thoughts on this?

    Thanx,
    Sam
    Last edited by sambavan; 08-10-2005 at 01:51 PM.
    Thanx
    Sam



    Life is a journey, not a destination!


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