Oracle DBA Blog

Thursday, April 25, 2013

Reclaiming Segment Space


alter table ae1t3.ID_TICKET_STOCK_MASTER enable row movement;
alter table ae1t3.ID_TICKET_STOCK_MASTER shrink space compact cascade;
alter table ae1t3.ID_TICKET_STOCK_MASTER disable row movement;


Posted by Adeel at 4/25/2013 10:40:00 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

My Profile

Adeel
View my complete profile

Labels

  • My Rman Backup Scripts (12)
  • Real Application Cluster (8)

Blog Archive

  • ►  2015 (3)
    • ►  November (1)
    • ►  March (2)
  • ►  2014 (2)
    • ►  September (1)
    • ►  April (1)
  • ▼  2013 (15)
    • ►  December (3)
    • ►  July (1)
    • ►  May (5)
    • ▼  April (5)
      • Oracle Database 10g: Analyze Index Vs. Gather_Inde...
      • Reclaiming Segment Space
      • Drop 10g Database using RMAN
      • Clone / Duplicate a database with RMAN
      • Encrypting Data in Oracle 10g: Transparent Data En...
    • ►  March (1)
  • ►  2012 (14)
    • ►  December (2)
    • ►  November (2)
    • ►  October (8)
    • ►  February (1)
    • ►  January (1)
  • ►  2011 (28)
    • ►  May (26)
    • ►  April (1)
    • ►  February (1)
  • ►  2009 (15)
    • ►  December (1)
    • ►  August (3)
    • ►  July (6)
    • ►  June (5)
  • ►  2006 (2)
    • ►  December (2)

Search This Blog

Simple theme. Powered by Blogger.