Re: [Nolug] Any Oracle gurus on the list...

Did you try the following:

imp.exe "user/passwd@dbname" parfile=parfile.txt
or
imp.exe "sys/passwd@dbname as sysdba" parfile=parfile.txt

parfile.txt contains following (edit the values below):

FILE=import.DMP
BUFFER=100000
FULL=y
GRANTS=y
INDEXES=y
IGNORE=y
DESTROY=y
COMMIT=y
LOG=import.log

http://www.orafaq.com/wiki/Import_Export_FAQ

-Paul

Sent from my iPhone

On Aug 31, 2009, at 4:53 PM, Jonathan Roberts <gremln007@gmail.com>
wrote:

> It's been a while since I used Oracle... A client supplied an
> Oracle export file (.DMP) and I am trying to import it. I fired up
> an instance of Oracle XE and am trying to use the "imp" utility. I
> cannot seem to find the right group of options to tell it to import
> their database into a new database/schema in my test instance. If
> anyone cannot help, I would greatly appreciate it.
>
> Thanks,
> Jonathan
>

___________________
Nolug mailing list
nolug@nolug.org
Received on 08/31/09