Re: sqlldr problem

"Shravana Kumar" <kumar.shravana_at_blr.spcnl.co.in> wrote in message news:3E122D45.F0AC0B57_at_blr.spcnl.co.in...
> 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
>

You are running sqlldr whilst logged in as yourself.

Now, do that in sqlplus and see what happens when you issue the 'select * from emp' command....

You'll find that EMP doesn't exist then either.

And that's perfectly correct, because EMP doesn't exist in YOUR schema. It exists in SCOTT's schema. So you have to specify the schema every time the object doesn't belong to you. Hence, a 'select * from scott.emp' would work in sqlplus.

And if you run sqlldr as Scott, the load will work too.

Or you could specify "scott.emp" in your control file instead of just the "emp" reference you have currently.

Regards
HJR
> 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 Wed Jan 01 2003 - 05:59:23 CST