Bijoos OracleNotes – Page 96 – Mastering the Oracle Stack, One Post at a Time.

A PL/SQL Program – After many many years!

February 7, 2026August 2, 2013 by Biju

Wrote a little pl/sql program after several years… glad it worked as expected… thought of sharing the code, might be useful for someone out there… The requirement is to drop tables that are older than 60 days from a schema named CR_BKUP periodically. Did not want to just drop the tables, so taking a backup … Read more

OracleDB12c New Feature: ASMCMD Commands for Password File Management

February 7, 2026July 16, 2013 by Biju

Starting with Oracle Database 12c, we can store the ASM and Database password file on ASM storage. This is helpful for RAC databases and cluster as we do not have to manage to keep the files in sync between servers. ASMCMD in 12c includes several commands to manage password file. pwcopy Copies a password file … Read more