Home » SQL & PL/SQL » Client Tools » exporting tables (windows server 2003)
exporting tables [message #405950] Mon, 01 June 2009 01:51 Go to next message
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
Littlefoot
Messages: 19636
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.
Previous Topic: MERGE Statement... TIME OUT error... hanged (merge 6)
Next Topic: Oracle client compatibilty
Goto Forum:
  


Current Time: Tue Sep 23 03:30:09 CDT 2014

Total time taken to generate the page: 0.12817 seconds