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 Grade: A 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
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 Grade: A 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 Grade: A Views: 5
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 Grade: A Views: 4
I have the following in my .ctl file
LOAD DATA
INFILE "../FlagImport.txt"
REPLACE
INTO TABLE flag_dor_import
TRAILING NULLCOLS
(
TAP_PARCEL_ID POSITION(1:11) CHAR,
TAP_AREA_COD...
http://www.experts-exchange.com/Database/Oracle/Q_21776819.html
Zones:
OracleDate Answered: 04/05/2006 Grade: B Views: 15
Hi,
I have a table which I loaded with sql loader. It has abt 500 million rows. obviously I used the option of skipping the index maintenance.
ldss@ldss1.cp.lucent.com/bum021 load_hist.ctl e...
http://www.experts-exchange.com/Database/Oracle/Q_21896063.html
Zones:
OracleDate Answered: 11/15/2007 Grade: A Views: 0
Hi all,
I'm facing a problem while loading data into ora 10g, when i try to load data, the sql loader loads data successfully, log file seems to be ok but when i query the data all the records...
http://www.experts-exchange.com/Database/Oracle/Q_22114377.html
Zones:
OracleDate Answered: 01/15/2007 Grade: B Views: 63
What setting you use to reject the file if 1 record is not accepted? and why?
http://www.experts-exchange.com/Database/Oracle/Q_23229797.html
Zones:
OracleDate Answered: 03/10/2008 Grade: A Views: 0
What setting would you use to load the file regardless of the number of errors? Why?
Is it DISCARDMAX?
http://www.experts-exchange.com/Database/Oracle/Q_23229867.html
Zones:
OracleDate Answered: 03/10/2008 Grade: A Views: 0
