OraFAQ Forum: SQL & PL/SQL » project

Home » SQL & PL/SQL » SQL & PL/SQL » project

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

project [message #554294]

Sat, 12 May 2012 02:39

alihero
Messages: 13
Registered: May 2012

Junior Member

i really did not understand the following case
In previous chapter, we have created procedures, functions, and packages to support the rental process. As application modifications are made in the future, we need to be able to identify all object dependencies to test our changes. Use the data dictionary and/or the dependency tree utility to complete a list of dependencies for all the more movies database objects.Do so in the format table
the dependency type should be listed as direct or indirect
Here is the table format

Object name dependent object dependency type

what i didn t understand is they did not specefied what table or procedure or function we should look for its dependency if all how we can know all the more movies database.
any help will be appreciated
thank you

[Updated on: Sat, 12 May 2012 02:54]

Report message to a moderator

Re: project [message #554298 is a reply to message #554294]

Sat, 12 May 2012 03:03

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Use the data dictionary and/or the dependency tree utility to complete a list of dependencies for all the more movies database objects

Query USER/ALL/DBA_DEPENDENCIES.

Regards
Michel

Report message to a moderator

Re: project [message #554321 is a reply to message #554298]

Sat, 12 May 2012 13:39

alihero
Messages: 13
Registered: May 2012

Junior Member

u meant
select * from user_dependencies;
select * from all_dependencies;
select * from dba_dependencies

this will extract all the dependencies in database in my computer. BUT I AM LOOKING JUST FOR THE MOVIE DATABASE
(I DID NOT CREATE THE DATABASE NAME FOR THE MOVIE)
PLEASE MORE HELP

Report message to a moderator

Re: project [message #554322 is a reply to message #554321]

Sat, 12 May 2012 13:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: project [message #554323 is a reply to message #554321]

Sat, 12 May 2012 13:43

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

BUT I AM LOOKING JUST FOR THE MOVIE DATABASE
(I DID NOT CREATE THE DATABASE NAME FOR THE MOVIE

What does this mean?
You are clear as mud.
And do NOT post in UPPER case, I will not help someone that yells at me.

Regards
Michel

Report message to a moderator

Re: project [message #554324 is a reply to message #554323]

Sat, 12 May 2012 13:47

alihero
Messages: 13
Registered: May 2012

Junior Member

Sorry, i did not mean to yell at you.
it was just miss touching the capskey sorry again

Report message to a moderator

Re: project [message #554326 is a reply to message #554324]

Sat, 12 May 2012 14:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

We don't know what you have.
We don't know what you do.
We don't know what you see.
We don't know what you want.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: project [message #554358 is a reply to message #554326]

Sun, 13 May 2012 21:56

alihero
Messages: 13
Registered: May 2012

Junior Member

i really did not understand the following case
In previous chapter, we have created procedures, functions, and packages to support the rental process. As application modifications are made in the future, we need to be able to identify all object dependencies to test our changes. Use the data dictionary and/or the dependency tree utility to complete a list of dependencies for all the more movies database objects.Do so in the format table
the dependency type should be listed as direct or indirect
Here is the table format

Object name dependent object dependency type

Report message to a moderator

Re: project [message #554359 is a reply to message #554358]

Sun, 13 May 2012 22:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

We don't know what you have.
We don't know what you do.
We don't know what you see.
We don't know what you want.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: project [message #554372 is a reply to message #554359]

Mon, 14 May 2012 00:21

alihero
Messages: 13
Registered: May 2012

Junior Member

I have everything you need to know about my case if not let me repeat my self
i want to extract direct and indirect dependencies from the mm_movie database on the following format:
Objectname dependentobject dependencytype
and the dependency type should be listed as direct or indirect
please help

Report message to a moderator

Re: project [message #554378 is a reply to message #554372]

Mon, 14 May 2012 01:05

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

BlackSwan wrote on Mon, 14 May 2012 05:07

We don't know what you have.
We don't know what you do.
We don't know what you see.
We don't know what you want.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: project [message #554382 is a reply to message #554372]

Mon, 14 May 2012 01:09

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Michel Cadot wrote on Sat, 12 May 2012 20:43

Quote:
BUT I AM LOOKING JUST FOR THE MOVIE DATABASE
(I DID NOT CREATE THE DATABASE NAME FOR THE MOVIE

What does this mean?
...

Report message to a moderator

Re: project [message #554384 is a reply to message #554372]

Mon, 14 May 2012 01:12

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

I'll try to help. You need to be clearer in your question. For example, at one point you say "THE MOVIE DATABASE" and at another you say "the mm_movie database". I'm guessing that one of these the name of the database, and the other the name of a table in the database. Is that right?
And "In previous chapter" refers to what book?

Report message to a moderator

Re: project [message #554385 is a reply to message #554384]

Mon, 14 May 2012 01:23

alihero
Messages: 13
Registered: May 2012

Junior Member

i am working on a case project from 10g develeper by joan casteel
i want to extract direct and indirect dependencies from the mm_movie database on the following format:
Objectname dependentobject dependencytype
and the dependency type should be listed as direct or indirect
Thank you John

Report message to a moderator

Re: project [message #554386 is a reply to message #554385]

Mon, 14 May 2012 01:24

alihero
Messages: 13
Registered: May 2012

Junior Member

Please dont worry about the previous posting. I am new here

Report message to a moderator

Re: project [message #554388 is a reply to message #554385]

Mon, 14 May 2012 01:43

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Michel Cadot wrote on Sat, 12 May 2012 10:03

Query USER/ALL/DBA_DEPENDENCIES.

Regards
Michel

Report message to a moderator

Re: project [message #554394 is a reply to message #554388]

Mon, 14 May 2012 02:03

alihero
Messages: 13
Registered: May 2012

Junior Member

MM_RENTALS_PKG STANDARD HARD
MM_RENTALS_PKG STANDARD HARD
STATUS_SP STANDARD HARD
SUB_CALC_SF STANDARD HARD
MOVIE_RETURN_SP STANDARD HARD
MOVIE_STOCK_INFO STANDARD HARD
SHIP_CALC3_SF STANDARD HARD
ORDER_INFO_PKG STANDARD HARD
PHONE_FMT_SP STANDARD HARD
STOCK_CK_SP STANDARD HARD
ORDER_TOTAL_SP2 STANDARD HARD
CONTACT_OT STANDARD HARD
BB_CONTACT STANDARD HARD
CONTACT_OT STANDARD HARD
BB_AUDIT_TRG STANDARD HARD
ORDER_INFO_PKG STANDARD HARD
RUN_NOCOPY_SP STANDARD HARD
TEST_NOCOPY_SP STANDARD HARD
PROMO_TEST_SP STANDARD HARD
BASK_CALC_SP STANDARD HARD
TAX_CALC2_SF STANDARD HARD
LOGIN2_SP STANDARD HARD
LOGIN_SP STANDARD HARD
DEPTREE_FILL STANDARD HARD
ORDER_TOTAL_SP STANDARD HARD
TOT_PURCH_SF STANDARD HARD
SHOP_QUERY_PKG STANDARD HARD
TAX_COST_SP STANDARD HARD
PROD_ADD_SP STANDARD HARD
SHOP_QUERY_PKG STANDARD HARD
MOVIE_RENT_SP STANDARD HARD
MEMBER_CK_SP STANDARD HARD
ORD_SHIP_SF STANDARD HARD
SHIP_COST_SP STANDARD HARD
STOCK_CK_SP DBMS_STANDARD HARD
DEPTREE_FILL DBMS_STANDARD HARD
IDEPTREE XML_SCHEMA_NAME_PRESENT HARD
DEPTREE XML_SCHEMA_NAME_PRESENT HARD
DEPTREE_FILL ALL_OBJECTS HARD
DEPTREE ALL_OBJECTS HARD
DEPTREE_FILL PUBLIC_DEPENDENCY HARD
STATUS_SP SYS_STUB_FOR_PURITY_ANALYSIS HARD
STOCK_CK_SP SYS_STUB_FOR_PURITY_ANALYSIS HARD
SUB_CALC_SF SYS_STUB_FOR_PURITY_ANALYSIS HARD
TAX_CALC2_SF SYS_STUB_FOR_PURITY_ANALYSIS HARD
SHIP_CALC3_SF SYS_STUB_FOR_PURITY_ANALYSIS HARD
MOVIE_RETURN_SP SYS_STUB_FOR_PURITY_ANALYSIS HARD
MOVIE_RENT_SP SYS_STUB_FOR_PURITY_ANALYSIS HARD
MOVIE_STOCK_INFO SYS_STUB_FOR_PURITY_ANALYSIS HARD
ORDER_TOTAL_SP2 SYS_STUB_FOR_PURITY_ANALYSIS HARD
ORDER_TOTAL_SP SYS_STUB_FOR_PURITY_ANALYSIS HARD
TC_TEST_SP1 SYS_STUB_FOR_PURITY_ANALYSIS HARD
RUN_NOCOPY_SP SYS_STUB_FOR_PURITY_ANALYSIS HARD
TC_TEST_SP2 SYS_STUB_FOR_PURITY_ANALYSIS HARD
PROMO_TEST_SP SYS_STUB_FOR_PURITY_ANALYSIS HARD
BASK_CALC_SP SYS_STUB_FOR_PURITY_ANALYSIS HARD
MEMBER_CK_SP SYS_STUB_FOR_PURITY_ANALYSIS HARD
DEPTREE_FILL SYS_STUB_FOR_PURITY_ANALYSIS HARD
TOT_PURCH_SF SYS_STUB_FOR_PURITY_ANALYSIS HARD
PROD_ADD_SP SYS_STUB_FOR_PURITY_ANALYSIS HARD
ORD_SHIP_SF SYS_STUB_FOR_PURITY_ANALYSIS HARD
MM_RENTALS_PKG DBMS_OUTPUT HARD
MOVIE_RETURN_SP DBMS_OUTPUT HARD
MOVIE_RENT_SP DBMS_OUTPUT HARD
STOCK_CK_SP DBMS_OUTPUT HARD
ORDER_INFO_PKG DBMS_OUTPUT HARD
RUN_NOCOPY_SP DBMS_OUTPUT HARD
DEPTREE_FILL DEPTREE_SEQ HARD
DEPTREE ALL_OBJECTS HARD
DEPTREE_FILL ALL_OBJECTS HARD
BB_CONTACT CONTACT_OT HARD
CONTACT_OT CONTACT_OT HARD
DEPTREE_FILL PUBLIC_DEPENDENCY HARD
DEPTREE_FILL DEPTREE_TEMPTAB HARD
DEPTREE DEPTREE_TEMPTAB HARD
IDEPTREE DEPTREE HARD
ORDER_TOTAL_SP SHIP_COST_SP HARD
MM_RENTALS_PKG DBMS_OUTPUT HARD
MOVIE_RETURN_SP DBMS_OUTPUT HARD
MOVIE_RENT_SP DBMS_OUTPUT HARD
STOCK_CK_SP DBMS_OUTPUT HARD
ORDER_INFO_PKG DBMS_OUTPUT HARD
RUN_NOCOPY_SP DBMS_OUTPUT HARD
LOGIN_SP MEMFMT1_SF HARD
LOGIN2_SP MEMFMT1_SF HARD
LOGIN_SP MEMFMT1_SF HARD
LOGIN2_SP MEMFMT1_SF HARD
RUN_NOCOPY_SP TEST_NOCOPY_SP HARD
BASK_CALC_SP SHIP_CALC3_SF HARD
BASK_CALC_SP TAX_CALC2_SF HARD
BASK_CALC_SP SUB_CALC_SF HARD
TC_TEST_SP1 TC_TEST_SP2 HARD
ORDER_INFO_PKG ORDER_INFO_PKG HARD
MM_RENTALS_PKG MM_MOVIE HARD
MOVIE_RETURN_SP MM_MOVIE HARD
MOVIE_RENT_SP MM_MOVIE HARD
MOVIE_STOCK_INFO MM_MOVIE HARD
MM_RENTALS_PKG MM_RENTAL HARD
MOVIE_RETURN_SP MM_RENTAL HARD
MOVIE_RENT_SP MM_RENTAL HARD
MM_RENTALS_PKG MM_RENTAL_SEQ HARD
MOVIE_RENT_SP MM_RENTAL_SEQ HARD
MM_RENTALS_PKG MM_RENTALS_PKG HARD
STOCK_CK_SP BB_PRODUCT HARD
BB_AUDIT_TRG BB_PRODUCT HARD
LOGIN_SP BB_SHOPPER HARD
LOGIN2_SP BB_SHOPPER HARD
MEMBER_CK_SP BB_SHOPPER HARD
ORDER_INFO_PKG BB_BASKET HARD
PROMO_TEST_SP BB_BASKET HARD
STATUS_SP BB_BASKET HARD
BASK_CALC_SP BB_BASKET HARD
TAX_CALC2_SF BB_BASKET HARD
BB_SHIP_VU BB_BASKET HARD
SUB_CALC_SF BB_BASKETITEM HARD
SHIP_CALC3_SF BB_BASKETITEM HARD
ORDER_TOTAL_SP2 BB_BASKETITEM HARD
ORDER_TOTAL_SP BB_BASKETITEM HARD
BB_BASKETITEM_VU BB_BASKETITEM HARD
TAX_CALC2_SF BB_TAX HARD
STATUS_SP BB_BASKETSTATUS HARD
BB_SHIP_VU BB_BASKETSTATUS HARD
PROMO_TEST_SP BB_PROMOLIST HARD
TC_TEST_SP1 BB_TEST1 HARD
TC_TEST_SP2 BB_TEST1 HARD
BB_AUDIT_TRG BB_PRODCHG_AUDIT HARD
PROD_ADD_SP BB_PRODID_SEQ HARD
SHOP_QUERY_PKG SHOP_QUERY_PKG HARD

Report message to a moderator

Re: project [message #554395 is a reply to message #554394]

Mon, 14 May 2012 02:05

alihero
Messages: 13
Registered: May 2012

Junior Member

what do you think Mchel? I select name,referenced_name, dependency_type from user_dependencies;

Report message to a moderator

Re: project [message #554398 is a reply to message #554372]

Mon, 14 May 2012 03:04

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

Then post what you did using copy/paste and code tags, like this:

orcl> select name,referenced_name,dependency_type from dba_dependencies where owner='HR';


NAME                           REFERENCED_NAME                DEPE
------------------------------ ------------------------------ ----
UPDATE_JOB_HISTORY             STANDARD                       HARD
ADD_JOB_HISTORY                STANDARD                       HARD
SECURE_DML                     STANDARD                       HARD
SECURE_DML                     DBMS_STANDARD                  HARD
ADD_JOB_HISTORY                SYS_STUB_FOR_PURITY_ANALYSIS   HARD
SECURE_DML                     SYS_STUB_FOR_PURITY_ANALYSIS   HARD
UPDATE_JOB_HISTORY             ADD_JOB_HISTORY                HARD
EMP_DETAILS_VIEW               COUNTRIES                      HARD
EMP_DETAILS_VIEW               DEPARTMENTS                    HARD
UPDATE_JOB_HISTORY             EMPLOYEES                      HARD
EMP_DETAILS_VIEW               EMPLOYEES                      HARD
SECURE_EMPLOYEES               EMPLOYEES                      HARD
EMP_DETAILS_VIEW               JOBS                           HARD
ADD_JOB_HISTORY                JOB_HISTORY                    HARD
EMP_DETAILS_VIEW               LOCATIONS                      HARD
EMP_DETAILS_VIEW               REGIONS                        HARD
SECURE_EMPLOYEES               SECURE_DML                     HARD

17 rows selected.

orcl>

You will want to improve the output further: formatting and naming the columns, and perhaps grouping them into object types or using an appropriate order, but I would think you have answered the question. Say "thank you" to Michel.

Report message to a moderator

Re: project [message #554408 is a reply to message #554398]

Mon, 14 May 2012 04:23

alihero
Messages: 13
Registered: May 2012

Junior Member

Thank you Michel and John.
hard means direct dependency? id so how can we get the indirect
i know that dba_dependencies extract just thr direct dependencies

Report message to a moderator

Re: project [message #554411 is a reply to message #554408]

Mon, 14 May 2012 04:34

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Have a look at the following scripts:
http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1237
http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1236

Regards
Michel

[Edit: add url tags]

[Updated on: Tue, 15 May 2012 00:50]

Report message to a moderator

Re: project [message #554486 is a reply to message #554411]

Mon, 14 May 2012 17:25

alihero
Messages: 13
Registered: May 2012

Junior Member

So i guess the only way to get the indirect dependencies is to use the deptree right

Report message to a moderator

Re: project [message #554507 is a reply to message #554486]

Tue, 15 May 2012 00:49

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The only way is to use SQL; I don't know what "deptree" means.

Regards
Michel

Report message to a moderator

Re: project [message #554524 is a reply to message #554507]

Tue, 15 May 2012 03:06

alihero
Messages: 13
Registered: May 2012

Junior Member

deptree is a utility that built in oracle that u ahev to run in orther to use it
for example
execute ('table',' scott','emp');
select * from deptree
this will extract all the dependecies with the EMP table

Report message to a moderator

Re: project [message #554528 is a reply to message #554524]

Tue, 15 May 2012 03:32

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do I use this in the scripts I pointed you too?

Regards
Michel

Report message to a moderator

Re: project [message #554589 is a reply to message #554528]

Tue, 15 May 2012 16:07

alihero
Messages: 13
Registered: May 2012

Junior Member

No you did not
so what do you think i should do to get all the direct and indirect depedencies
i guess i should create a table to hold the data extracted by the deptree

Report message to a moderator

Re: project [message #554603 is a reply to message #554589]

Tue, 15 May 2012 23:23

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

No you did not

So, your tool is not required.

Quote:

so what do you think i should do to get all the direct and indirect depedencies

Use one of the scripts I posted?

Regards
Michel

Report message to a moderator

Previous Topic:	to get output in correct format
Next Topic:	Adding an audit column to track delete and update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 14:28:31 CDT 2024