| backup problem [message #45751] |
Sun, 11 April 2004 22:11  |
MD. SAKIL
Messages: 3
Registered: April 2004
|
Junior Member |
|
|
hi all,
i have developed a form to backup my schema. i have created a button using when_button_pressed trigger and used the following code for backup.
----------
host('exp scott/tiger@orcl file=e:csd'||to_char(sysdate,'ddmmyyyy')||'.dmp grants=y compress=y indexes=y rows=y constraints=y log=e:csd'||to_char(sysdate,'ddmmyyyy')||'.log owner=scott');
-------------
whenever i run this form it creates a .dmp file and a log file. it creates a new file everytime.
what i want is that to generate a single file which will overwrite the previous days file and not creating a new one.
is this possible
plz help
sakil
|
|
|
|
| Re: backup problem [message #45762 is a reply to message #45751] |
Mon, 12 April 2004 14:15  |
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
|
Senior Member |
|
|
|
That command will create an export file and logfile with names that include today's date. How do you want the files to be named? Or if you want to delete previous files, what should the rule be if there are many files?
|
|
|
|
| Re: backup problem [message #45766 is a reply to message #45762] |
Tue, 13 April 2004 00:56 |
MD. SAKIL
Messages: 3
Registered: April 2004
|
Junior Member |
|
|
thanks for the reply,
i know that this will create an export file and logfile with names that include today's date. i want the files to be named something like a.dmp and a.log. and i also want to delete all previous files,there should not be many files? only the current file.
like today im running the form and it will generate a file *.dmp. when i run it tommorow it will delete previous days file and generare a new *.dmp file again.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
