Not having data in the indexes as some have noted,
is not answer the question of whether or not the
index was truncated.
Here's a simple test that will answer the question.
Feel free to use this methodology in the future. :)
Jared
----------------------
drop table t;
create table t
tablespace users
as
select *
from dba_objects
/
create index t_idx on t (owner, object_name, created, last_ddl_time,
timestamp, status )
tablespace users
/
col segment_name format a30
col blocks format 999,999
col bytes format 999,999,999
select segment_name, sum(blocks) blocks, sum(bytes) bytes
from user_extents
where segment_name in ('T','T_IDX')
group by segment_name
/
truncate table t;
select segment_name, sum(blocks) blocks, sum(bytes) bytes
from user_extents
where segment_name in ('T','T_IDX')
group by segment_name
/
------------------------------
On Wed, 2003-07-30 at 07:59, Denham Eva wrote:
> Hello,
>
> When you truncate a table using:-
>
> TRUNCATE TABLE TEMP;
>
> does any of the indexes on the table also get truncated?
>
> TIA
> Denham Eva
> Oracle DBA
> Linux like TeePee... No Windows, No Gates and Apache inside!
>
>
> _____________________________________________________________________________________
> This e-mail message has been scanned for Viruses and Content and cleared
> by MailMarshal
>
> For more information please visit www.marshalsoftware.com
> _____________________________________________________________________________________
>
> #####################################################################################
> Note:
> This message is for the named person's use only. It may contain confidential,
> proprietary or legally privileged information. No confidentiality or privilege
> is waived or lost by any mistransmission. If you receive this message in error,
> please immediately delete it and all copies of it from your system, destroy any
> hard copies of it and notify the sender. You must not, directly or indirectly,
> use, disclose, distribute, print, or copy any part of this message if you are not
> the intended recipient. TFMC and any of its subsidiaries each reserve
> the right to monitor all e-mail communications through its networks.
>
> Any views expressed in this message are those of the individual sender, except where
> the message states otherwise and the sender is authorized to state them to be the
> views of any such entity.
>
> Thank You.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Denham Eva
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
