Create Unix script to delete records in Oracle DB

Question

We have a UNIX box hosting an Oracle DB. We need to delete records on a daily basis from a table in this DB. We are setting up a scheduled job outside of Oracle that will run a script daily to do this.

Could you please help me create a .sh script file to do the same? I have the username/pwd for the DB.

The query is: DELETE FROM AUDIT_LOG WHERE EVENT_DATE <= SYSTIMESTAMP - 1;

Why not an Oracle Job? You could do the same thing without shell scripts. Is this an option? — Aleksej
– Aleksej, Commented Aug 4, 2016 at 15:23
Quite honestly, I prefer using Oracle Job. However, company policy for scheduled jobs is to use a separate scheduler that runs scripts and tracks them, etc. I have never written a script for Oracle related stuff and am not well-versed in UNIX scripting. — saz
– saz, Commented Aug 4, 2016 at 15:31

XING · Accepted Answer · 2016-08-04 15:16:52Z

1

In KORN shell you can do this as below:

#!/bin/ksh

`sqlplus "<schema_name>/<password>" << EOF

set feedback off
set heading off

DELETE FROM AUDIT_LOG WHERE EVENT_DATE <= SYSTIMESTAMP - 1;

exit;
EOF`

answered Aug 4, 2016 at 15:16

XING

9,9164 gold badges25 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

saz Over a year ago

Thanks. I will give this a try.

Collectives™ on Stack Overflow

Create Unix script to delete records in Oracle DB

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related