Using Client side "exp" [message #278495] |
Sun, 04 November 2007 14:21  |
seethem
Messages: 41 Registered: September 2007
|
Member |
|
|
Can you help please?
I would like to have an Oracle Client off of a RHEL4.5 blade call the exp function and create the DMP and LOG files **SERVER** side...
Here is my script...
-------------------------------------
export VIEW="v\$database"
EXPORT=`sqlplus -s ${USERNAME}/${PASSWORD}@${ORACLE_SID} <<EOF
set feed off head off timing off linesize 250
spool /home/oracle/result.out
select 'exp ${USERNAME}/${PASSWORD}@${ORACLE_SID} file=${BACKUP_PATH}/${TAG}.DMP log=${EXPLOG}/EXP_${TAG}.LOG buffer=100000 statistics=none flashback_scn='||current_scn||' full=y' from ${VIEW};
spool off
exit
EOF`
-------------------------------------
Question:
===========
If I am kicking this script off of a client machine, using Oracle 10g client tools, how can I make this script run server side?
Considering that when I use RMAN from the client side, I am able get the backed up files stored on the server side. Which is what I want.
Is it that I need to use datapump or can binary exports do the trick for me.
|
|
|
|
|
Re: Using Client side "exp" [message #278504 is a reply to message #278500] |
Sun, 04 November 2007 14:48  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote: | Any special flags to be aware of?
|
Weird question. You have to be aware of all flags in order to use the one appropriate to your case.
Regards
Michel
|
|
|