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.
I think export import is not possible?
because in new database some newtables and new datatypes>
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.
Click Here to Expand Forum to Full Width