Hi all,
Thanks to everyone who is participating in this and helping others to solve the issues.
I need some help guys !!!
I want to create a Oracle Environment in my Unix server, but i don't know how to do it
My work:
I have CSV(NOV07.txt) file which i want to load into the Database(Oracle 11g), so that i can update the target table.
1.For this i created a control file i.e.., abcloader.ctl(File location : /Export/Home/<krishna>)
2.I tried to execute this using sqlldr command (sqlldr k*****@sun4000.world/u****** control=searsloader.ctl), and i got an error saying KSH: sqlldr: Not found
3.I looked whether the $ORACLE_HOME is there or not. It's not there so i asked my DBA where is the path for sqlldr then he sent an email where the sqlldr is located
/u01/app/oracle/product/11.2.0.3/bin/sqlldr
Can anyone please tell me what to do after this? How do i set up ? what are the commands that i need to use
This was the first time i a m doing this.
Thank you.