Peter
If you don't do anything to the indexes, like drop them, they will
be there when you load the data back. Of course, if your table is really
large, then the load time will be longer.
You may also want to investigate ALTER TABLE MOVE. Now that command
will require you to rebuild the indexes.
What are you trying to accomplish by moving, truncating, moving the
data back?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Wednesday, July 24, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
Hi Friends,
Iam reorganizing my tables thru copy(CTAS), So when Iam re-inserting data
into my Original table Will the indexes will build automatically or I have
to rebuild?? Here Iam not doing for indexes anything i.e Iam not disabling
it.
I want to create table thru CTAS, truncate original table, copy back data
into original table from duplicate table. So that I can pack data and get
back my space back. My environment is v7.3 on AIX.
Thanks in advance
peter.
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter R
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
