Category Archives: Shell Script

To reset existing (Oracle) Sequence.

#Set the value of variable cnt_fx to reset the Oracle Sequence. #Replace owner and SEQUENCE_name with your schema owner and Sequence name. Login to Database and execute below SQLs: set serveroutput on declare cnt integer; — Target sequence number# — … Continue reading

Posted in Shell Script | Tagged | 9 Comments

Oracle database’s fixed_date feature usage script

Some time, there is requirement to advance the database‚Äôs date to test month end or advance date related batch process. One way to change the date at O/s level but it may difficult if there are more than databases in … Continue reading

Posted in Shell Script | Tagged | Leave a comment

Backup of control file (text format) of your database

Here is script that will create backup of control file (text format) of your database 1. It will identified trace file 2. Edit trace file to make neat and clean script to create control file 3. Copy to identify folder. … Continue reading

Posted in Shell Script | Tagged | Leave a comment