OraFAQ Forum: Server Administration » Invalidation of dependencies

Home » RDBMS Server » Server Administration » Invalidation of dependencies (oracle version 10g Windows XP)

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

Invalidation of dependencies [message #519193]

Wed, 10 August 2011 05:10

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

In a document from the oracle website.
"If a single-table view selects only a subset of columns in a table, only those columns are involved in the dependency".

But when i experimented, it is not true. (Plz refer the attached file).

Regards:
Muktha

Attachment: sample1.JPG
(Size: 25.36KB, Downloaded 919 times)

Report message to a moderator

Re: Invalidation of dependencies [message #519194 is a reply to message #519193]

Wed, 10 August 2011 05:13

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

1) Which document - post a link so we can see for ourselves.
2) Why on earth are you posting images of a sqlplus session? Copy and paste the text in code tags as you have been told on multiple occasions.

EIDT: typo

[Updated on: Wed, 10 August 2011 05:14]

Report message to a moderator

Re: Invalidation of dependencies [message #519308 is a reply to message #519193]

Thu, 11 August 2011 00:35

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Which version of Oracle you are using please specify,
I have test the same for ORACLE 11g R2 but the status is still VALID in my case.

Kindly describe, the table from which you created your view using

Describe table_name

And please post all your all test code right from the very first step using "code tag"

Regards
Deepak

Report message to a moderator

Re: Invalidation of dependencies [message #519318 is a reply to message #519308]

Thu, 11 August 2011 01:24

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is why we asked OP to post a link to what he read.
My opinion is that he read a 11.2 document and test in 10.2 database.

Regards
Michel

Report message to a moderator

Re: Invalidation of dependencies [message #519330 is a reply to message #519318]

Thu, 11 August 2011 02:13

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Yup!, Thanks for the update Sir. I was also on the same page, that there is some mis-understanding.

Regards
Deepak

[Updated on: Thu, 11 August 2011 02:13]

Report message to a moderator

Previous Topic:	Dbms_Metadata issue
Next Topic:	Error during upgrade

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 02:39:17 CST 2025