TRUNCATE Before Drop ???
- From: BN <bnsarma@xxxxxxxxx>
- To: oracle_L_list <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Apr 2007 10:24:02 -0400
Greetings
This is dropping a Big Table around 150 GB in different Oracle Versions
(8i,9i,10g) with LMTS and Dictionary TBS
Can a TRUNCATE Table Before drop help in system resources and drop time?
--
Regards & Thanks
BN
- Follow-Ups:
- Re: TRUNCATE Before Drop ???
- From: Jared Still
- Re: TRUNCATE Before Drop ???
- From: rjamya
- Re: TRUNCATE Before Drop ???
- From: K Gopalakrishnan
Other related posts:
- » TRUNCATE Before Drop ???
- » Re: TRUNCATE Before Drop ???
- » Re: TRUNCATE Before Drop ???
- » Re: TRUNCATE Before Drop ???
- » Re: TRUNCATE Before Drop ???
- » Re: TRUNCATE Before Drop ???
- Re: TRUNCATE Before Drop ???
- From: Jared Still
- Re: TRUNCATE Before Drop ???
- From: rjamya
- Re: TRUNCATE Before Drop ???
- From: K Gopalakrishnan