1,014 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-1
votes
1
answer
74
views
Load XML file to an existent oracle table using oracle sql developer
I ́m trying to load an existent XML file into an existent table in oracle.
My XML file as the structure:
enter image description here
<Invoice>
<InvoiceNo>FS TML0001/003123501</...
0
votes
0
answers
106
views
Oracle SQL*Loader inserts ? instead of correct Unicode characters (JDBC works fine)
I am working with an Oracle database that uses the US7ASCII character set. When inserting Unicode characters using a Java JDBC program, the values are stored correctly, but when inserting the same ...
0
votes
0
answers
74
views
What charset should I use in SQL loader to load data from MySQL into my Oracle 19c adb?
I used mysqldump to dump the data from a MySQL 8.0 database, which I am moving into my 19c adb.
I am doing this on Oracle Linux.
When I use the file command on the .txt file generated by mysqldump, I ...
-1
votes
1
answer
102
views
Unable to use the SQL*LOADER(sqlldr) to load the CSV file into the DB
As stated, I want to load the data from CSV to a DB. I have prepared the cluster file for this.
Here is the sample CSV data
Record_Type,Cluster_ID,Forecast_ID,Selling_class,Origin,Destination,...
0
votes
2
answers
125
views
Oracle SQLLDR control file: How to accept multiline fields
I have this control file:
Load data into table ODIN_ALERTS_TEST
APPEND
fields terminated by "~"
TRAILING NULLCOLS
(
REGION,
POD,
SEVERITY,
TARGET_NAME,
TARGET_TYPE,
...
0
votes
1
answer
62
views
control file wo/ overwriting specific records in table
I have a table that is populated from 2 sources, and the records in the table are differentiated by a column_type (1 and 2)
let s say that column_Type =1 is for data coming from a file
And column_type ...
0
votes
3
answers
151
views
Control-M: Importing Data (.csv) to OracleDB using SQLLDR without exposing credentials
So, in the Control-M for Database, as far as I know. It purely run queries/statements that is valid as SQL statement. However, the one that I am using which is SQLLDR is an independent cli tool for ...
1
vote
0
answers
1k
views
SQL Loader ERROR - Physical record in data file (text.csv) is longer than the maximum(1048576)
I have a huge file (CSV) to load into Oracle approx,15gb, containing 50 million rows. Below is the error when I try to run sqlldr
Path used: Direct
SQLLoader-510: Physical record in data file (...
0
votes
1
answer
321
views
Oracle SQL Loader for CLOB data type
Currently I am using oracleSQL Loader utility to load the data into the database. My CTL file is shown below. Here the column "LM_CAUTION_NOTE" data type is CLOB in the table. When I execute ...
-1
votes
1
answer
95
views
Oracle Sql Loader converting string value in csv which is "330,000.00" to table with column Capital data type number to store 330000.00
OPTIONS (SKIP=1)
LOAD DATA
INFILE *
APPEND INTO TABLE test_table
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(
CAPITAL FLOAT "replace(:CAPITAL, ',', '')"
)
i tried to insert the data in ...
-2
votes
1
answer
107
views
Using SQL*Loader with a static column
I have a table in Oracle that has 6 columns and a comma-delimited text file that has 5 "columns"
I need to put the year in the first column of each row. The year is not in the text file. It ...
0
votes
1
answer
211
views
FILLER keyword throwing error in external table in oracle
While creating external table with SQL loader to load data, I used "FILLER" keyword specified as in oracle docs as below.
A filler field, specified by BOUNDFILLER or FILLER is a data file
...
0
votes
1
answer
70
views
SQLLDR add header to the bad file
Team, how can we add header to the .bad file being created by SQLLDR. I have header in the input file and the same header we would like to add it to .bad file. Tried skip=1 on the command line but it'...
0
votes
0
answers
223
views
Create SQLLoader ctl file from SQL Server
I have to provide a text file for an application that uses SQL loader to import data. Therefore I require both a ctl file and a ldr file. I am just wondering if there is an easy way to generate a ctl ...
1
vote
1
answer
48
views
Unable to insert 1 record through sql loader
I'm trying to load around 289150 records through SQL loader, out of which 1 record is failing to insert and I'm getting the below error. Pasting the record for which it is failing and the error which ...