OraFAQ Forum: Unix » database view

Home » Infrastructure » Unix » database view

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

database view [message #161935]

Tue, 07 March 2006 23:33

raom
Messages: 22
Registered: January 2006
Location: india

Junior Member

Hi
could any body clarify this issue.
i am extending table database size by adding dbf files where some other database has a view of this table then is it necessary to extend the view also.
please advice.

Report message to a moderator

Re: database view [message #161942 is a reply to message #161935]

Tue, 07 March 2006 23:56

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Can you make your question more clear?

Report message to a moderator

Re: database view [message #161945 is a reply to message #161935]

Wed, 08 March 2006 00:05

raom
Messages: 22
Registered: January 2006
Location: india

Junior Member

well
i have a table tab1 in database SDP.and a view of tab1 in other database SDP2.
now i am extending table size by adding some dbf files in SDP.
my question is
will the SDP2 database also needs extension as per the new size of tab1 on SDP.

Report message to a moderator

Re: database view [message #161947 is a reply to message #161945]

Wed, 08 March 2006 00:08

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Well! No you don't need because a view is just a SQL query stored inside Oracle that is referencing to the original table.

More comments are welcome.

Report message to a moderator