DATABASE BACKUP

[85858585]

HOW TO TAKE BACKUP OF A ORACLE DATABASE OUTOMATICALLY HAVING SYSTEM DATE( CURRENT DATE) INSTED OF PUTING MYSELF THE FILE NAME "ABCD.DMP" .

AS FOR EXAMPLE:
WHILE I'M TAKING BACKUP OF A ORACLE DATABASE WITH "EXP" UTILITY THAT TIME I HAVE TO GIVE THE BACKUP FILE NAME LIKE "ABCD.DMP" BUT I DON'T LIKE TO PUT THE FILE NAME MYSELF,IT WILL TAKE AUTOMATICALLY THE SYSTEM DATE LIKE "201102.DMP" HOW IS THIS POSSIBLE?

 

[carp]

Create a script that builds the file name (and subsequently the EXP invocation line) and then calls the execution line.

 

[Turkbear]

Hi,
If possible please avoid CAPS, it is the same as shouting.

To do what you want, and assuming Windows - since you fail to mention any details about version,os, etc - look into using a batch file to call the exp program and use environment variables to construct the file name for the dmp file..

The windows' help files should have the info you need on how to use those variables ..