Invoking SQL*Loader On Unix systems, the command used to invoke SQL*Loader is sqlldr. On Windows systems running Oracle8i, release 8.1 or higher, the command is also sqlldr. The command to execute SQL*Loader is as follows: sqlldr USERID = <username>/<password> CONTROL = <control file name> LOG = <log file name>…. Issuing the sqlldr command by itself results in a list of valid command-line parameters […]
SQL*Loader Environment SQL*Loader takes as input a control file, which controls the behavior of SQL*Loader, and one or more datafiles. Output of the SQL*Loader is an Oracle database (where the data is loaded), a log file, a bad file, and potentially a discard file. Execution Steps: Step1 Executes from the command prompt or parameter file. Step2 Reads […]
Registering SQL*Loader as a Concurrent Program The following steps will describe the process to register a SQL*Loader program as a Concurrent Program in Oracle Apps. Step 1] Create the SQL*Loader Control and Data file and place them in Server(ex: $CUSTOM_TOP/bin). Create or check the interface table structures in the backend. Control file: test.ctl Data file: […]
SQL*Loader Basics SQL*Loader is an Oracle-supplied utility that allows you to load data from a flat file into one or more database tables. It has a powerful data parsing engine that supports data present in any format in the data files. It can load data from multiple datafiles during the same load session as well […]
1] Add the “Xml Publisher Administrator” Responsibility to the user through the front end. 2] Create the Report(Data Model or we can say the .Rdf file) using Oracle Report Builder. 3] Set the user parameter as p_conc_request_id. 4] Add the default values to the Before Report and After Report triggers(not mandatory) 5] Ftp the Report […]
Recent Comments