01_change_schema.sql

set echo on feedback on

spool ./log/01_change_schema.log

-- -- schema change to v_idocdata_un --

-- -- switch to application user, use 业务 变量 --

connect &v_testdata_un/&v_testdata_pw@&v_conn_str

show   user

prompt &v_conn_str

prompt &v_conn_str

----------------------------- ---Developer Section place the code here -----------------------------

-- -- 执行变更 --

@./rollout/01_schema_rollout.sql

 

----
connect &v_testdata_un/&v_testdata_pw@&v_conn_str
show   user
prompt &v_conn_str

--赋权限给用户
@call_grant_dml &v_testusr_un
@call_grant_dml &v_testpatch_un
@call_grant_sel &v_testusr_un
@call_grant_sel &v_testpatch_un
@call_grant_sel &v_testquery_un
@call_grant_exec &v_testusr_un
@call_grant_exec &v_testpatch_un
disc

 

-- parameters

--   define v_input_un             = &1

--   define v_input_pw             = &2

--   define v_input_conn_str       = &3

--   define v_input_owner          = &4

--   define v_reconnect_un         = &5

--   define v_reconnect_pw         = &6

 --建议同义词

@call_create_syn &v_testusr_un  &v_testusr_pw &v_conn_str &v_testdata_un &v_testdata_un &v_testdata_pw

@call_create_syn &v_testpatch_un  &v_testpatch_pw &v_conn_str &v_testdata_un &v_testdata_un &v_testdata_pw

@call_create_syn &v_testquery_un  &v_testquery_pw &v_conn_str &v_testdata_un &v_testdata_un &v_testdata_pw

 --编译实效对象

@call_compile &v_testdata_un &v_testdata_pw &v_conn_str &v_testdata_un &v_testdata_pw

@call_compile &v_testusr_un &v_testusr_pw &v_conn_str &v_testdata_un &v_testdata_pw

@call_compile &v_testpatch_un &v_testpatch_pw &v_conn_str &v_testdata_un &v_testdata_pw

@call_compile &v_testquery_un &v_testquery_pw &v_conn_str &v_testdata_un &v_testdata_pw

 

spool off;
prompt ================================================================================
prompt Checking logs in the following directory ...
prompt
host pwd
prompt
prompt ======================================== grep -i 'ora-'
host   grep -i 'ora-'      ./log/*.log | sort -u
prompt
prompt ======================================== grep -i 'sp2-'
host   grep -i 'sp2-'      ./log/*.log | sort -u
prompt
prompt ======================================== grep -i '^Warning:'
host   grep -i '^Warning:' ./log/*.log | sort -u
prompt