Shuting off redo's
From: Vissu <vissuyk_at_yahoo.com>
Date: 9 Jul 2002 20:41:24 -0700
Message-ID: <2bedd6a7.0207091941.4303820e_at_posting.google.com>
Date: 9 Jul 2002 20:41:24 -0700
Message-ID: <2bedd6a7.0207091941.4303820e_at_posting.google.com>
Hi All,
We have a very large table that we would like to import from old instance to new instance. Since the import is taking a long time, I'd like to shut off the archiving and redo's as below :
ALTER DATABASE NOARCHIVELOG; ALTER SYSTEM ARCHIVE LOG STOP; Is it OK if I shut these off ?. What is the worst thing that can happen ? We have the export dump file and are willing to reimport if we run into problems.
Any suggestions are appreciated.
Vissu Received on Wed Jul 10 2002 - 05:41:24 CEST