Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IMP Please Explanation

Re: IMP Please Explanation

From: <fitzjarrell_at_cox.net>
Date: 16 May 2005 20:32:39 -0700
Message-ID: <1116300759.317660.9690@g47g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US