import problems

From: SHEEHAN, JEREMY <JEREMY.SHEEHAN_at_fpl.com>
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-l
Received on Fri Dec 26 2008 - 12:32:27 CST

Original text of this message