OraFAQ Forum: Server Utilities » Using Client side "exp"

Home » RDBMS Server » Server Utilities » Using Client side "exp" (10g on AIX 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator