-
Hi all,
I want to transfer data from Access to Oracle. I usually do it using the SQL Server's DTS. But since one particular table has around 380,000 records, it takes around 5 hours for me to transfer that one table completely.
Is there any other faster way to do it ?
Thanks,
Shiva.
-
You could us the "save as" option in Access to save to a comma seperated file and then use SQL*Loader to load into Oracle...
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|