ITPub博客

Analytic Functions in Oracle (http://www.akadia.com/services/ora_analytic_functions.html#Example:%20Calculate%20a%20running%20Total)[@more@]Analytic Functions in Oracle 8i and 9iContents Overview and Introduction How Analytic Functions Work The Syntax Calculate a running Total Top-N Queries Example 1 Example 2 Windows Range Windows Compute average salary for defined range Row Windows Accessing Rows Around Your Current Row LAG LEAD

Recover a 9i database from RMAN backup[@more@]QUESTION=========We suffered a disk failure last week and have to re-install a new solaris 10 on it. Unfortunately we do not have 9i installation disks any more. The failed database was a 9.2.0.8 database. We have full database backup in RMAN and planned to install 10gR2 to the new server. But we have no idea how to use the 9i backup to recover the database to10gR2.RESEARCH==========They are using a recovery catalogThey are backing up to tapeANSWER==