Ask the Expert

Scripts for NT to delete archived Oracle scripts

I would like to know if you have scripts for Windows NT on how to delete the archived scripts in Oracle.

    Requires Free Membership to View

I'm not really sure what you're asking. Are you asking how to delete archived redo log files?

If that's what you're asking my response is that after you've either moved them to tape or some other safe storage device where they can be retrieved in the case you'd need to restore from them, then you can simply delete those files from the directory where they are kept. This could be done with a batch file which could be ran on some kind of schedule and executed as part of the script that either moves your archived files to tape or other storage media.

I don't have a generic script to do this but I'd think it should be pretty straightforward to write one to suit your environment.

For More Information

This was first published in November 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: