Re: Reg Partition Exchange


DA Morgan wrote:

pankaj_wolfhunter@xxxxxxxxxxx wrote:
DA Morgan wrote:
pankaj_wolfhunter@xxxxxxxxxxx wrote:
Greetings,
We have a requirement where we want to transfer some
millions of data in 15-16 tables from one schema to same structure
tables in another. Both source and destination tables are partitioned.
Right now we are going for partition exchange for both schemas. But as
we know partition-exchange empties the source table from where it is
tranferring the data.
For that we are taking help of temporary tables in between but it is
really causing major performance problems. The whole process goes
beyond 3-4 hrs.
Just want to know is there any way in partition-exchange where we can
directly transfer the data between two tables without loosing data Or
any other way some one can suggest?

We are using Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

Any help would be greatly appreciated.

TIA
Two schemas in a single database?
Two different databases?
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Two schemas in a single database.

Why not CTAS (CREATE TABLE AS) with the APPEND hint?
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Thanks Morgan and Sorry for late reply.
Your idea of APPEND hint really helped in reducing time.
Actually implementation for the same took some time and was not able to
reply to you soon.
Thanks again

.

Relevant Pages

  • Re: Reg Partition Exchange
    ... Right now we are going for partition exchange for both schemas. ... Just want to know is there any way in partition-exchange where we can ... Two schemas in a single database? ... Daniel A. Morgan ...
    (comp.databases.oracle.misc)
  • Re: Reg Partition Exchange
    ... Right now we are going for partition exchange for both schemas. ... Just want to know is there any way in partition-exchange where we can ... Two schemas in a single database? ... Daniel A. Morgan ...
    (comp.databases.oracle.misc)
  • Re: Reg Partition Exchange
    ... Right now we are going for partition exchange for both schemas. ... Two schemas in a single database? ... Daniel A. Morgan ... Actually people are using old days data from the partition tables. ...
    (comp.databases.oracle.misc)
  • Re: Reg Partition Exchange
    ... Right now we are going for partition exchange for both schemas. ... Two schemas in a single database? ... Daniel A. Morgan ... Actually people are using old days data from the partition tables. ...
    (comp.databases.oracle.misc)
  • Re: Reg Partition Exchange
    ... Right now we are going for partition exchange for both schemas. ... Just want to know is there any way in partition-exchange where we can ... Two schemas in a single database? ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.misc)