Re: Oracle question

From: Sadhnani <sadhnani_at_rad.net.id>
Date: 1997/11/12
Message-ID: <3468EB5F.4DCEF2D7@rad.net.id>#1/1

This is a multi-part message in MIME format.
--------------E6792896403F4FBEE275DA92

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

Dear Taylor,

    If you don't need the table anymore then you can drop the table, or you could use the trunc command. (Truncate table command). Trunc and Drop table commands are DDL commands hence they do not use the rollback segments. Other commands like the delete, etc are DML commands and they have to use the rollback segment just in case you need to get back to the original situation (in case of mistakes, etc, etc).

Good Luck

Naresh

--------------E6792896403F4FBEE275DA92

Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Naresh Sadhnani
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Naresh Sadhnani
n:              Sadhnani;Naresh
org:            Bakrie Communications Corporation
adr:            Jln. Sunter Mas Barat II,;;H-9 No. 13;Jakarta (Utara);;14350;Indonesia
email;internet: sadhnani_at_rad.net.id
title:          IT Network Advisor
tel;work:       +62-21-9101112 (ext. 226)
tel;fax:        +62-21-6501182
tel;home:       +62-21-6508675

x-mozilla-cpt: ;0
x-mozilla-html: FALSE

version:        2.1
end:            vcard

--------------E6792896403F4FBEE275DA92--
Received on Wed Nov 12 1997 - 00:00:00 CST