You are correct, it was supposed to reduce it back to minextents, unless
reause storage was specified.

Regards,
Patricia.

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


Patricia

Thanks, but that did not work either. Furthermore, truncating the table by
default is suppose to reduce the table to 1 extent, per Oracle's own
documentation. I'll keep searching...

> -----Original Message-----
> From: Patricia Karla Cordeiro [SMTP:[Email Address Removed] Sent: Friday, November 30, 2001 2:04 PM
> To: LazyDBA.com Discussion
> Subject: RE: Extents > 1 after Truncate
>
> 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] Sent: 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] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit 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 documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit 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
>

"WorldSecure" made the following
annotations on 11/30/01 14:09:06
----------------------------------------------------------------------------
--

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

============================================================================
==
Oracle LazyDBA home page