Can you use schema name in "INTO TABLE" in sqlldr?
162178Nov 9 2012 — edited Nov 9 2012Hi All,
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.
load data
append
into table "XYZ.EMPLOYEE"
fields terminated by ',' optionally enclosed by '"'
trailing nullcols
Can someone give me the proper syntax for into table that uses *schema.table_name* construct.
Thanks,
Suresh