2 Replies Latest reply: Nov 9, 2012 10:49 AM by 162178 RSS

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

      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
      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.