Re: Import and Archive Logs

Import issues normal inserts. So, they are logged. The only option you have is switch the complete database to noarchivelog. You probably don't want that, if there are other applications in that database.

Hth,

Sybrand Bakker, Oracle DBA

<alan_at_prsc.qld.gov.au> wrote in message news:7onso2$bdl$1_at_nnrp1.deja.com...
> Does import write to Archive Logs? If so is there a way to stop it?
>
> We have a "off the shelf" package that uses the one database for both
> Production and Training. Production and Training use different schemas.
>
> From time to time I am required to copy the Production schema to
> Training. This runs for ages and appears to write huge amounts of data
> to the archive logs.
>
> Is there a way to turn archive off during import or for a particular
> schema?
>
> I use the following syntax for the export/import:
>
> exp xxxprod/xxxx owner=xxxprod file=.... direct=y
> sqlplus < (drop all tables)
> imp xxxtrain/xxxx file=.... fromuser=xxxprod touser=xxxtrain ignore=y
>
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>
Received on Mon Aug 09 1999 - 23:56:41 CDT