-
Import text file to Oracle
Hi,
I have 5 small tables with about 3000 records in SQL server, and I want to convert them to oracle, but I don't want to use Oracle Migration Workbench.
I want export those 5 sql tables to 5 text files. Does any tool can import text file to oracle?
Thanks in advance!
Theresa
-
1. From sql server you can directly export to oracle -DTS Package
2. ETL tools like Informatica can do that.
-
Oracle has its own tool called SQL Loader, which does exactly what you are trying to do.
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
|
|