sqlldr problem

Hi All,

I am trying to insert some data into a table using oracle sqlldr utility.
we are using oracle 9.0.1 on solaris 8. I get the following error.

sqlldr shravan/shravan control=loader.ctl

SQL*Loader: Release 9.0.1.1.0 - Production on Wed Jan 1 06:48:40 2003

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL*Loader-941: Error during describe of table EMP ORA-04043: object EMP does not exist

My loader.ctl file contains the following lines.

load data
infile *
insert
into table emp
fields terminated by ',' optionally enclosed by '"'
(empno,empname,sal,deptno)

begindata
10,"shravan",100,20
20,"sunil",200,30

can some one throw light on this problem?

Thanks a lot,

Best Regards,
ShravanaKumar. Received on Tue Dec 31 2002 - 17:50:29 CST