RE: import problems

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_at_gmail.com] 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_at_fpl.com<mailto:JEREMY.SHEEHAN_at_fpl.com>> 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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 26 2008 - 12:50:36 CST