Guest User

bsndump

a guest
Jul 5th, 2015
375
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. AnonOpsIndia (https://twitter.com/opindia_revenge)
  2.  
  3. The following are the databases that were dumped. We filtered out the Oracle crap. Only kept all the BSNL related stuff.
  4.  
  5. [*] ADVCONV
  6. [*] APPTAB
  7. [*] BILLWLL
  8. [*] CASHCTR
  9. [*] CSMS
  10. [*] FRS
  11. [*] DBMAINT
  12. [*] PERFSTAT
  13. [*] SLBACK
  14. [*] TJBSNL
  15. [*] TOAD
  16. [*] TRANSFER
  17. [*] UDAAN
  18.  
  19. Database: ADVCONV
  20. [16 tables]
  21. +----------------+
  22. | MAN_ACSRY |
  23. | MAN_ACSRYADRS |
  24. | MAN_ACSRYCLSR |
  25. | MAN_ADDRESS |
  26. | MAN_ADVCDTL |
  27. | MAN_ADVCSUMRY |
  28. | MAN_MISCCHRG |
  29. | MAN_NEWAPPLN |
  30. | MAN_PAYMENT |
  31. | MAN_TCPADRS |
  32. | MAN_TCPADVCDTL |
  33. | MAN_TCPAPPLN |
  34. | MAN_TCPPYMNT |
  35. | MAN_TXNAPPLN |
  36. | MAN_WOCNTRL |
  37. | MAN_WRKORDR |
  38. +----------------+
  39.  
  40. back-end DBMS: Oracle
  41. Database: APPTAB
  42. [244 tables]
  43. +--------------------------+
  44. | ARCHV_PLANCHNG |
  45. | AVC_MONTHLY_CDRS |
  46. | BBRFND_TMISCCHRG |
  47. | BB_RECON_REJ |
  48. | CC_PAY_FRANCHISE |
  49. | CC_TPAYMENT |
  50. | CC_TPAYMENT_CORP |
  51. | CC_TPAYMENT_ERR_NOUSE |
  52. | CDMA_BILLS |
  53. | CI_OLDNEW_WL |
  54. | CI_REFADDRESS |
  55. | DATAONE_MONTHLY_CDRS |
  56. | DATAONE_MONTHLY_CDRS_ERR |
  57. | ECS_HISTORY_TPAYMENT |
  58. | ECS_TPAYMENT |
  59. | EPBXMR |
  60. | GAME_MONTHLY_CDRS |
  61. | HGOD_MONTHLY_CDRS |
  62. | HMOD_MONTHLY_CDRS |
  63. | INTRFCVOU |
  64. | KNPPLAN1 |
  65. | LED_VPTGPT |
  66. | MBILLSUMRY_0509 |
  67. | MISRNO |
  68. | MSUBSCRBR_LOG |
  69. | MSUBSCRBR_UB |
  70. | M_ADDRESS_ARCHV |
  71. | M_BILLDTL |
  72. | M_BILLSUMRY |
  73. | M_CENTREX |
  74. | M_ECSDTL |
  75. | M_EPBXMST |
  76. | M_EPBX_SPAREMST |
  77. | M_FTTHACSRY |
  78. | M_FTTHVOICE |
  79. | M_LINEMAN |
  80. | M_PLANACSRY |
  81. | M_PLANACSRY_PREPAID |
  82. | M_PLANACSRY_VPN |
  83. | M_PLANACSRY_WLL |
  84. | M_PLANGROUP |
  85. | M_TRIPPLE_PLANDET |
  86. | M_TRIPPLE_PLAY |
  87. | M_VILLAGE |
  88. | M_VPN_MASTER |
  89. | OSTEMP |
  90. | PRN_LST |
  91. | PSUBABF |
  92. | PSUBCCL |
  93. | P_SUBLEDGER |
  94. | P_SUBPAY |
  95. | RENUM_SUBSCRBR |
  96. | SUB_ABF |
  97. | SUB_ABF_IN |
  98. | SUB_ABF_IS |
  99. | SUB_ABF_TMP2 |
  100. | SUB_CCL_BB |
  101. | SUB_CCL_IN |
  102. | SUB_CCL_IS |
  103. | SUB_CCL_SC |
  104. | SUB_CHD |
  105. | SUB_CHD_BB |
  106. | SUB_CHD_IN |
  107. | SUB_CHD_IS |
  108. | SUB_CLEAR |
  109. | SUB_CLEAR_BB |
  110. | SUB_CLEAR_CR |
  111. | SUB_CLEAR_IN |
  112. | SUB_CLEAR_IS |
  113. | SUB_EXCESS_RAISED |
  114. | TBBAND_ERR |
  115. | TBBAND_P3 |
  116. | TBROADBAND_ARCHV |
  117. | TCDTMXVAL |
  118. | TCDTMX_ERR |
  119. | TDATAONE_MONTHLY_CDRS_P3 |
  120. | TIVRS_ERR |
  121. | TNTC_BROADBAND |
  122. | TRENTFREE_SHIFT |
  123. | TRIPLE_MONTHLY_CDRS |
  124. | TRIPLE_MONTHLY_CDRS_ERR |
  125. | TSUBLEDGER_MISC |
  126. | TSUBOS_IS |
  127. | TSUBPAY_BB |
  128. | TSUBPAY_IN |
  129. | TSUBPAY_IS |
  130. | TSUB_ABF_SUM |
  131. | TVPN_TELRENT |
  132. | T_ADDON_FEATURE |
  133. | T_ADVCDTL |
  134. | T_ALLRFNDADJ |
  135. | T_ANLRENT |
  136. | T_BANKPYMT |
  137. | T_BANKRPT |
  138. | T_BBAND |
  139. | T_BBAND_BSR |
  140. | T_BBAND_ERROR |
  141. | T_BBAND_ERROR1 |
  142. | T_BBAND_FTTH |
  143. | T_BBDISC_GSPE |
  144. | T_BB_BSR |
  145. | T_BB_DISC |
  146. | T_BB_DTGR |
  147. | T_BB_PENDRFND |
  148. | T_BB_PROCESS_STAGE |
  149. | T_BB_RETURN |
  150. | T_BILLJN |
  151. | T_BILLJNRPT |
  152. | T_BLOGIN_LOG |
  153. | T_BROADBAND |
  154. | T_BROAD_CHRGDTL |
  155. | T_BROAD_WAIVE |
  156. | T_CABLE_FAULT |
  157. | T_CALLSUMRY |
  158. | T_CDMAMIGR |
  159. | T_CDMA_CABLEFAULT |
  160. | T_CHQALLOW |
  161. | T_COINDADRS |
  162. | T_COLLEGE |
  163. | T_CORPMES |
  164. | T_CRDBRFND |
  165. | T_DIAS |
  166. | T_DIASERROR |
  167. | T_DIAS_ORG |
  168. | T_DIDADRS |
  169. | T_DIDAPPLN |
  170. | T_DIDCHRG |
  171. | T_DIDLEVEL |
  172. | T_DIDLEVEL_DUP |
  173. | T_DIDPYMNT |
  174. | T_DIDTXN |
  175. | T_DID_FRANC |
  176. | T_DID_REVSHARE |
  177. | T_DID_SDREVSH |
  178. | T_DISCTEMPD |
  179. | T_DNETDATA |
  180. | T_DOT_EMP |
  181. | T_DPSTCANWLL |
  182. | T_DPSTRENTCAN |
  183. | T_DPSTRFNDADJ |
  184. | T_DPSTTRAN |
  185. | T_DPST_MASTER |
  186. | T_DSLAM_PORT |
  187. | T_DUPBILL_LOG |
  188. | T_E1R2_RELNOS |
  189. | T_EPBXAPPLN |
  190. | T_EPBX_TELRENT |
  191. | T_EPBX_WAIVE |
  192. | T_EXGWLL |
  193. | T_FTTHACSRY |
  194. | T_FTTHAPPLN |
  195. | T_FTTHVOICE |
  196. | T_FTTH_MONTHLY_CDRS |
  197. | T_FTTH_TOBILL |
  198. | T_INET |
  199. | T_INETERROR |
  200. | T_ISDNWAIVE |
  201. | T_ISDN_PRI_RENT_MST |
  202. | T_JUDGES |
  203. | T_LATEFEE |
  204. | T_LED_VPTGPT |
  205. | T_LEVELCHNG |
  206. | T_LINKEDNOS |
  207. | T_MISCCHRG_DEL |
  208. | T_MISCSERV |
  209. | T_MISCTEMP |
  210. | T_MRDET |
  211. | T_MRLOAD_SUMRY |
  212. | T_MSNOMRCMR |
  213. | T_MSN_MAST |
  214. | T_MSTUPDRU |
  215. | T_NOVATIUM |
  216. | T_NTCRFND |
  217. | T_NTCRFNDDTL |
  218. | T_NTC_FREESIM |
  219. | T_NTC_VENDOR |
  220. | T_NTC_WAIVE |
  221. | T_OLDBROAD_CONN |
  222. | T_OLD_MODEMDET |
  223. | T_OMRCHK |
  224. | T_OMRCMRCOR |
  225. | T_ONLINEPAYLOG |
  226. | T_OTH_CENTREX |
  227. | T_OTH_GROUP |
  228. | T_OTH_VPN |
  229. | T_OYTCONV |
  230. | T_PAYCONSTRAINT |
  231. | T_PENDRFND |
  232. | T_PHNG_TMP |
  233. | T_PLANACSRY |
  234. | T_PLANACSRYRENT_VPN |
  235. | T_PLANACSRYRENT_WLL |
  236. | T_PLANACSRY_VPN |
  237. | T_PLANACSRY_WLL |
  238. | T_PLAY_MTH_CIN |
  239. | T_PORTALMAIL_ID |
  240. | T_POST_RFND |
  241. | T_POST_RFNDDTL |
  242. | T_PRBT_CDRS |
  243. | T_PRMS_LOG |
  244. | T_REFADDRESS |
  245. | T_REFUND |
  246. | T_REFUND_HOA_REPORT |
  247. | T_REFUND_LOG |
  248. | T_RENTFREE_NOS |
  249. | T_REVENUE |
  250. | T_RING_PRNLST |
  251. | T_RURALCSC |
  252. | T_SCH_CAN |
  253. | T_SD_WAIVE |
  254. | T_SMS |
  255. | T_SPL_BROADBAND |
  256. | T_STD_LOG |
  257. | T_SUBCWD |
  258. | T_SUBOS |
  259. | T_SUBOS_BB |
  260. | T_SUBOS_IN |
  261. | T_SUBOS_TMP |
  262. | T_SUBPAY |
  263. | T_SUBSCRBRDPST_ADD |
  264. | T_SUBSCRBRDPST_TRANSFER |
  265. | T_TECHWROFF |
  266. | T_TEL_MARKET |
  267. | T_TOLLCALLCHRG |
  268. | T_TOLLFREEMST |
  269. | T_TRIPLE_TMISCCHRG |
  270. | T_TRIPPLE_OFFENT |
  271. | T_TRIPPLE_PLANDET |
  272. | T_TRIPPLE_PLANDET_WAIVE |
  273. | T_TRIPPLE_PLAY |
  274. | T_TRUNKTCKT |
  275. | T_TXNAPPLN |
  276. | T_UDAN_PROJECT |
  277. | T_UNADRSMR |
  278. | T_UTI |
  279. | T_UTIRPT |
  280. | T_VENDOR_MAST |
  281. | T_WLL_WRKEXG |
  282. | T_WOMOVE |
  283. | T_WOMOVE_FTTH |
  284. | T_WOMOVE_HIST |
  285. | T_WRKORDR |
  286. | WEB_TPAYMENT |
  287. | X_NOVA_MODEM |
  288. +--------------------------+
  289.  
  290. back-end DBMS: Oracle
  291. Database: BILLWLL
  292. [2 tables]
  293. +----------------+
  294. | MBILLDTL_WLL |
  295. | MBILLSUMRY_WLL |
  296. +----------------+
  297.  
  298. back-end DBMS: Oracle
  299. Database: CASHCTR
  300. [17 tables]
  301. +--------------------+
  302. | CTR_BATCHENTRY |
  303. | CTR_CENTRETERM |
  304. | CTR_COUNTERUSER |
  305. | CTR_DAILYLIST |
  306. | CTR_FRANDSA_COMM |
  307. | CTR_MOBPYMT |
  308. | CTR_MOBPYMT1 |
  309. | CTR_OTHERENTRY |
  310. | CTR_PAYSESSION |
  311. | CTR_PAYSESSIONDTLS |
  312. | CTR_PYMTDTLS |
  313. | CTR_RCPTCNTRL |
  314. | CTR_RMSPYMTDTLS |
  315. | CTR_SERVICES |
  316. | CTR_SESSCONTROL |
  317. | CTR_TRANSFER |
  318. | CTR_WRONGOTHER |
  319. +--------------------+
  320.  
  321. back-end DBMS: Oracle
  322. Database: CSMS
  323. [1 table]
  324. +---------+
  325. | X_TXNWO |
  326. +---------+
  327.  
  328. back-end DBMS: Oracle
  329. Database: DBMAINT
  330. [122 tables]
  331. +--------------------+
  332. | AREA |
  333. | CI_PAY_PLACE |
  334. | DISCOUNT_FIXPC |
  335. | DISCOUNT_LCC |
  336. | DISCOUNT_MST |
  337. | MGROUPSUMRY |
  338. | PCO_TAX_ORG |
  339. | SUB_PCO_COMM_ORG |
  340. | TAREACHNG |
  341. | TAREACHNGERR |
  342. | TDISC |
  343. | T_CALLSUMRY |
  344. | XCENTREX |
  345. | XEPBX_RENT |
  346. | X_ACSRY |
  347. | X_ACSRYCNTRL |
  348. | X_ACSTMNT |
  349. | X_AO_AREA |
  350. | X_ARDR_INST_AMT |
  351. | X_AREA |
  352. | X_AREAEXCHNG |
  353. | X_AREA_DB_LINK |
  354. | X_BANK |
  355. | X_BANKPYMT |
  356. | X_BBCDR_PLAN |
  357. | X_BB_CHRG |
  358. | X_BILLCNTRL1 |
  359. | X_BILLCNTRLI |
  360. | X_BLARENT |
  361. | X_BLARENT_OTHERS |
  362. | X_CANCODE |
  363. | X_CDMA_EXG |
  364. | X_CENTRE |
  365. | X_CENTRETERM |
  366. | X_CENTREX_MST |
  367. | X_CENTRE_DUPBILL |
  368. | X_CHARCODE |
  369. | X_CHQ_DSHNR |
  370. | X_CICHRG |
  371. | X_CTGRYCHNG |
  372. | X_DEPT |
  373. | X_DIAS |
  374. | X_DIDCAP |
  375. | X_DIDCONV |
  376. | X_DID_DMND |
  377. | X_DID_RDRENT |
  378. | X_DID_SDREVSH |
  379. | X_DOT_EMP |
  380. | X_DPSTRFND |
  381. | X_DSLAM |
  382. | X_DSLAM_PORT |
  383. | X_EXCHNGPIN |
  384. | X_EXCHNGUSER |
  385. | X_FNCTN |
  386. | X_FNCTNUSER |
  387. | X_FTTHACSRY |
  388. | X_GROUP |
  389. | X_GROUP_CENTREX |
  390. | X_INSTLTNCHRG |
  391. | X_INTCODE |
  392. | X_INTRSTRATE |
  393. | X_ISDN_DMND |
  394. | X_JRNL |
  395. | X_LCCCHRG |
  396. | X_LEVELUSER |
  397. | X_MENU |
  398. | X_METER |
  399. | X_MOBPART |
  400. | X_MOBPART1 |
  401. | X_MODULEUSER |
  402. | X_NONCSMSEXG |
  403. | X_PCOCMSN2 |
  404. | X_PINSTRT |
  405. | X_PLANACSRY |
  406. | X_PLANACSRY_CLOSED |
  407. | X_PLANACSRY_VPN |
  408. | X_PLANACSRY_WLL |
  409. | X_PLANMST |
  410. | X_PRNTR |
  411. | X_RECEIPTNO |
  412. | X_REFCHRG |
  413. | X_REFEXGLEVEL |
  414. | X_RENT |
  415. | X_RENT_OTHERS |
  416. | X_RENT_SUL |
  417. | X_SALESTAX |
  418. | X_SCRN |
  419. | X_SCRNUSER |
  420. | X_SDEDISCON |
  421. | X_SPARETEL |
  422. | X_SRVCTAX |
  423. | X_STDSTATUSCHNG |
  424. | X_SUBCTL |
  425. | X_SUBSCRBRCNTRL |
  426. | X_SURCHRG |
  427. | X_SYSPARAM |
  428. | X_SYSTMUSER |
  429. | X_TITLE |
  430. | X_TOLLCOMM |
  431. | X_TP_FRANC_MST |
  432. | X_TRANSPRIVLG |
  433. | X_TRANSPRVLG |
  434. | X_TRANSPRVLG_ARCHV |
  435. | X_TRIPPLE_CHRG_MST |
  436. | X_TRIPPLE_MST |
  437. | X_TRIPPLE_PLAY |
  438. | X_TRIPPLE_VOD |
  439. | X_TRMNL |
  440. | X_TRMNLUSER |
  441. | X_TXNWO |
  442. | X_USER |
  443. | X_USO_EXCHNG |
  444. | X_VENDOR_NTC |
  445. | X_VPNEXCHNG |
  446. | X_VPN_CHRG |
  447. | X_WLCNTRL |
  448. | X_WLL_PLANMST |
  449. | X_WOCHRG |
  450. | X_WOCNTRL |
  451. | X_WOPATH |
  452. | X_WO_STATUS |
  453. | X_WRKORDR |
  454. +--------------------+
  455.  
  456. back-end DBMS: Oracle
  457. Database: FRS
  458. [1 table]
  459. +----------+
  460. | X_EXCHNG |
  461. +----------+
  462.  
  463.  
  464. Database: TRANSFER
  465. [29 tables]
  466. +--------------------------+
  467. | BBOS_AREA |
  468. | BB_RECONP1 |
  469. | CABLE_REBATE |
  470. | CDMA_BILL_INVOICE_DETAIL |
  471. | CDMA_DEPOSITS |
  472. | CDMA_EVDO_DEPOSITS |
  473. | CDMA_EVDO_FACILITIES |
  474. | CDMA_EVDO_MASTER |
  475. | CDMA_FACILITIES |
  476. | CDMA_MASTER |
  477. | CDMA_MASTER_FINAL |
  478. | DATAONE_TEMP |
  479. | DEPOSIT_MAST |
  480. | INT_ACCOUNT_CODE |
  481. | INT_CONS_NO |
  482. | OLD_TDPST |
  483. | OSAREA_IM3 |
  484. | OSAREA_IM5 |
  485. | OSJUN09 |
  486. | PPP |
  487. | SL_TBROADBAND |
  488. | TBBAND_UNBILLED |
  489. | TBBDISC_GSPE_LOG |
  490. | TBB_UNBILLED |
  491. | TEL_REBATE |
  492. | TSUBOS_DUP |
  493. | T_DIAS_MONTHLY |
  494. | T_HEAVY |
  495. | T_HEAVY_MONTHLY |
  496. +--------------------------+
  497.  
  498. Database: TJBSNL
  499. [29 tables]
  500. +--------------------------------+
  501. | MAGAZINE_ARTICLE_EXPERT_MASTER |
  502. | MAGAZINE_AUTHOR |
  503. | MAGAZINE_CIRCLE |
  504. | MAGAZINE_COUNTER |
  505. | MAGAZINE_EJOURNAL |
  506. | MAGAZINE_EXPERT_TECHNOLOGY |
  507. | MAGAZINE_EXPERT_TECH_MAPPING |
  508. | MAGAZINE_FEEDBACK |
  509. | MAGAZINE_MASTER |
  510. | MAGAZINE_MONTH |
  511. | MAGAZINE_OFFICERS |
  512. | MAGAZINE_POSTARTICLE |
  513. | MAGAZINE_POSTARTICLE_MASTER |
  514. | MAGAZINE_REQUEST |
  515. | MAGAZINE_ROLE |
  516. | MAGAZINE_SECRET_QUE |
  517. | MAGAZINE_SSA |
  518. | MAGAZINE_TITLE |
  519. | MAGAZINE_USER |
  520. | MAGAZINE_USER_OLD |
  521. | MAGAZINE_USER_SUBSCRIPTION |
  522. | MAGAZINE_USER_SUBSCRIPTION_OLD |
  523. | MAGAZINE_YEAR |
  524. | MAG_AUTHOR_ARTICLESTATUS |
  525. | MAG_AUTHOR_SUGGESTED_TOPIC |
  526. | MAG_GUEST_SUBSCRIPTION |
  527. | MAG_GUEST_SUBSCRIPTIONFIN |
  528. | MAG_PAGE_MASTER |
  529. | MAG_SUBSCRIBED_MASTERFIN |
  530. +--------------------------------+
  531.  
  532. Database: TOAD
  533. [2 tables]
  534. +-----------------+
  535. | TOAD_PLAN_SQL |
  536. | TOAD_PLAN_TABLE |
  537. +-----------------+
  538.  
  539.  
  540. back-end DBMS: Oracle
  541. Database: UDAAN
  542. [1 table]
  543. +-----------------+
  544. | TOAD_PLAN_TABLE |
  545. +-----------------+
RAW Paste Data