Home » RDBMS Server » Backup & Recovery » imp parfile
imp parfile [message #130767] Tue, 02 August 2005 06:47 Go to next message
maheshwar
Messages: 1
Registered: August 2005
Junior Member
This script was used to create a parfile

export_obizobjp_users.par

userid=
file=compress_pipe
owner=(
BIZOBJ,
BIZOBJ_AUDIT,
BIZOBJ_DEV,
BIZOBJ_PROD,
BIZOBJ_PUB,
BIZOBJ_TEST,
BIZOBJ_TRAIN
)

log=export_obizobjp_users.log
consistent=Y
direct=Y
statistics=NONE

-------------
This script was used to create compress_file in a unix environment.

I want to import this in windows environment using
---------
import_obizobjp_users.par
file=compress_pipe
---------

My question is how do i do this, i'm doing it for the first time.
Re: imp parfile [message #130773 is a reply to message #130767] Tue, 02 August 2005 07:18 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
insufficient information.
Your script has no indication that the file is actually piped or compressed in unix environment.
so, as per your script you are not really compressing or piping.
>>file=compress_pipe
the exported dump file is compress_pipe.
ftp this file ( with bin option) to windows machine.
use
imp userid=username/pass file=compress_pipe fromuser=x touser=y
Previous Topic: Restore time 15x backup time
Next Topic: recover a clone database with archived log of the production one
Goto Forum:
  


Current Time: Thu Mar 28 12:09:57 CDT 2024