Home » Infrastructure » Unix » database view
database view [message #161935] Tue, 07 March 2006 23:33 Go to next message
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.
Re: database view [message #161942 is a reply to message #161935] Tue, 07 March 2006 23:56 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Can you make your question more clear?

Re: database view [message #161945 is a reply to message #161935] Wed, 08 March 2006 00:05 Go to previous messageGo to next message
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.
Re: database view [message #161947 is a reply to message #161945] Wed, 08 March 2006 00:08 Go to previous messageGo to next message
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.
Re: database view [message #161960 is a reply to message #161947] Wed, 08 March 2006 00:53 Go to previous messageGo to next message
raom
Messages: 22
Registered: January 2006
Location: india
Junior Member
Thanks alot that clarifies my doubt.
if possible can u suggest me any link related to oracle views.
Re: database view [message #161970 is a reply to message #161960] Wed, 08 March 2006 01:14 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


The best place is to look into Oracle manuals.
Previous Topic: To acess Oracle 7.3 using HP-UX 10.20
Next Topic: why unix is preferred
Goto Forum:
  


Current Time: Thu Mar 28 20:19:02 CDT 2024