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

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

    162178
      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