This discussion is archived
2 Replies Latest reply: Nov 9, 2012 8:49 AM by 162178 RSS

Can you use schema name in "INTO TABLE" in sqlldr?

162178 Newbie
Currently Being Moderated
Hi 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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points