I have a simple question.
My Oracle userid is SBHAT. SBHAT has insert,delete, select,update privileges on a Table in another schema XYZ.
I want to SQL*Load data in Table EMPLOYEE in XYZ schema, using my userid. Something like ....
sqlldr userid=*SBHAT*/password control=test.ctl data=test.txt
I tried to use the following in my test.ctl file but it does not work.
into table "XYZ.EMPLOYEE"
fields terminated by ',' optionally enclosed by '"'
Can someone give me the proper syntax for into table that uses *schema.table_name* construct.
Pl post exact OS and database versions - what do you get when you execute sql*loader with the syntax you have identified so far ?