| backup problem [message #84649] |
Sun, 11 April 2004 01:10 |
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 folloing 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
