Once you have the ctl file theoretically you don't even need TOAD, as you could just use sqlloader on any machine that has sqlloader and can connect to the database. Next.Ĭhoose either 'execute now' to load the data now or 'just build the control file' to build the. Type a control file name in the control file name box. If your file has column headers in its first row, type a 1 in the skip box. You might get duplicates this way but it's a good method if you're trying to get that last line that somehow got munged for some reason or another. INSERT will insert data if table is empty but will return an error if table has any data in it.ĪPPEND will insert data without deleting any existing data. TRUNCATE will erase whatever is in the table before loading. Next.Ĭhoose a 'load method' noting the following: If you are loading a tab-delimited file, select 'TAB' from the 'all fields delimited by' combo box. If you are loading a comma-delimited file, type a comma in the 'all fields delimited by' combo box. Choose your comma-delimited or tab-delimited file. If your data has commas within a text field, save your file as tab-delimited.Ĭlick 'Add'. Save the Excel file as a comma-delimited (.csv) or tab-delimited (.txt) file. METHOD 2: SQL*Loader You can use TOAD's interface to a program from Oracle called sqlloader. TOAD for Oracle empowers developers and DBAs to be more productive by providing an intuitive graphical user interface to Oracle. This window can be used to import data from various kinds of source files into a table. GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together. Maybe there was version incompatibility issue. To solve it I've downloaded more recent version of OIC - Oracle Instant Client 19.3 and Toad connected to Oracle's DB without issues.

METHOD 1: Click Tools → Import → Import Wizard. In my case similar issue have appeared when I used Oracle Instant Client 18.5 for connecting to DB using Toad 13.1.1.5.

Toad For Oracle 9.5 Portable