Demo Variable script:-
-------------------------
Follow the steps given below to run the variable format datafile script.
2) Download the Data-File in the XYZ folder.
Click on the link given to download the Data-File : Click Here
3) Download the CONTROL in the XYZ folder.
Click on the Link given to download the CONTROL file : Click Here
4) Download the CREATE Table script in the XYZ Folder.
Click on the Link given to Download the create table script : Click Here
5) Execute/Run the Create Table script in your database to create the table.
6) Run the command to run the Control file.
sqlldr USERID=scott/tiger CONTROL=AOTDF01.ctl
7) Verify the log file created and also check if there is any bad or discard file created.
8) Query the table in database where you have INSERTED the records.
PREVIOUS SQLLOADER-HOME NEXT
6 comments:
Thanks for all you do to help the beginners. This is very useful.
Regards,
Sravan Yerramaneni PMP, CSCP, CSM, ITIL Foundation, Six Sigma Green Belt
You welcome. It's nice to see your comments.
Dear.
Thanks for this blog...
Really it's very useful...
I need the demos file write now it’s not available,
If you can send it to my email
anas.algharabat@gmail.com
thanks
Hi,
There was some issue with other web site where I have upload the files. Those files are gone. I have sent the other file to your email address which has all the cases with data. I am sure this file would surly help you. Have a great time.
Regards,
Phani
I have dat file which has firstname, lastname, strno, distno, empID, cmpDate.
And the table has empid, ssn, cmpDate, enlDate.
How do I load this using ctl file. The data file columns are different from the Table. I just need to load empID and cmpDate. Rest can be null.Thanks in advance.
in CTL file, it just take the Data from from the Postition and put or insert into the table with respects to the columns sequence given in the Control file.
Post a Comment