Re: delete data from table without rollback/logging?

Thanks for all the advice guys, been a great help!

Steve Salvemini wrote:
>
> Hi group, I'm running a cut down script on a copy of a live database to
> remove some 90%
> of the data.
>
> Currently I use delete statements to remove the data from 100's of
> tables.
> Another method I can use is to copy out 10% into a temp table, truncate
> the original and
> then copy the 10% back in, reducing the hit on the rollback segments.
>
> Regardless of which option I take, is there a faster option to delete
> and insert data without filling up the rollback segments.
>
> I see 'alter table xxx nologging' doesn't seem to be affected by
> deletes.
>
> Ideally an 'alter session nologging' statement would be useful.
>
> Also, I would have dedicated use of this database, if that helps with
> any ideas.
>
> Cheers
>
> Steve

-- 
-----------------------------------------------------------

Steven Salvemini
Peoplesoft Technical Specialist, Information Technology Services
ADELAIDE UNIVERSITY SA 5005
AUSTRALIA
Tel: +61 8 8303 6358  Fax: +61 8 8303 4400
Email: steve.salvemini_at_adelaide.edu.au

----------------------------------------------------------- 
This email message is intended only for the addressee(s) 
and contains information which may be confidential and/or
copyright.  If you are not the intended recipient please
do not read, save, forward, disclose, or copy the contents
of this email. If this email has been sent to you in error,
please delete this email and any copies or links to this
email completely and immediately from your system.  No 
representation is made that this email is free of viruses.
Virus scanning is recommended and is the responsibility of 
the recipient.