Re: a user to use only import

tof schreef:

>
> SQL>
>
> oracle_at_debian:~$ exp batch/batch full=y file=test.dump
>
> Export: Release 10.2.0.1.0 - Production on Lun. Août 21 21:51:11 2006
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
>
> EXP-00056: Erreur ORACLE 1045 rencontrée
> ORA-01045: user BATCH lacks CREATE SESSION privilege; logon denied
> Nom utilisateur :
>
> christophe

Yes - correct behavior. The import and export utilities do need to logon to the database. So you do need create session. But with nothing else, these is not much you can do.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...