RE: import problems
- From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxx>
- To: Mahesh Rajendran <magvivek@xxxxxxxxx>
- Date: Fri, 26 Dec 2008 13:50:36 -0500
Your eyes are NOT deceiving you in the slightest! Can you say brain-numb from
a very UN-busy day? LOL!
Thanks for your help! The import is running as expected now....
Jeremy
P Consider the environment. Please don't print this e-mail unless you really
need to.
From: Mahesh Rajendran [mailto:magvivek@xxxxxxxxx]
Sent: Friday, December 26, 2008 1:39 PM
To: SHEEHAN, JEREMY
Subject: Re: import problems
May be my eyes are deceiving me.
Seems you are using exp.exe inside the import script instead of imp.exe
On Fri, Dec 26, 2008 at 1:32 PM, SHEEHAN, JEREMY
<JEREMY.SHEEHAN@xxxxxxx<mailto:JEREMY.SHEEHAN@xxxxxxx>> wrote:
Hey all,
I hope everyone has had a very safe and happy holiday!
Oracle 10.2.0.3
Windows Server 2003
I'm trying to export a schema from prod and import to a new schema in dev.
I've created the user/schema. Everytime I import I get the following error.
LRM-00101: unknown parameter name 'FROMUSER'
My export parameters are as follows...
owner=QPROSPECT
statistics=none
filesize=2000m
file=O:\Oracle\admin\pmiesrp\exp\ex_qp_PMIESRP01.dmp
log=O:\Oracle\admin\pmiesrp\exp\export_PMIESRP.txt
buffer=1000000
direct=y
COMPRESS=Y
I'm importing using a batch file (written as such)....
set ORACLE_HOME=O:\Oracle\product\10.2.0\db_esri
set ORACLE_SID=PMIESRD
O:\Oracle\product\10.2.0\db_esri\BIN\exp.exe 'dbao/****** as sysdba'
parfile=O:\oracle\admin\PMIESRD\exp\import_QP2_PMIESRD.ctl
pause
with the following parameters.....
file=O:\oracle\admin\PMIESRD\exp\ex_qp_PMIESRP01.dmp
log=O:\oracle\admin\PMIESRD\exp\import_QP2_PMIESRD.txt
FROMUSER=QPROSPECT
TOUSER=FPL_DEV_QPRO200
full=y
buffer=1000000
direct=y
Any suggestions? This is killing me b/c it's something SO simple, but I can't
figure it out!
Thanks in advance!
Jeremy
P Consider the environment. Please don't print this e-mail unless you really
need to.
--
Mahesh Rajendran
Other related posts:
