Loading ...
Sorry, an error occurred while loading the content.

SQL LOADER FLAT FILE

Expand Messages
  • priya dickshit
    Hi,   I need a help to load data from a flat text file into a table. For this I applied the following command SQL CONNECT SYSTEM/MANAGER; SQL CREATE OR
    Message 1 of 1 , Aug 26, 2008
    • 0 Attachment
      Hi,
       
      I need a help to load data from a flat text file into a table. For this I applied the following command
      SQL> CONNECT SYSTEM/MANAGER;
      SQL> CREATE OR REPLACE DIRECTORY PAY_DATA AS 'D:\TEMP';
      SQL> GRANT ALL ON DIRECTORY PAY_DATA TO PAYROLL;
      SQL> GRANT READ,WRITE ON DIRECTORY PAY_DATA TO PAYROLL;
      SQL> CONNECT PAYROLL/PPP;
       
      SQL> CREATE TABLE pull_data (
        data              VARCHAR2(35)
      )
      ORGANIZATION EXTERNAL (
        TYPE ORACLE_LOADER
        DEFAULT DIRECTORY PAY_DATA
        ACCESS PARAMETERS (
          RECORDS DELIMITED BY NEWLINE
          MISSING FIELD VALUES ARE NULL
          (
            data              CHAR(35)
          )
        )
        LOCATION ('d:\temp\02085802.t08')
      )
      PARALLEL 5
      REJECT LIMIT UNLIMITED
       
      SQL> /
      Table created.
       
      SQL> DESC PULL_DATA
       Name                                      Null?    Type
       ----------------------------------------- -------- -------------------
       DATA                                               VARCHAR2(35)
       
      SQL> select *from pull_data;
      select *from pull_data
      *
      ERROR at line 1:
      ORA-29913: error in executing ODCIEXTTABLEOPEN callout
      ORA-29400: data cartridge error
      KUP-00554: error encountered while parsing input commands
      KUP-01005: syntax error: found "missing": expecting one of: "badfile,
      characterset, data, delimited, discardfile, exit, fields, fixed, load, logfile,
      nodiscardfile, nobadfile, nologfile, processing, string, skip, variable"
      KUP-01007: at line 2 column 6
      ORA-06512: at "SYS.ORACLE_LOADER", line 14
      ORA-06512: at line 1
      -----------------------------

       
      WHY  I AM GETTING THIS ERROR, COULD ANY ONE  TELL ME ... TEXT FILE IS ALREADY LOCATED IN D:\TEMP.
       
      FURTHER MORE, THIS TEXT FILE '02085802.t08'  WILL BE CREATED ON NEXT DAY AND NAME MIGHT BE 06082702.T08 ,
       
      How can be picked the lates file name (   LOCATION (??????) )
      created by the operation system from the client machine C:\time_machine\Data\
      I am using Forms Oracle 10g Rel2 and Database 9i R2, Application SErver 10g.
       
      Kindly note that, this routine will be run from client machine not from the server.
      Thanks and regards.
       
      Priya


      Connect with friends all over the world. Get Yahoo! India Messenger at http://in.messenger.yahoo.com/?wm=n/

      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.