From: fvanbortel@netscape.net   
      
   Mahesh Hardikar wrote:   
      
   > Hello ,   
   >   
   > I am testing cold backup restore.   
   >   
   > Source Details :   
   >   
   > OS : Red Hat AS 2.1 64Bit   
   > Database : Oracle9i Enterprise Edition Release 9.2.0.2.0 64 Bit -   
   > Production   
   >   
   > Destination :   
   >   
   > OS : Red Hat AS 2.1 32 Bit   
   > Database  : Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production   
   >   
   > Now in this scene , is it possible to restore datafiles from source to   
   > destination ? here source is 64 Bit Oracle & Destn is 32 Bit.   
   >   
   > Client is asking me if in this scene , it will be possible to have   
   > Destination hardware to be used for configuring Standby Database.   
   >   
   > For test , I restored datafiles from source to destn. Recreated   
   > controlfile & tried opening. Database got opened. But when I try to   
   > alter tablespace TEMP to add file, it gives error :   
   >   
   > ORA-00604 : error occured at recursive SQL Level 1   
   > ORA-06553 : PLS-801 internal error [56319]   
   >   
   > I get same error if I try to create a test tablespace although   
   > resizing a datafile goes thru.   
   >   
   > Any pointers on this are highly appreciated ...   
   >   
   > Thanks & Regards,   
   > Mahesh Hardikar   
      
   What makes you think you can use "64-bit files"   
   on a 32-bit OS?   
   Something like restoring 9i in a 8i env...   
   --   
   Regards, Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)