different databases

[kavithared]

HELOO,We are modifying old database,so modification we need to migrate old dbdata into new dbdata.
here i am giving clear details.
I have 2 instances A and B.
A**** contains olddata
B**** modification of old Db i.e A.
It contains old table structure as well as some new columns.
EX---
OLD DATABASE "A"
Tablename ---- abc
Dbname--------A
columns---- a,bandc.
abc table contains 1lack Records.


NEW DATABASE "B"
Tablename ---- XYZ
Dbname--------B
columns---- X,Y,Z,P,Q,R AND S.

As compared to these 2 tables----
a,b,c columns datatypes = x,y andz
Now I need to export data from abc into x,y and z

Note-- here 2 different databases and different tablenames and column names different.
And also some new columns has to be added .
Any one can advise best method and if possible give me examples.
thanks
kavitha

[dknight]

Do you have values for P, Q, R...?

If not, you could create a table XYZ like this (syntax is not tested, but you get the idea).

create table xyz as (
select a "x",
b "y",
c "z")

Then you can add the additional columns.

If the columns P, Q, R... have values, it is important to know how these columns are related to X, Y, Z.

Good luck.

[kavithared]

Hiii,I am adding new columns like p,q,r,s.
But my Old db server is remote not at my location.
So i need to export the a,b,c columns data into x,y,z and p,q,r,s are new columns.
thanks
kavitha

[dknight]

If you have the space for the old table and the new table, then what i wrote above should work. You just need to import the old table first.

Which version of Oracle do you use?