m2u-upass-admin / DBScript / create_upass_table.sql @ 150:394c7bd4fa4e
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 |