Re: Data extraction over dblink
- From: "Paul Drake" <bdbafh@xxxxxxxxx>
- To: dubey.sandeep@xxxxxxxxx
- Date: Thu, 13 Apr 2006 17:08:53 -0400
On 4/13/06, Sandeep Dubey <dubey.sandeep@xxxxxxxxx> 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
> --
> //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
Other related posts:
