m2u-upass-admin / DBScript / create_upass_table.sql @ 57:a56d6d60e738
History | View | Annotate | Download (753 Bytes)
1 |
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 |
30 |
|