Datamigration

[kavithared]

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

[sazzadur]

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