Laura,
When you truncate, the High Water Mark is set back, but the extents are not
deallocated. To do this, issue an "alter table table_name deallocate
unused".

Regards,
Patricia.

-----Original Message-----
From: Thurow, Laura [mailto:[Email Address Removed] Sexta-feira, 30 de Novembro de 2001 17:02
To: LazyDBA.com Discussion
Subject: Extents > 1 after Truncate


Hi

I have a table with 5 extents. I truncated the table and it still has 5
extents and I cannot figure out why. Should it not be 1 extent after
truncation? Min extents is 1.

8.1.7 on HP-UX11.0




"WorldSecure" made the following
annotations on 11/30/01 14:00:37
----------------------------------------------------------------------------
--

[INFO] -- Virus Manager:
This message was scanned with Network Associates Viper,
and no viruses were detected.

============================================================================
==


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page