Hoek wrote:Disagree with that statement.
Of even better: use an external table, SQL*Loader is soooooo 1980...
Bibhuprasad wrote:No, that's a file extension not a format. As I demonstrated above, the file extension can relate to many different file formats depending on who or what generates it.
The format is *".ldr"*
and here is an example of that kind of file gbs_employee_tbl_data.ldr.That's not a file. It's a filename. Pointless on the forum and demonstrates nothing to us.
If you export data from SQL developer with loader format then, the file will be created in *".ldr"* extension.Ok, so it's a file generated by SQL Developer. I don't have SQL Developer and neither will many people. Is it too hard for you to put a sample of some data on the forums for people to see that actual format of the data? You really are making this hard for people to help you. If you want help, you have to give sufficient information so that people can see what you are trying to do...
Bibhuprasad wrote:When you create a ".ldr" file using SQL Loader it will also generate a ".ctl" file, This is the control file that you will be using with the SQL Loader tool.
Please tell me how can I load data into a table from *.ldr* file? How exactly I can use such files to run in loader?