Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMP Please Explanation
Jim Kennedy wrote:
> "Carlos Andres Fuentealba F." <carlos_at_localhost.localdomain> wrote in
> message news:pan.2005.05.17.03.15.09.724580_at_localhost.localdomain...
> > please anyone can explain how i can import a file?
> > i have a *.dat file.. please when i use imp command this tell me
"only DBA
> > can do this"..
> >
> >
> The imp program is for programs created with Oracle's exp program.
If you
> have a formatted file created by some other program you will want to
use
> SQLLoader or use an external table. (see documentation)
> Jim
Of course a database dump created with exp can have ANY extension, including .dat. Apparently your .dat file is a valid export, however it was created by a DBA account on the source database. As such, only another DBA can import the contents of that file.
The solution is simple: use a valid DBA account.
David Fitzjarrell Received on Mon May 16 2005 - 22:32:39 CDT