help urgent!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: help urgent!!!

  1. #1
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Hi, all
    I have two db, A and B. A and B has the same tables and A has the data in the tables. B's tables are empty. A and B's tables have the same columns but in different order. That is why I can not use import and export. Is there any way I can export the data from A to a text file and edit it and insert back into B? Thanks for help.

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Thumbs up piece o cake


    It is REALLY easy if you use SQL-Worksheet or TOAD. You use those? Those GUIs will take a table and save it as a .csv file.

    Basically, send the table from DB A to a .CSV file. From there you can use SQLLOADER to insert the data to DB B with a .ctl file to position your column inserts.

    Questions?

    - Magnus

  3. #3
    Join Date
    Sep 2000
    Posts
    96
    If you don't have those GUIs, you can also you the export/import functionality provided by Oracle.

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