Stack Overflow
Stack Overflow

Questions tagged [controlfile]

46 questions
0
votes
2 answers

sql loader control file has FIELDS TERMINATED BY ¶ (Pilcrow)

I have to load data through sql loader in oracle database. In control file FIELDS TERMINATED BY ¶ mention. sql loader unable to recognize pilcrow as a delimiter. data like HDR¶name¶Id BDY¶rohan¶2 TRL¶1
user9109204
  • 9
  • 1
  • 2
0
votes
1 answer

Unable to load large amount of data when running the SQL Loader Process through Java

My Sample CSV File that I need to upload to DB has a little over 10000 records. I am executing sql loader command through Java method call: process = Runtime.getRuntime().exec(sqlLdrCmd); this uploads 4924 records and then the execution just hangs…
Saurabh Mehta
  • 91
  • 1
  • 2
  • 9
0
votes
1 answer

How to ignore " while loading data from csv through sql loader

Fields in my csv file are enclosed by ". So I have to use optionally enclosed by '"' clause in my control file. But in some rows, value of a field also contains " hence it gives an error while loading the data from those rows. How to get over that…
varad
  • 11
  • 9
0
votes
2 answers

Script Shell for loading a lot of files in oracle

I have a lot of log files that i want to insert them into a table (oracle). What is the best to do so? All logs are like below. There are lot of files like this in my directory. 11/04/2017 12:00:02 11959 trt_ret_tp START Chargement des…
sh1900
  • 1
0
votes
1 answer

Any Explanation for creating CONTROLFILE Statement - Oracle 11g?

Was searching online for any description or explanation for Creating Control file in Oracle 11g . All what i found is this code and could not understand it to be honest : CREATE CONTROLFILE SET DATABASE prod LOGFILE GROUP 1…
Laith
  • 428
  • 4
  • 10
0
votes
2 answers

How to use the OR condition in when clause of SQL Loader control file

I am trying to use the OR condition in when clause in control file, This this my code in control file : load data INFILE 'router.txt' INTO TABLE ROUTER_ATTLAS_TABLENAME APPEND **WHEN ((1) = 'J' or (1) = 'D2' or (1) = 'vJ' or (1) = 'VJ'…
chaya
  • 423
  • 3
  • 11
  • 19
0
votes
1 answer

How to insert Date in same format as in input into oracle through sqlldr

I have created a .ctl file to insert some data in oracle 11g. In the input file there is column called LAST_DATE having format (MM/DD/YYYY) and same column is there in oracle with date datatype. But when i try to insert the data its format get…
Ashique Sheikh
  • 155
  • 2
  • 4
  • 13
0
votes
1 answer

Using varchar in a control file for sqlldr

I have a process that dynamically creates the CTL file through a sql query. And I have to have the file name inserted into the oracle table. I am able to get the filename to show on the query, but it keeps rejecting it. Do ctls only accept…
Alkey29
  • 189
  • 1
  • 5
  • 20
0
votes
2 answers

how to change the beginning position of the field in sql loader

I have a file which i want to load using sql loader.the sample file is as follows. 1|Deepak|1|raj|Kumar|mcapatna|powerhouse the control file is LOAD DATA INFILE * TRUNCATE INTO TABLE Student WHEN (1:1)= '1' FIELDS TERMINATED BY…
The PowerHouse
  • 560
  • 14
  • 29
0
votes
2 answers

SQL*Loader control file few columns are blank

My filename .dat file includes 1000 records in below format. SIC_ID|NAME|CHANGED_DATE|LOGICALLY_DELETED 110|Wheat|31/10/2010 29:46:00|N Table in which I want to feed content has few more columns. I wish to leave these columns blank as content is…
Umesh Patil
  • 10,475
  • 16
  • 52
  • 80
0
votes
1 answer

How can I store the value of an expression in a sqlldr control file and load it into multiple columns?

I'm having difficulty storing an expression to be loaded into two separate columns. We have two values -- RECORD_ID and ITEM_NUMBER which both need unique values per row. My first impression was to somehow load the value of the sequence into a…
Sed
  • 133
  • 1
  • 1
  • 9
0
votes
0 answers

SQLLoader optional lines in a csv-file

there are several csv-files which I have to put in a database via sqlloader. The files look like this: nr, value,description 839, 73, mydescription 842, 12, mydescription But some lines in these files are optional and for these specific lines (839,…
Michael
  • 1
  • 1
0
votes
1 answer

How to add an update to existing SQL Loader control file?

How to create an external table from my text file and use that to update to real table, rather than creating a (normal) staging table and using SQL*Loader. sample.ctl load data infile 'data.txt' append into table newtable fields terminated by '|'…
Dinesh Kumar
  • 1,173
  • 7
  • 19
  • 30
0
votes
1 answer

Is there any way to rename control file in oracle apart from shutting down oracle database? I need to rename control file

The situation is like I have space in one of my control file I need to rename it but don't want to shutdown database. Is there any other way? The classic way I follow is Alter system set control_files='' scope=spfile; shutdown immediate…
Shrilim
  • 1
0
votes
1 answer

load csv file into multiple Oracle tables

I have created a control file using TOADs SQL* Loader Wizard. I have used specified following two tables to load the data but the after running the data has only loaded into one table and a dsc file is generated. Below is the control file I am…
Henry Rios
  • 1
1 2
3
4