Home » SQL & PL/SQL » SQL & PL/SQL » Load Data
Load Data [message #227360] Wed, 28 March 2007 01:48 Go to next message
rtskrajan
Messages: 43
Registered: March 2007
Member
Hello
How can i load the old data to Oracle Tables...
I have 405 tables..
100 Tables are morethan 7 lacs rows...

Any one to Help for this...
Re: Load Data [message #227373 is a reply to message #227360] Wed, 28 March 2007 02:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And where are the old data?
In Oracle tables? In flat files? In DB2 or Sybase or whatever database?
Maybe in export dump file?

(Ah, narcissism Razz )

Regards
Michel
Re: Load Data [message #227403 is a reply to message #227373] Wed, 28 March 2007 03:09 Go to previous messageGo to next message
rtskrajan
Messages: 43
Registered: March 2007
Member
Sorry for delay....
All the Tables are in Progress Character Base Tables. But i can convert into MS Access Database....
Is there any way to load to oracle DB...
Re: Load Data [message #227416 is a reply to message #227403] Wed, 28 March 2007 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

From Access, you can load into Oracle.

Regards
Michel
Re: Load Data [message #227431 is a reply to message #227360] Wed, 28 March 2007 04:09 Go to previous messageGo to next message
rtskrajan
Messages: 43
Registered: March 2007
Member
How i can load access to oracle give some advice...
Re: Load Data [message #227435 is a reply to message #227360] Wed, 28 March 2007 04:18 Go to previous messageGo to next message
rtskrajan
Messages: 43
Registered: March 2007
Member
But Oracle Table Structure is not same. In oracle Table we added morethan 10 columns. How possible to load from access to oracle..

Please Advice me..
Re: Load Data [message #227443 is a reply to message #227435] Wed, 28 March 2007 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Maybe you should post this in an Access Forum.
Re: Load Data [message #227452 is a reply to message #227360] Wed, 28 March 2007 05:16 Go to previous messageGo to next message
rtskrajan
Messages: 43
Registered: March 2007
Member
i don't know what to do....
Re: Load Data [message #227462 is a reply to message #227452] Wed, 28 March 2007 05:26 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
rtskrajan wrote on Wed, 28 March 2007 12:16
i don't know what to do....

Well, sitting back won't help you out, will it? Wink

Oracle has provided a utility to migrate foreign databases to Oracle. It is called Oracle Migration Workbench. I don't have any experience with it, but it should get you started. I suggest you first make a 1-1 copy to an Oracle schema and then transform the data from that schema to your destination schema.

MHE
Re: Load Data [message #227465 is a reply to message #227360] Wed, 28 March 2007 05:30 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
If you can unload the data to CSV/fixed length file then you can use SQL*Loader to load it to Oracle (even if some columns don't match).

HTH.
Michael
Previous Topic: Problem with analytical functions
Next Topic: drop
Goto Forum:
  


Current Time: Thu Dec 08 19:55:12 CST 2016

Total time taken to generate the page: 0.13672 seconds