Home » Other » Training & Certification » View & Materialized View & Database
icon5.gif  View & Materialized View & Database [message #255859] Thu, 02 August 2007 03:02 Go to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
Can anyone tel me the exact difference between View & Materialized View & Database.

As per my knowledge,

View has a virtual storage. Are used for security purpose,
like to view only the data from table to which users have permission to access.
Can we use Views over Remote databases?

Materialized View gets actually stored in the database.
These are generally used for Remote databases.
Does it's refresh action is advantageous for their use over view.

Database is a huge collection or storage of data.

When to use Views & when to use MV?

Thanks in advance,
Regards,
Prachi
Re: View & Materialized View & Database [message #255863 is a reply to message #255859] Thu, 02 August 2007 03:10 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Just like Michel once said, "what is the difference between car and a boat"? It would take too much time and space for someone to explain it. That's why Documentation exists; read it, learn every term you are interested in and then you'll be able to tell the difference by yourself.
Re: View & Materialized View & Database [message #255866 is a reply to message #255863] Thu, 02 August 2007 03:26 Go to previous messageGo to next message
prachi.mgorwadkar
Messages: 75
Registered: May 2007
Location: Pune
Member
Thanks for the reply.

I will do that.

Prachi
Re: View & Materialized View & Database [message #255983 is a reply to message #255866] Thu, 02 August 2007 11:06 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
"what is the difference between car and a boat"?


Car has 4 TIRES Boat got none Wink Razz
Re: View & Materialized View & Database [message #256010 is a reply to message #255983] Thu, 02 August 2007 14:02 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In my country, boats do have tyres. How many? It depends on boat size.

./fa/2813/0/
Re: View & Materialized View & Database [message #256011 is a reply to message #256010] Thu, 02 August 2007 14:09 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Laughing
Re: View & Materialized View & Database [message #256014 is a reply to message #255983] Thu, 02 August 2007 14:17 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
DreamzZ wrote on Thu, 02 August 2007 18:06
Quote:
"what is the difference between car and a boat"?


Car has 4 TIRES Boat got none Wink Razz

So, basically you say "Take the tires of your car and you have a boat"
Re: View & Materialized View & Database [message #256018 is a reply to message #256010] Thu, 02 August 2007 14:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Laughing
Re: View & Materialized View & Database [message #256019 is a reply to message #256014] Thu, 02 August 2007 14:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Laughing Laughing
Re: View & Materialized View & Database [message #256023 is a reply to message #256019] Thu, 02 August 2007 14:48 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Embarassed
Previous Topic: OCA?
Next Topic: 1Z0-042 Exam
Goto Forum:
  


Current Time: Thu Dec 08 14:20:48 CST 2016

Total time taken to generate the page: 0.11770 seconds