Re: Data extraction over dblink

On 4/13/06, Sandeep Dubey <dubey.sandeep_at_gmail.com> wrote:
>
> David,
>
> Transportable tablespace is on my second test list. I need to pull
> data from 6 tables and insert into 3 tables. So I will need staging
> tables on both source and target databases. My concern is the unneeded
> logging that will occur on both the source and target database while
> inserting data in the staging tables. We are using dataguard with
> forced logging, so we can not use nologging feature while inserting in
> the staging tables.
>
> Thanks
>
> Sandeep
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

Sandeep,

IIRC, the forced logging attribute can be set at both the database level and at the tablespace level.
You could in theory set force logging = false at the database level and set it to be true at the tablespace level. Test in your environment, your mileage may vary, etc.

Paul

--
http://www.freelists.org/webpage/oracle-l