Adding a date to an export filename

I've just inherited an Oracle database, and I don't have the first clue as to how to write code for it. I do however know how to search on the web, and have come up with this script.
**********************************************************************
f:
cd Oracle_Backup

REM Column instnc new_value v_instnc noprint
REM column instdate new_value v_instdate noprint
REM SELECT name instnc
REM FROM v$database;
REM SELECT TO_DATE(sysdate,'DDMMYYHH') instdate
REM FROM dual;

exp system/manager@swp
REM file=swp_full&&v_instexp&&v_inst_exp&&v_instdate..dmp
REM log=swp_full&&v_instexp&&v_inst_exp&&v_instdate..log

full=y
**********************************************************************

The REM lines are what I gleaned off another site, and the file and log commands originally looked like:

file=swp_full.dmp
log=swp_full.log

But were changed to this per the borrowed script:

swp_full&&v_instexp&&v_inst_exp&&v_instdate..dmp
swp_full&&v_instexp&&v_inst_exp&&v_instdate..log

So, I can almost follow what is being done in the script, but since I have ZERO Oracle experience, I need help. If you can help me please contact me. I would greatly appreciate it.

What are you trying to do with export? Hopefully you aren't using export as a backup method. If you need to read this. Maybe even start with quick start to rman.

Quote:

---

Originally posted by OracleNewb7731
I've just inherited an Oracle database, and I don't have the first clue as to how to write code for it. I do however know how to search on the web, and have come up with this script.
**********************************************************************
f:
cd Oracle_Backup

REM Column instnc new_value v_instnc noprint
REM column instdate new_value v_instdate noprint
REM SELECT name instnc
REM FROM v$database;
REM SELECT TO_DATE(sysdate,'DDMMYYHH') instdate
REM FROM dual;

exp system/manager@swp
REM file=swp_full&&v_instexp&&v_inst_exp&&v_instdate..dmp
REM log=swp_full&&v_instexp&&v_inst_exp&&v_instdate..log

full=y
**********************************************************************

The REM lines are what I gleaned off another site, and the file and log commands originally looked like:

file=swp_full.dmp
log=swp_full.log

But were changed to this per the borrowed script:

swp_full&&v_instexp&&v_inst_exp&&v_instdate..dmp
swp_full&&v_instexp&&v_inst_exp&&v_instdate..log

So, I can almost follow what is being done in the script, but since I have ZERO Oracle experience, I need help. If you can help me please contact me. I would greatly appreciate it.

---

what do you actually want to do? take an export of the database? or are you trying to understand what this does?

There are much easier ways than that

Like I indicated, I know absolutely squat when it comes to Oracle. This is how they are backing up their Oracle database, and I haven't had time to learn anything to bring myself up to speed. Probably won't have time for a while either. This network is a mess, and I've been brought in after the fact to help clean it up.

Is this windoze?

What I do in windoze is have the scheduled export put the .dmp and .log files into a dir, let's say D:\export
From there I have a script that compresses (via winzip) the .dmp files and timestamps them using sqlplus. It is a little involved but very reliable and effective.

Mr.H's idea sounds good. You can rename the files at the OS level with something like this: http://www.dbasupport.com/forums/sho...threadid=40159 should be easier than using sqlplus.