|English: The logo of Oracle Corporation de:Bild:Oracle-Logo.svg he:תמונה:Oracle Logo.jpg (Photo credit: Wikipedia)|
The easiest way I've found to import text data sources into Oracle have been using the Microsoft SQL Server Import and Export Wizard that comes with Standard, Enterprise or Developer editions of MS SQL Server.
Assuming you've got the Oracle database drivers installed, just right click a database from within SQL Server Management Studio, choose Tasks -> Import Data.
- Instead of using your Server Name, enter the database instance name and the credentials.
- Click Text Connection to be sure it is correct, and click Allow saving password.
- Click OK.
- Click Next.