Re: Logging

Jon Hunt <thisisnotmyaddress_at_nospam.invalid> wrote in message news:<Xns9525788F5C09Csoftworks_at_158.152.254.254>...
> Pardon a newbies ignorance.
>
> I have a Oracle 8 server with a database that was setup in non-archive
> mode. As I want to be able to use import and export tools, I have been
> told I need to switch to archive mode.
>
> Can this be done without destroying data?

You've been told wrong. Archive mode is to be able to recover transactions in the event of a database crash. Most production systems probably should be in archivelog mode. There are performance issues, especially in large imports, so some development machines and machines that can reload data when lost are noarchivelog.

What is it exactly you want to do?

jg

--
@home.com is bogus.
"Do not stand under door when operating." - Warning sign next to
rollup door.