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