import problems
Date: Fri, 26 Dec 2008 13:32:27 -0500
Message-ID: <8833494F383585499CB855121711D2630B3A84D216@JBXEXVS02.fplu.fpl.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 26 2008 - 12:32:27 CST