different databases
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: different databases

  1. #1
    Join Date
    May 2002
    Posts
    232
    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


    kavitha

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    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.
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    May 2002
    Posts
    232
    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
    kavitha

  4. #4
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    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?
    David Knight
    OCP DBA 8i, 9i, 10g

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width