DDL_Common.ksh listing of functions

lst_objs_all lst_obj_schm lst_objs_schm_tbls chg_profile qry_template_function lst_users lst_all_users – uses the function sho_users drp_app_users sho_users sho_users_locked sho_users_prf_default sho_quotas sho_sessions sho_session_02 sho_session_03 chg_quota_PIPER_D11_OWNER – This should take a parameter for owner schema and tablespace chg_pword_PIPER_D11_STAGING  

Change Password function

chg_pword() { USR=$1 PWRD=$2 ############################################## # This should replace the functions: #     chg_pword_all_SCHEMA_T11() # # Change SCHEMA_C21_* schema/users passwords # After schema creation we will run this # function could accept parameters for schema ############################################## echo echo “Change passwords for user/schema ${USR} ” echo sqlplus -s “/ as sysdba” <<EOF set lines 150 set pages […]

GoldenGate Functions

[code language=”sql”] gg_zipfile_chk() ####################################################### # If the directory exists see if the files is there ####################################################### { clear echo echo echo "Checking for the V46695-01.zip file" echo echo echo "Checking /ora01/Oracle_SW/gg121 for zip file ……." echo if [ -f /ora01/Oracle_SW/gg121/V46695-01.zip ]; then echo "…./ora01/Oracle_SW/gg121/V46695-01.zip file found….." else echo "…./ora01/Oracle_SW/gg121/V46695-01.zip file not found." fi echo echo […]