Re: Is export and import enought?

From: <kal121_at_my-deja.com>
Date: Tue, 26 Sep 2000 21:29:11 GMT
Message-ID: <8qr4es$g9d$1@nnrp1.deja.com>

No, imp/exp only does a logical backup. Your datafiles, control files, init.ora files, etc will not be re-created with an imp/exp. Imp/exp is only for the objects in the database, not the entire database itself.

You will want to take a cold backup of the database, re-install Oracle, then copy your backed-up files over. Please refer to the Oracle docs on how to do a cold backup and restore.

In article <39D10B5E.1729C77D_at_nacse.org>, leanne <leanne_at_nacse.org> wrote:
> Hi,
>
> Currently we have oracle 8.0.5 running on Solaris 6 and we are going
to
> upgrade the OS to Solaris 8. For the oracle portion, is it enough to
do
> an export of the database and then reinstall oracle on the new
operating
> system, after that import the database back???
>
> Thanks in advance
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 26 2000 - 16:29:11 CDT