m2u-upass-admin / DBScript / create_upass_table.sql @ 84:e4aeb9fdab76
History | View | Annotate | Download (753 Bytes)
| 1 | 0:ea666cc7880e | hadi | set verify off
|
|---|---|---|---|
| 2 | spool create_upass_table_log.txt |
||
| 3 | |||
| 4 | --
|
||
| 5 | -- create tables, sequences and constraint
|
||
| 6 | --
|
||
| 7 | |||
| 8 | PROMPT ******* CREATE TB_AM_USERMAS TABLE ******* |
||
| 9 | @/home/oracle/MPIFinalScript/tb_am_usermas
|
||
| 10 | |||
| 11 | PROMPT ******* CREATE TB_AM_USER TABLE ******* |
||
| 12 | @/home/oracle/MPIFinalScript/tb_am_user
|
||
| 13 | |||
| 14 | PROMPT ******* CREATE TB_AM_TAC TABLE ******* |
||
| 15 | @/home/oracle/MPIFinalScript/tb_am_tac
|
||
| 16 | |||
| 17 | PROMPT ******* CREATE Indexes ******* |
||
| 18 | @/home/oracle/MPIFinalScript/tb_index
|
||
| 19 | |||
| 20 | PROMPT ******* INSERT DATA FOR TB_AM_USERMAS ******* |
||
| 21 | @/home/oracle/MPIFinalScript/insert_tb_am_usermas
|
||
| 22 | |||
| 23 | PROMPT ******* INSERT DATA FOR TB_AM_USER ******* |
||
| 24 | @/home/oracle/MPIFinalScript/insert_tb_am_user
|
||
| 25 | |||
| 26 | PROMPT ******* INSERT DATA FOR TB_AM_TAC ******* |
||
| 27 | @/home/oracle/MPIFinalScript/insert_tb_am_tac
|
||
| 28 | |||
| 29 | spool off |