Re: doing a transaction that is not logged

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 11 Dec 2002 10:53:28 -0800
Message-ID: <at81j80lmj@drn.newsguy.com>

In article <3DF725DA.A9060E63_at_sita.int>, Francis says...
>
>Hello,
>
>AS I have to delete more than 100,000,000 records for a table I would
>like to be able to do this operation without journalization. So I will
>not have pb regarding temporary tablespace. Is it possible. I know that
>this is possible for some other databases.
>
>Thank you

How big is the table? If there are proportionally few records being left behind, copy them somewhere else, truncate the original table and insert from the copy.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Wed Dec 11 2002 - 12:53:28 CST