| export problem on HP-UX [message #146888] |
Mon, 14 November 2005 08:38  |
orcl dba
Messages: 68
Registered: August 2005
|
Member |
|
|
I want to do a user level export on a HP-UX machine and schedule it using cron. I used to do it on Windows until now and the following is the script I used for the export:
"exp_user1.bat"
@echo off
set oracle_sid=test2
set ORA_OCI_NO_OPTIMIZED_FETCH=1
sqlplus user1/user1@test2
@exp_user1_parfile.sql
exp user1/user1@test2 parfile=user1.par
Given below are the contents of the file "exp_user1_parfile.sql"
set verify off pagesize 0 feedback off linesize 512 trimspool on
spool user1.par
select 'owner=user1' from dual;
select 'rows=y' from dual;
select 'compress=n' from dual;
select 'file=user1'||to_char(sysdate,'YYMMDD')||'.dmp' from dual;
select 'log=user1.log' from dual;
select 'statistics=none' from dual;
spool off
exit
I used the command "'select file=user1'||to_char(sysdate,'YYMMDD')||'.dmp' from dual;" so that I can keep track of the day that the dmp file was generated. My question is, what is the equivalent of the Windows command "@echo off" in HP-UX so that command-echoing can be turned off and the parameter file has only the required parameters.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
