Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by GaryMiles
-
Producing a frequency distribution from Oracle 8i numeric data
You can do this in one query by using something like select sum(decode(value_field,GREATEST(LEAST(value_field,20),0),'1','0')) "0 - 20", sum(decode(value_field,GREATEST(LEAST(value_field,40),21),'1','0')) "21 - 40"...- GaryMiles
- Post #2
- Forum: Oracle: All versions
-
Point In Time Recovery
Yes, you need the system tablespace datafiles. As you suggest in your message you restore ALL datafiles and enough archived redo logs but not ctrl & online redo. This is to ensure that all data is recovered to the same point (it would be no good if the system tablespace was in advance of the...- GaryMiles
- Post #2
- Forum: Oracle: All versions
