How to find a table reference on which table.
638976Apr 6 2009 — edited Apr 6 2009HI All,
I am using oracle database version 10.2. For my project requirement i have created some procedures and then automate the process purpose i used dbms scheduler.
i have created job after that i have scheduled the job particular time every day. it will run once a day .
I wanted to know the code what i have mention when i was creating job ?.
Suppose if I create any that table name stored in ALL_OBJECTS. if we create procedure it will store in user_sources. in that table we can find the code of the procedure. like that i wanted to know scheduler job/code where it will store and where can we find the code ?
2. I have created 100 tables..... i have 5 master table. These are independent. These tables does not independent any table.
Remaining 95 tables are dependent on 5 master tables. ex :- 10 tables are dependent 1 master table and 20 tables are dependent on 2 master tables like that.
How do I know which table is dependent on which master table.
Suppose if I select master table how do i know based on this table dependent tables.
Suppose I have party table. This is the master table. party_id is the primary key. This table party_id referenced on agent, broker, claimant like that.
In agent table agent_id is the primary key but referencing on party table party_id. Like that broker, climant also.
Can u please give the suggestion how I can find which table dependent/reference on which master table.
Regards,
Venkat