RE: RMAN - Some basic Qs.

2003-04-01 Thread mail2gkatteri
Answer 1: RMAN keeps track of increasing SCNs of any changing datablock within the datafile being backedup. Hence not much redo. Answers to other questions have been posted by others. HTH GovindanK |XXX| |You should treat

RE: Upgrade from 8.1.7.4 to 9.2.0.1.0

2003-03-31 Thread mail2gkatteri
Oracle 7 to Oracle 8 involves changes to the rowid itself. Hence the tablespaces are part of migration. For higher releases , the changes take place to the system , rbs tablespaces (if i recall correctly) and the user tablespaces are not touched by migration. HTH GovindanK = DENNIS

Oracle Grid,Streams

2003-03-28 Thread mail2gkatteri
Hi List What are the Pros and Cons of the above?. Has anyone in the industry implemented the above successfully?. Are there any pitfalls / restrictions to using the above technology? TIA GovindanK -- * *YOU SHOULD TREAT

RE: ref cursor

2003-03-11 Thread mail2gkatteri
SELECT null,null -- Repeat as many columns as in the original cursor FROM dual WHERE 1=2 It works. HTH GovindanK Basavaraja, Ravindra [EMAIL PROTECTED] wrote: Hi, I have a procedure that has an ref cursor as an OUT parameter.If for some reason If I have to return NULL values in the ref