EOY Table Freeze for Audits

 Problem Description : 

For end of year close out - table freeze for audit purposes

 Resolution : 

Run the AUDIT2004 schema export on database and Secure FTP down the dmp and log file via FileZilla. 

Login as Oracle

> expdp baninst1 schemas=AUDIT2004 directory=EXP_SCHEMA dumpfile=audit16.dmp logfile=audit16.log

The location the files are saved is /home/oracle/datadump/

Burn dmp and log to DVD to archive previous year

After verifying dump is saved on the DVD, highlight all tables under AUDIT2004 schema and dropped them in Toad.

Read email sent from USG concerning table freeze and verify tables listed are in \\heron\d$\batch\sqls\eoy_table_freeze.sql. If not, add a SQL command for the new table.

Change table names in SQL to match the year you are running the table freeze.

Run (or schedule) Scheduled Task on Heron to capture table freeze ('EOY Table Feeze' under Gordon Tasks folder)

 Revision Date : 6/30/2017