Re: import : only a DBA can import a file exported by another DBA

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 28 Jan 2003 14:56:48 -0000
Message-ID: <3e369a31$0$232$ed9e5944@reading.news.pipex.net>

"zorro" <z_at_z.com> wrote in message
news:WgwZ9.136614$H7.5573588_at_news2.calgary.shaw.ca...
>
> When I import a dmp file, I get this message :
>
> Export file created by EXPORT:V08.01.07 via conventional path
> IMP-00013: only a DBA can import a file exported by another DBA
> IMP-00000: Import terminated unsuccessfully
>
> The user who created the dmp file is not DBA. He has the CONNECT,
> IMP_FULL_DATABASE, EXP_FULL_DATABASE and RESOURCE.
>
> Why does the imp tool say this ! How can I avoid this message ?

AFAIK it is lying to you. My guess would be that the user that you are using to *import* the file does *not* have IMP_FULL_DATABASE privileges.

BTW You may wish to review the connect and resource roles, as they grant rather more rights than the names suggest

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Tue Jan 28 2003 - 08:56:48 CST