AboutSuchitra Joshi Expertise I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader and some basic dba activities or performance tuning for Oracle 8i database. I cannot answer questions related to major dba activities, backup and recovery.
Experience 10+ years D2K
Awards and Honors OCP - SQL and PL/SQL
Brainbench certifications in Oracle Administration, Database, PL/SQL
Question QUESTION: I need to create a .CTL file for a given table and in the data file the columns are scattered here and there in a .CSV(Comma Separated Version) format. My query here is how to find the position no. of a particular column in this scattered file or do sqlldr have any skip column command to pick up data from .CSV file. Urgent Please reply asap
ANSWER: Hi Kavitha,
In order to help you, I will require the .csv file and columns that you want to load in the table.
You can send me the .csv file to the following mailid - suchitraajoshi@hotmail.com
Regards
Suchitra
---------- FOLLOW-UP ----------
QUESTION: Actually, I would like to know how to skip some of the columns in the data file whereas data file is in comma separated format.
for e.g. I need 1st column and then 5th column means how to skip in between columns when i don't know the position no.
ANSWER: Hi Kavitha,
According to my knowledge, we cannot skip columns for loading data. We can only do this when we are using the position based load.
Regards
Suchitra
---------- FOLLOW-UP ----------
QUESTION: From oracle 8i onwards there is a option called filler will this help in my situation.the data file was a .csv with 153 columns but the database matching column is 49. So when I start reading the record to upload I have decided to put filler for unwanted columns. Is it right or what is the purpose of filler. Mine is Oracle10g.
Answer Hi Kavitha,
The Filler option is used only when there is a column in the table, but no corresponding column in the data file. In your case it is exactly opposite. So you cannot use this.
One alternative is to create a temporary table with all the columns as that of data file, and then load the required columns in the main table.
