What is it doing? Is it same as truncate / delete table in oracle.
Is truncate table supported in DB2?

-----Original Message-----
From: senthil1 [mailto:db2udbdba-ezmlmshield-x1416484.[Email address protected]
Sent: Tuesday, July 25, 2006 6:58 PM
To: LazyDBA Discussion
Subject: Re: drop a large table

IMPORT FROM /dev/null OF DEL REPLACE INTO schema.tablename;

then drop the table

Senthil S.
Tata Consultancy Services Limited
Mailto: senthil1.[Email address protected]
Website: http://www.tcs.com



"Rahul Yadav " <db2udbdba-ezmlmshield-x51117444.[Email address protected]
07/25/2006 06:43 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
drop a large table






I want to drop a table it has some 2 lakh records and taking too much
time,is there any way to do it fast??

Best Regards,

Rahul Yadav
Software Engineer
Daffodil Software Ltd.
2nd Floor,Vipul Orchid Plaza,
Sun City,Sector 54,
Gurgaon,India.

Mobile:+91 9868679702


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

ForwardSourceID:NT00014156
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page