Why don't you use truncate instead of delete...??
It's much much faster..
- William Beilstein <BeilstWH_at_obg.com> wrote:
> Did the delete finally finish, or did you abort it?
> Are there any columns in the table that are used as
> foreign references? Is there any reason that you
> can't issue a truncate table? Are your rollback
> segments large enough to hold all the data in all
> 30000 records?
>
> >>> David Turner <dturner_at_linuxcare.com> 06/26/00
> 11:11AM >>>
> Any idea why a delete of all the rows in a table
> might take hours when
> there are only 30,000 rows? There are no other users
> on the system.
> Rowlength is about 120.
>
>
> Dave Turner
>
> --
> Dave Turner, Senior Database Administrator,
> Linuxcare, Inc.
> 913.383.3052 tel, 913.579.3803 cel, 913.652.0687
> fax, 877.443.9553 pager
> dturner@linuxcare.com, http://www.linuxcare.com/
> Linuxcare. Support for the revolution.
> --
>
>
>
> --
> Author: William Beilstein
> INET: BeilstWH_at_obg.com
>
> 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: ListGuru_at_fatcity.com (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).
Ashish
Toronto, Canada
Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
Received on Mon Jun 26 2000 - 10:07:17 CDT
