Datamigration
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Datamigration

  1. #1
    Join Date
    May 2002
    Posts
    232
    heloo,I have one database "abc' it contains data.
    This running from 3 years.
    but we need to some modifications like new tables etc,
    So now we created a new database xx.
    So i need to migrated old database data to new database.
    how?
    I think export import is not possible?
    because in new database some newtables and new datatypes>
    how?
    thanks
    kavitha
    __________________
    kavitha
    kavitha

  2. #2
    Join Date
    Sep 2001
    Posts
    62
    Hi,

    You'll most probably have to use sqlloader. This will allow you to export data from your database into a flat file and then do an import from this file.

    Sorry I don't know the exact details but I this might be one direction to try.


    shaz


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