On Mon, Aug 31, 2009 at 5:35 PM, Paul Mendez <silvervortec@cox.net> wrote:
> 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>
> 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
>
> Thanks for the info, Paul. I tried similar syntax and did review that
link. I have a feeling that I need more info from their existing database.
I'll try to see if the client will be helpful...
___________________
Nolug mailing list
nolug@nolug.org
Received on 09/01/09
This archive was generated by hypermail 2.2.0 : 10/04/09 EDT