SQL to list tables for a DB Process

To list the tables that are included in a Database Process (DB Process) you can use the following SQL:

SELECT DISTINCT m.tbl_name as "Table Name"
FROM ci_md_mo_tbl m, ci_db_instr d
WHERE m.maint_obj_cd = d.maint_obj_cd
AND d.DB_PROC_CD = 'CI_COCNT'
order by 1;

The above SQL actually lists all the administration tables.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Anthony Shorten
Hi, I am Anthony Shorten, I am the Principal Product Manager for the Oracle Utilities Application Framework. I have been working for over 20+ years in the IT Business and am the author of many a technical whitepaper, manual and training material. I am one of the product managers working on strategy and designs for the next generation of the technology used for the Utilities and Tax markets. This blog is provided to announce new features, document tips and techniques and also outline features of the Oracle Utilities Application Framework based products. These products include Oracle Utilities Customer Care and Billing, Oracle Utilities Meter Data Management, Oracle Utilities Mobile Workforce Management and Oracle Enterprise Taxation and Policy Management. I am the product manager for the Management Pack for these products.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
9
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today