How can i load the data from txt files to oracle db tables
uslng sql loader or any anoter simple way ?
http://www.experts-exchange.com/Database/Oracle/Q_20008935.html
Zones:
OracleDate Answered: 05/27/2002 Rating: 7.4 Views: 0
Problem: AIX Unix system, Oracle 8.1.7. The daily file to be loaded normally contains 40K records. Sometimes we receive a full refresh of 1.8 million records. We don't always get warned and syste...
http://www.experts-exchange.com/Database/Oracle/Q_20242086.html
Zones:
OracleDate Answered: 12/03/2001 Rating: 8.0 Views: 4
I have a coma-delimited file
ex
aaaaa,bbbbb,ccccc
aaa2,bbb2,ccc2
....
I want to load in the table this structure:
c1 varchar2(100), -- this will hold "aaaaa"
c2 varchar2(100), -- th...
http://www.experts-exchange.com/Database/Oracle/Q_20272408.html
Zones:
OracleDate Answered: 03/06/2002 Rating: 9.0 Views: 0
I am having difficulties trying to load data into multiple tables. Because of error constraint on the header table, it does not load data into the child table, except for one row. So, I would expec...
http://www.experts-exchange.com/Database/Oracle/Q_20611352.html
Zones:
OracleDate Answered: 05/12/2003 Rating: 8.8 Views: 12
I am using SQL LOADER to transfer data from AS400 to Oracle
this is my problem:
example
table: ABC
column: A,B,C,
when A='1'and B='2' ==> C='12'
when A='1'and B='3' ==> C='13'
when A='2'and ...
http://www.experts-exchange.com/Database/Oracle/Q_20614179.html
Zones:
OracleDate Answered: 05/13/2003 Rating: 6.8 Views: 0
Hi,
I use SQL Loader command line in Unix.
Will it return exit code != 0 if there is any error?
What are the possible codes?
Because I have some references:
All rows loaded successfully ...
http://www.experts-exchange.com/Programming/System/Unix_-_Posix/Q_20654579.html
Hi,
I am very new at using SQL Loader. Before I get into my question, I would appreciate if someone can point me to a definitive online document which details all the nitty gritty of SQL loader....
http://www.experts-exchange.com/Database/Oracle/Q_20781090.html
Zones:
OracleDate Answered: 10/30/2003 Rating: 7.8 Views: 0
I have a file to load to my "names" table. At the time of loading, I would like to insert one record to my "batches" table, and create a batch id.
Once I have this batch id, I would like to inc...
http://www.experts-exchange.com/Database/Oracle/Q_20875902.html
Zones:
OracleDate Answered: 02/06/2004 Rating: 7.8 Views: 0
I am attempting to move data from a flat file created from a bulk-copy from a SQL Server database into an Oracle 9i database using SQL Loader. I have a control file created that works except for t...
http://www.experts-exchange.com/Database/Oracle/Q_20889309.html
Zones:
OracleDate Answered: 02/18/2004 Rating: 6.6 Views: 0
Can someone explain to me how this script is suppose to work...I ran it and the ctl file didnt look complete..
I understand that is should give me the first section stating the "rules" for the sql...
http://www.experts-exchange.com/Database/Oracle/Q_21088666.html
Zones:
OracleDate Answered: 08/11/2004 Rating: 7.6 Views: 0
