Oracle Database Discussions

Hello friends,
Please help me to cnvert the below text file into required tables which are precreated or can WE CREATE THE TABLES ON THE FLY.

Also the below file is not the exact format as the amout of SPACES IS VARIABLE FOR DIFFERENT TABLES and the name of the table is in the SELECT CLAUSE

iis ti possible to create tables on the fly from the and aslo ONly the values SHOULD BE entering the data base file.
one more thing is the space delimiter is different for each and every table
KINDLY SUGGEST SOMETHING..i know SQL loader can be of help.BUT can u brief me on the use of the same with my text file.

heres the file
this is the text file

1> select * from coi
2> go
coi_index_number status
mkt_id_swno_0
mkt_id_swno_1
mkt_id_swno_2
mkt_id_swno_3
mkt_id_swno_4
mkt_id_swno_5
mkt_id_swno_6
mkt_id_swno_7
---------------- ------
-----------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
0 1
14656-62
NULL
NULL
NULL
NULL
NULL
NULL
NULL
1 0
14656-1
NULL
NULL
NULL
NULL
NULL
NULL
NULL
2 0
0
NULL
NULL
NULL
NULL
NULL
NULL
NULL
3 0
14656-1
14658-1
NULL
NULL
NULL
NULL
NULL
NULL
4 1
14656-114
NULL
NULL
NULL
NULL
NULL
NULL
NULL
6 1
61-56
NULL
NULL
NULL
NULL
NULL
NULL
NULL
7 0
14659-1
14657
NULL
NULL
NULL
NULL
NULL
NULL
45 0
14656-1
NULL
NULL
NULL
NULL
NULL
NULL
NULL
72 1
14656-1
NULL
NULL
NULL
NULL
NULL
NULL
NULL
73 1
15656-5
NULL
NULL
NULL
NULL
NULL
NULL
NULL
99 0
15656-5
NULL
NULL
NULL
NULL
NULL
NULL
NULL
255 0
0
NULL
NULL
NULL
NULL
NULL
NULL
NULL

(12 rows affected)
1>
2> select * from feature_ops
3> go
feature modified_feature feature_code op_class
------- ---------------- ------------ --------
1 1 114 99
1 2 115 99
4 2 118 99
4 3 119 99
56 1 120 99
56 2 121 99
11 1 122 99
56 3 123 99
56 1 124 99
4 1 125 99
16 1 126 99
16 2 127 99
14 1 131 99
14 2 132 99
1 2 199 99
57 2 229 99
1 1 301 99
1 2 302 99
3 1 303 99
3 2 304 99
2 1 305 99
2 2 306 99
45 1 308 99
2 1 309 99
2 2 310 99
4 2 311 99
4 3 312 99
4 1 313 99
11 2 314 99
16 1 315 99
16 2 316 99
56 3 317 99
56 1 318 99
3 1 319 99
3 2 320 99
46 1 321 99
46 2 322 99
45 1 323 99
57 2 333 99
57 2 367 99
57 2 400 99
57 2 401 99
57 2 402 99
57 2 403 99
57 2 409 99
57 2 410 99
57 2 411 99
57 2 412 99
57 2 413 99
57 2 440 99
57 2 445 99
57 2 447 99
57 2 448 99
57 2 449 99
57 2 450 99
57 2 451 99
57 1 456 99
57 2 462 99
57 2 463 99
57 2 464 99
57 2 472 99
57 2 480 99
57 2 481 99
57 2 482 99
57 2 483 99
57 2 485 99
57 2 486 99
57 2 488 99
57 2 490 99
57 2 491 99
57 2 492 99
57 2 493 99
57 2 500 99
25 2 501 99
25 3 502 99

(75 rows affected)
1>
2> select * from mscs_vlr
3> go
market_id swno std_ssn act_ssn our_ssn pc
sender_id_num msc_name sys_my_type
major_ver minor_ver patch_ver ssd_shared cave_cap discard_ssd
home_ntwk ext_features msc_class type_of_mwi home_netwk_cd_over
home_netwk_spina signal_threshold local_term auth_chan_cap block_sms
block_737 extended_roam international_msc global_title
otapa_authorized
----------- ---- ------- ------- ------- -----------
------------------------------ -------------------- -----------
----------- ----------- ----------- ---------- -------- -----------
--------- ------------ ----------- ----------- ------------------
---------------- ---------------- ---------- ------------- ---------
--------- ------------- ----------------- ---------------
----------------
1 100 7 7 6 1977660
3123149999 Lucent 30-45-60 3
150 1 43 1 1 66
11 5 132 1 55
22 100 13 18 100
8 56 0 NULL
NULL
14656 1 7 7 6 9281
5129898369 ECPMSC 8
150 77 85 1 1 0
0 1 3 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
NULL
14656 1 7 7 6 9283
5129898369 ECPMSC 3
150 77 85 1 1 0
0 1 3 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
1
14656 2 8 8 6 9413
1234567890 SANTERA 41
150 77 85 1 1 0
0 0 8 0 41
0 45 2 NULL NULL
NULL NULL 0 NULL
NULL
14656 5 7 7 6 7002
1234567890 ECPMSC5 3
150 77 85 1 1 0
0 1 3 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
NULL
14656 6 7 7 6 7003
1234567890 ECPMSC6 3
150 77 85 1 1 0
0 1 3 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
NULL
14656 11 7 7 6 9414
5129898369 IIF 3
150 77 85 1 1 0
0 0 3 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
NULL
14656 12 7 7 6 9418
5129898369 IIF2 3
150 77 85 1 1 0
0 0 3 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
0
14656 33 7 7 6 9283
5129898369 ECPMSC 3
150 77 85 1 1 0
0 1 3 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
1
14656 62 8 8 6 4676
5129898369 AMBMSC 3
150 77 85 1 1 0
0 1 3 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
NULL
14656 241 7 7 6 9283
5129898369 ECPMSC 3
150 77 85 1 1 0
0 1 3 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
1
15656 4 7 7 6 9312
1234567890 NORMSC 8
150 77 85 1 1 0
0 0 5 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
0
15656 5 7 7 6 9312
1234567890 NORMSC 8
150 77 85 1 1 0
0 0 5 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
NULL
16656 1 7 7 6 9314
5129898369 TELOSMSC 19
150 77 85 0 0 0
0 0 4 0 45
45 45 3 NULL NULL
NULL NULL 0 NULL
NULL
16656 2 7 7 6 9314
5129898369 TELOSMSC 19
150 77 85 0 0 0
0 0 4 0 45
45 45 3 NULL NULL
NULL NULL 0 NULL
NULL
16656 3 7 7 6 9314
5129898369 TELOSMSC 19
150 77 85 0 0 0
0 0 4 0 45
45 45 3 NULL NULL
NULL NULL 0 NULL
NULL
18656 1 7 8 6 9285
1234567890 EricMSC 4
150 77 85 0 1 0
0 1 6 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
NULL
18656 1 7 8 6 9296
1234567890 EricMSC 4
150 77 85 0 1 0
0 1 132 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
0
19656 31 7 7 6 9292
1234567890 MOTOSOSW 6
150 77 85 1 1 0
0 0 4 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
NULL
20656 100 7 8 6 9295
1234567890 HUAWEI GMSC 40
150 77 85 0 0 0
0 1 4 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
NULL
21656 101 7 8 6 9290
1234567890 HUAWEI SS 40
150 77 85 0 1 0
0 1 4 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
NULL
22656 1 7 8 6 9297
1234567890 ZTE SS 39
150 77 85 1 1 0
0 0 4 0 45
45 45 1 NULL NULL
NULL NULL 0 NULL
NULL
29656 1 7 7 6 9000
1234567 Temp 3
150 1 43 0 0 66
11 5 132 1 55
22 100 13 18 100
8 56 0 NULL
NULL
29657 1 7 7 6 9000
12345678 Temp123 3
150 1 43 0 0 66
11 5 132 1 55
22 100 13 18 100
8 56 0 NULL
NULL
31103 200 7 7 6 10466
1234567890 TSI_SYNEVERSE 41
150 77 85 1 1 0
0 0 8 0 41
0 45 2 NULL NULL
NULL NULL 0 NULL
NULL

(25 rows affected)
1>
2> select * from hlrs
3> go
hlr pc ssn sys_my_type market_id swno ac_active
ac_pc ac_ssn ac_sys_my_type mc_active mc_pc mc_ssn
sender_id_number auto_connect_csc rvr_restriction_code
f2timer lea_pc lea_ssn home_country_code home_escape_code
global_title fwd_chan_data_rate rev_chan_data_rate mc_global_title
sel_term_trigger_download unreldir_delay
-------------------- ----------- --- ----------- ----------- ---- ---------
----------- ------ -------------- --------- ----------- -----------
------------------------------ ---------------- --------------------
----------- ----------- ----------- ----------------- ----------------
--------------- ------------------ ------------------ ---------------
------------------------- --------------
MBMUMBXXXXM001HLR008 9218 6 14 14656 3 1
9218 6 14 1 9152 11
1234567890 0 0
0 0 0 NULL NULL
NULL NULL NULL NULL
0 NULL

(1 row affected)
1>
2> select * from lai_sdca
3> go
sdca_name loc_ar_id
------------------------------ -----------
ABCD 2
AMBL 10497
AMVT 20738
AN00 65470
ANND 7964
BANG 15618
BMTI 13
BR00 65471
BSSN 103
CALC 1044
CDGR 36103
CHNN 36160
CL00 65478
CN00 65472
CWAD 102
DAT0 90890
DL00 65473
DLHI 5377
FDBD 10503
GJ00 65474
GODH 7948
GRGN 10505
GZBD 41221
HLOL 7949
HP00 65475
HR00 65476
JK00 65490
KDKW 101
KL00 65477
KLYN 104
KT00 65479
MALEGAON 2546
MH00 65481
MP00 65480
MU00 65482
MUMB 11
NE00 65469
OR00 65483
PB00 65484
PDRA 7985
PUNE 12
RJ00 65485
SHML 1010
SRUR 31
THRB 202
TN00 65486
UPE0 65487
UPW0 65488
VDDR 7986
VSAI 18
WB00 65489
ZZZY 16
ZZZZ 15

(53 rows affected)
1>
2> select * from mss_lm_cap
3> go
mss_active mss_call_del_opt lm_active
---------- ---------------- ---------
1 4 0

(1 row affected)
1>
2> select * from servoptlist
3> go
servind dataopt1 dataopt2 dataopt3 faxopt1 faxopt2
stuopt
----------- ----------- ----------- ----------- ----------- -----------
-----------
1 33 3 4 5 20
NULL
2 34 16 5 18 36
NULL
3 33 1 154 9 56
NULL
5 33 3 4 5 20
NULL
6 33 3 4 12 13
NULL
7 33 3 4 20 21
NULL
8 33 3 4 20 5
NULL
9 33 3 4 20 5
NULL

(8 rows affected)
1>
2> select * from virtual_hlr
3> go
virtual_hlr mkt_id_0 mkt_id_1 mkt_id_2 mkt_id_3 mkt_id_4 mkt_id_5 mkt_id_6
mkt_id_7 mkt_id_8 mkt_id_9 mkt_id_10 mkt_id_11 mkt_id_12 mkt_id_13
mkt_id_14 mkt_id_15 csc_number
----------- -------- -------- -------- -------- -------- -------- --------
-------- -------- -------- --------- --------- --------- ---------
--------- --------- ----------
0 14656 22656 15656 21656 20656 16656 19656
NULL NULL NULL NULL NULL NULL NULL
NULL NULL 2235006767
1 0 0 NULL NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL
NULL NULL 2235006767
2 14656 15656 16656 NULL NULL NULL NULL
NULL NULL NULL NULL NULL NULL NULL
NULL NULL NULL

(3 rows affected)
1>
2> select * from vmscid_sdca
3> go
sdca_name vmarket_id vswno market_id swno
------------------------------ ----------- ----- ----------- ----
B 15656 4 15656 5
C 15656 6 15656 5

(2 rows affected)
1>
2> select * from win_services
3> go
win_service_index win_service_name win_address_format win_address_pc
win_address_ssn win_address_global_title CNID_marketid CNID_swno
----------------- -------------------- ------------------ --------------
--------------- -------------------------- ------------- -----------
1 PREPAID1 1 9441
14 NULL NULL NULL
2 prepaid2 1 9441
14 NULL NULL NULL
3 PREPAID3 1 9441
14 NULL NULL NULL
4 PREPAID4 1 9441
14 NULL NULL NULL
5 PREPAID5 1 9441
14 NULL NULL NULL
6 PREPAID6 1 9441
14 NULL NULL NULL
9 PREPAID9 1 9441
14 NULL NULL NULL
10 PREPAID2 1 9218
6 NULL NULL NULL
11 Eserve 1 9444
14 NULL NULL NULL
12 Lucent 1 9448
14 NULL NULL NULL
13 Lucent 1 9449
14 NULL NULL NULL
14 E-SERVE2 1 9446
14 NULL NULL NULL
15 COMV2 1 9454
14 NULL NULL NULL
16 ZTEPP 1 9455
14 NULL NULL NULL
25 FWP1 1 9666
14 NULL NULL NULL
44 PREPAID44 1 9441
14 NULL NULL NULL
99 NORTEL 1 9441
14 NULL NULL NULL

(17 rows affected)
1>
2> select * from win_trigger_prof
3> go
win_service_index message_type trig_all_calls trig_double_intro_star
trig_single_intro_star trig_home_sys_feature_code
trig_double_intro_pound trig_single_intro_pound trig_revertive_call
trig_0_digit trig_1_digit trig_2_digit trig_3_digit trig_4_digit
trig_5_digit trig_6_digit trig_7_digit trig_8_digit trig_9_digit
trig_10_digit trig_11_digit trig_12_digit trig_13_digit trig_14_digit
trig_15_digit trig_local_call trig_intra_lata_toll_call
trig_inter_lata_toll_call trig_world_zone_call trig_international_call
trig_unrecognized_number trig_prior_agreement
trig_spec_called_party_digit trig_mobile_termination
trig_advanced_termination trig_location trig_local_allow_spec_digit
trig_orig_attempt_authoized trig_calling_rout_addr_avail
trig_initial_termination trig_called_rout_addr_avail trig_o_answer
trig_o_disconnect trig_term_resource_avail trig_t_busy
trig_t_no_answer trig_t_no_page_response trig_t_unroutable
trig_t_answer trig_t_disconnect
----------------- ------------ -------------- ----------------------
---------------------- --------------------------
----------------------- ----------------------- -------------------
------------ ------------ ------------ ------------ ------------
------------ ------------ ------------ ------------ ------------
------------- ------------- ------------- ------------- -------------
------------- --------------- -------------------------
------------------------- -------------------- -----------------------
------------------------ --------------------
---------------------------- -----------------------
------------------------- ------------- ---------------------------
--------------------------- ----------------------------
------------------------ --------------------------- -------------
----------------- ------------------------ -----------
---------------- ----------------------- -----------------
------------- -----------------
1 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
1 ROUTREQ1 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
1 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
1 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
1 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
0 0
1 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
1 1
1 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
1 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 1
0 0 1
1 0 0
0 0 0
1 1
1 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
2 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
2 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
2 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
2 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
0 0
2 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
1 1
2 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
2 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 1
0 0 1
1 0 0
0 0 0
1 1
2 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
3 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
3 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
3 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 0
3 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 0
3 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 0
3 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
3 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 0
3 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
4 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
4 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
4 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
4 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
0 0
4 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
1 1
4 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
4 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 1
0 0 1
1 0 0
0 0 0
1 1
4 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
5 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
5 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
5 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
5 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
0 0
5 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
1 1
5 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
5 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 1
0 0 1
1 0 0
0 0 0
1 1
5 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
6 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
6 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
6 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
6 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
0 0
6 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
1 1
6 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
6 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 1
0 0 1
1 0 0
0 0 0
1 1
6 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
11 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
11 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
11 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
11 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
0 0
11 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
1 1
11 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
11 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 1
0 0 1
1 0 0
0 0 0
0 0
11 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
12 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
12 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
12 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
12 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
0 0
12 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
1 1
12 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
12 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 1
0 0 1
1 0 0
0 0 0
1 1
12 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
13 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
13 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
13 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
13 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
0 0
13 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
1 1
13 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
13 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 1
0 0 1
1 0 0
0 0 0
1 1
13 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
14 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
14 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
14 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
14 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
0 0
14 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
1 1
14 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
14 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 1
0 1 1
1 0 0
0 0 0
0 0
14 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
15 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
15 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
15 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
15 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
0 0
15 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
1 1
15 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
15 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 1
0 1 1
1 0 0
0 0 0
1 1
15 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
16 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
16 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
16 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
16 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
0 0
16 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 1 0
0 0
1 1 0
0 0 0
0 0 0
1 1
16 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
16 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 1
0 1 1
1 0 0
0 0 0
1 1
16 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0
25 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 0
25 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 0
25 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 0
25 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 0
25 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 0
25 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 0
25 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 0
0 0 0
0 0 0
0 0 0
0 0
25 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
0 0 0
0 0 0
0 0 0
0 0
99 ROUTREQ 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
99 featreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
99 locreq_CF 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 1
0 0
99 locreq_IS 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
1 1 0
0 0 0
0 0 1
0 0
99 locreq_LT 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 0
1 1 0
0 0 0
0 0 1
1 1
99 orreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 1 1
1 0 0
0 0 0
1 1
99 profile 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
1 1
0 0 1
1 0 0
0 0 1
1 1
99 tranumreq 0 0
0 0
0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0
0 0 0
0 0
0 0
0 0 0
0 1
0 0 1
1 0 0
0 0 0
0 0

(113 rows affected)
1>
2> select * from smsc
3> go
sms_index sms_name sms_pc sms_ssn sms_our_ssn sms_class
sms_mdn sms_global_title
--------- -------------------- ----------- ------- ----------- -----------
------- ----------------
1 SMSC_One 9664 11 6 0
1 NULL
2 FLDSMSC 9152 11 6 0
1 NULL
3 OWSMSC 9219 11 6 0
1 NULL
4 SANDESH_SMSC 9666 11 6 0
1 NULL
5 SANDESH_TSMSC 4500 11 6 0
1 NULL

(5 rows affected)
1>
2> select * from call_area_circle
3> go
call_area_circle_id market_id swno
------------------- ----------- ----
0 14656 1
1 14656 1
2 14655 201
2 14656 1
3 14656 1
4 14656 1
5 14656 1
5 15656 5
6 14656 1
7 14656 1
8 14656 1
9 14656 1
10 14656 1
11 14656 1
12 14656 1
13 14656 1
14 14656 1
15 14656 1
16 14656 1
17 14656 1
18 14656 1
19 14656 1
20 14656 1
21 14656 1
22 14656 1
23 14656 2
24 14656 3
25 19656 31
26 14656 62
27 16656 1
28 22656 1

(31 rows affected)
1>
2> use authcenter
3> go
1>
2> select * from ac
3> go
ac_name pc ssn sys_my_type
sender_id_number global_deny_access auth_reg
auth_call_orig auth_page_resp auth_flash_req init_uchalupd_on_fail
init_ssdupd_on_fail num_uchal_invoke num_counts uchal_threshold
count_threshold count_delta aav auth_trans_threshold
validate_count update_count_reg update_count_call_orig
update_count_page_resp update_count_flash_req
-------------------- ----------- --- -----------
------------------------------ ------------------ --------
-------------- -------------- -------------- ---------------------
------------------- ---------------- ----------- ---------------
--------------- ----------- ----------- --------------------
-------------- ---------------- ----------------------
---------------------- ----------------------
AUSTIN 16646410 6 23
1234567890 0 1
1 1 1 1
1 3 250 2
3 5 199 200
0 0 0
0 0

(1 row affected)
1>
2> select * from cos
3> go
class_id global_deny_access auth_reg auth_call_orig auth_page_resp
auth_flash_req init_uchalupd_on_fail init_ssdupd_on_fail
num_uchal_invoke num_counts uchal_threshold count_threshold
count_delta aav auth_trans_threshold validate_count
update_count_reg update_count_call_orig update_count_page_resp
update_count_flash_req ssdupd_num_retry_notatt ssdupd_num_retry_noresp
ssdupd_num_retry_fail uchal_num_retries_notatt
uchal_num_retries_noresp timely_ssd_upd_delay
----------- ------------------ -------- -------------- --------------
-------------- --------------------- -------------------
---------------- ----------- --------------- ---------------
----------- ----------- -------------------- --------------
---------------- ---------------------- ----------------------
---------------------- ----------------------- -----------------------
--------------------- ------------------------
------------------------ --------------------
0 0 1 1 1
1 0 0
1 0 1 0
0 199 3 0
0 0 0
0 0 0
0 0
0 0

(1 row affected)
1