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:
into table xyz_manager.list_view
FIELDS TERMINATED BY "," optionally enclosed by '"'
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?
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.
[Edited by Dave_A on 05-25-2001 at 06:13 AM]
Click Here to Expand Forum to Full Width