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

----------------------------- ---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