Can Oezdemir wrote:
>Hello,
>
>I'd like to ask which backup method you would prefer, if I just wanted to
>backup an entire oracle 9i database, in order to restore it afterwards, on a
>new Windows XP installation.
>My suggestion would be to use RMAN and do a backup of all necessary
>tablespaces (...of course, also the system tablespace, otherwise the table
>definitions would be gone...).
>Is it more appropriate to use the Export/Import utiliy in this case? Because
>this utility is saving table definitions, either....
>
>Would be nice, if someone would give me a hint which method is more prudent
>one for my purpose.
>
>Thanks in advance,
> Can
>
>-------------------------------------
>Can...
>http://pdf.natune.net
>-------------------------------------
>
>
If the backup is one time only and strictly for purposes of a move with
no need to recover transactions either
use transportable tablespaces or EXPort.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Oct 03 2003 - 15:00:11 CDT
