Home » SQL & PL/SQL » SQL & PL/SQL » what are all the steps to take snapshot in oracle 9i ?
what are all the steps to take snapshot in oracle 9i ? [message #263303] Wed, 29 August 2007 11:24 Go to next message
prakash415
Messages: 4
Registered: June 2007
Location: chennai
Junior Member

Dear all,
I am a new junior dba to this community, I want to know about snapshot in oracle 9i. And also how can we increase the performance of the database using snapshot.. what are all the steps to take snapshot. please give me the correct procedure.....
Re: what are all the steps to take snapshot in oracle 9i ? [message #263310 is a reply to message #263303] Wed, 29 August 2007 12:10 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Search for "Materialized View"

By
Vamsi
Re: what are all the steps to take snapshot in oracle 9i ? [message #263326 is a reply to message #263303] Wed, 29 August 2007 13:36 Go to previous message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10733/raroverv.htm
Previous Topic: how can i count the columns in a table?
Next Topic: Grouping
Goto Forum:
  


Current Time: Sun Dec 04 00:36:31 CST 2016

Total time taken to generate the page: 0.09945 seconds