Urgent...sql loader problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Urgent...sql loader problem

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    Hi friends
    I am getting different behaviour when I execute the same control file using enterprise manager's Data manager and using the command line.
    I have a table called list in which I have 5 fields. The 4th and 5th fields are to be populated as the new insertion date or update date respectively. There is an 'instead of' trigger which fires at the time of insertions, which checks whether it is a fresh record or an udpate.

    My control file is:

    LOAD DATA
    INFILE *
    append
    into table xyz_manager.list_view
    FIELDS TERMINATED BY "," optionally enclosed by '"'
    (
    termination,
    datetime ,
    code
    )
    begindata
    3607551298,27-jan-2050,3111188,
    3607551428,27-jan-2050,2160118,
    3607551484,30-jan-2050,3934798

    When I execute the above using data manager all is fine. But, if I try to execute the samething from commandline, I get an error saying that the object list_view does not exist.
    If i change the xyz_manager.list_view to xzy_manager.list and execute from command line then it just loads the 3 fields but not the others.
    Can somebody help me in getting what is going wrong while executing from command line?
    Thanks
    manjunath

  2. #2
    Join Date
    Feb 2001
    Posts
    123
    It looks to me that the problem is that the required privileges on the table have not been granted to the Oracle user you are specifying at the command line.

    HTH

    David.

    [Edited by Dave_A on 05-25-2001 at 06:13 AM]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width