Z-Archive » Maybank Projects » M2U UPASS Project

set verify off

spool create_mss_table_log.txt

PROMPT ******* CREATE ADMIN_AUDIT_LOG TABLE *******

@/home/oracle/MPIFinalScript/admin_audit_log

PROMPT ******* CREATE IB_USER TABLE *******

@/home/oracle/MPIFinalScript/ib_user

PROMPT ******* CREATE ADMIN_ROLE TABLE *******

@/home/oracle/MPIFinalScript/admin_role

PROMPT ******* CREATE ADMIN_GROUP TABLE *******

@/home/oracle/MPIFinalScript/admin_group

PROMPT ******* CREATE ADMIN_USER_PROFILE TABLE *******

@/home/oracle/MPIFinalScript/admin_user_profile

PROMPT ******* CREATE ADMIN_NAVIGATION TABLE *******

@/home/oracle/MPIFinalScript/admin_navigation

PROMPT ******* CREATE ADMIN_NAVIGATION_GROUP TABLE *******

@/home/oracle/MPIFinalScript/admin_navigation_group

PROMPT ******* CREATE ADMIN_USER_SECURITY TABLE *******

@/home/oracle/MPIFinalScript/admin_user_security

PROMPT ******* CREATE IB_ORGANIZATION TABLE *******

@/home/oracle/MPIFinalScript/ib_organization

PROMPT ******* CREATE IB_ROLE TABLE *******

@/home/oracle/MPIFinalScript/ib_role

PROMPT ******* CREATE IB_GROUP TABLE *******

@/home/oracle/MPIFinalScript/ib_group

PROMPT ******* CREATE IB_CUST_PROFILE TABLE *******

@/home/oracle/MPIFinalScript/ib_cust_profile

PROMPT ******* CREATE IB_CUST_ACCOUNTS TABLE *******

@/home/oracle/MPIFinalScript/ib_cust_accounts

PROMPT ******* CREATE IB_USER_SECURITY *******

@/home/oracle/MPIFinalScript/ib_user_security

PROMPT ******* CREATE IB_NAVIGATION TABLE *******

@/home/oracle/MPIFinalScript/ib_navigation

PROMPT ******* CREATE IB_NAVIGATION_GROUP TABLE *******

@/home/oracle/MPIFinalScript/ib_navigation_group

PROMPT ******* CREATE IB_USER_TRANSACTION_HISTORY TABLE *******

@/home/oracle/MPIFinalScript/ib_user_transaction_history

PROMPT ******* CREATE IB_USER_PRINT_RECEIPT TABLE *******

@/home/oracle/MPIFinalScript/ib_user_print_receipt

PROMPT ******* CREATE IB_LOGIN_HISTORY TABLE *******

@/home/oracle/MPIFinalScript/ib_login_history

PROMPT ******* CREATE IB_CONTENT_TYPE TABLE *******

@/home/oracle/MPIFinalScript/ib_content_type

PROMPT ******* CREATE IB_CONTENT_CATEGORY TABLE *******

@/home/oracle/MPIFinalScript/ib_content_category

PROMPT ******* CREATE IB_BANCNET_LIST TABLE *******

@/home/oracle/MPIFinalScript/ib_bancnet_list

PROMPT ******* CREATE IB_BANK_BRANCH TABLE *******

@/home/oracle/MPIFinalScript/ib_bank_branch

PROMPT ******* CREATE IB_CURRENCY_CODE TABLE *******

@/home/oracle/MPIFinalScript/ib_currency_code

PROMPT ******* CREATE IB_PAYEE TABLE *******

@/home/oracle/MPIFinalScript/ib_payee

PROMPT ******* CREATE IB_SERVICE_INFO TABLE *******

@/home/oracle/MPIFinalScript/ib_service_info

PROMPT ******* CREATE IB_PRODUCT_TYPE TABLE *******

@/home/oracle/MPIFinalScript/ib_product_type

PROMPT ******* CREATE IB_SERVICE_TYPE TABLE *******

@/home/oracle/MPIFinalScript/ib_service_type

PROMPT ******* CREATE IB_SERVICE_LIST TABLE *******

@/home/oracle/MPIFinalScript/ib_service_list

PROMPT ******* CREATE IB_TD_TERM TABLE *******

@/home/oracle/MPIFinalScript/ib_td_term

PROMPT ******* CREATE IB_TD_INFO TABLE *******

@/home/oracle/MPIFinalScript/ib_td_info

PROMPT ******* CREATE IB_ACCOUNT_TYPE TABLE *******

@/home/oracle/MPIFinalScript/ib_account_type

PROMPT ******* CREATE SEQUENCE TABLE *******

@/home/oracle/MPIFinalScript/ib_sequence

PROMPT ******* CREATE IB_AUTO_LOAN TABLE *******

@/home/oracle/MPIFinalScript/ib_auto_loan

PROMPT ******* CREATE IB_PERSONAL_LOAN TABLE *******

@/home/oracle/MPIFinalScript/ib_personal_loan

PROMPT ******* CREATE IB_ADAPT TABLE *******

@/home/oracle/MPIFinalScript/ib_adapt

PROMPT ******* INSERT_DATA FOR IB_USER *******

@/home/oracle/MPIFinalScript/insert_ib_user

PROMPT ******* INSERT_DATA FOR ADMIN_ROLE *******

@/home/oracle/MPIFinalScript/insert_admin_role

PROMPT ******* INSERT_DATA FOR ADMIN_GROUP *******

@/home/oracle/MPIFinalScript/insert_admin_group

PROMPT ******* INSERT_DATA FOR ADMIN_USER_PROFILE *******

@/home/oracle/MPIFinalScript/insert_admin_user_profile

PROMPT ******* INSERT_DATA FOR ADMIN_NAVIGATION *******

@/home/oracle/MPIFinalScript/insert_admin_navigation

PROMPT ******* INSERT_DATA FOR ADMIN_NAVIGATION_GROUP *******

@/home/oracle/MPIFinalScript/insert_admin_navigation_group

PROMPT ******* INSERT_DATA FOR ADMIN_USER_SECURITY *******

@/home/oracle/MPIFinalScript/insert_admin_user_security

PROMPT ******* INSERT_DATA FOR IB_ORGANIZATION *******

@/home/oracle/MPIFinalScript/insert_ib_organization

PROMPT ******* INSERT_DATA FOR IB_ROLE *******

@/home/oracle/MPIFinalScript/insert_ib_role

PROMPT ******* INSERT_DATA FOR IB_GROUP *******

@/home/oracle/MPIFinalScript/insert_ib_group

PROMPT ******* INSERT_DATA FOR IB_USER_SECURITY *******

@/home/oracle/MPIFinalScript/insert_ib_user_security

PROMPT ******* INSERT_DATA FOR IB_NAVIGATION *******

@/home/oracle/MPIFinalScript/insert_ib_navigation

PROMPT ******* INSERT_DATA FOR IB_NAVIGATION_GROUP *******

@/home/oracle/MPIFinalScript/insert_ib_navigation_group

PROMPT ******* INSERT_DATA FOR IB_CONTENT_TYPE *******

@/home/oracle/MPIFinalScript/insert_ib_content_type

PROMPT ******* INSERT_DATA FOR IB_CONTENT_CATEGORY *******

@/home/oracle/MPIFinalScript/insert_ib_content_category

PROMPT ******* INSERT_DATA FOR IB_BANCNET_LIST *******

@/home/oracle/MPIFinalScript/insert_ib_bancnet_list

PROMPT ******* INSERT_DATA FOR IB_PAYEE *******

@/home/oracle/MPIFinalScript/insert_ib_payee

PROMPT ******* INSERT_DATA FOR IB_SERVICE_INFO *******

@/home/oracle/MPIFinalScript/insert_ib_service_info

PROMPT ******* INSERT_DATA FOR IB_PRODUCT_TYPE *******

@/home/oracle/MPIFinalScript/insert_ib_product_type

PROMPT ******* INSERT_DATA FOR IB_SERVICE_TYPE *******

@/home/oracle/MPIFinalScript/insert_ib_service_type

PROMPT ******* INSERT_DATA FOR IB_SERVICE_LIST *******

@/home/oracle/MPIFinalScript/insert_ib_service_list

PROMPT ******* INSERT_DATA FOR IB_TD_INFO *******

@/home/oracle/MPIFinalScript/insert_ib_td_info

PROMPT ******* INSERT_DATA FOR IB_ACCOUNT_TYPE *******

@/home/oracle/MPIFinalScript/insert_ib_account_type

spool off