exporting tables [message #405950] |
Mon, 01 June 2009 01:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
amegido
Messages: 1 Registered: June 2009 Location: egypt
|
Junior Member |
|
|
Hi All,
I will get a new ERP System in my company and I already have an application running on oracle database 10g and I need to know how to export tables from the old database to implement the New ERP System ( Data Immigration )
|
|
|
Re: exporting tables [message #405952 is a reply to message #405950] |
Mon, 01 June 2009 02:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21811 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
If it is about moving the whole schema, export/import utilities (or data pump) might do the job.
Otherwise, if new data model is different from the existing one, you'll have to do the migration in a way that certain columns from your tables have to fit into certain columns in new tables. This might require a lot of time and effort (i.e. programming - INSERT INTO will be your favourite statement) if you want to do it correctly.
|
|
|