| how to take back up of database from forms [message #177420] |
Wed, 14 June 2006 09:00  |
ranisri321
Messages: 22
Registered: March 2006
Location: hyderabad
|
Junior Member |
|
|
hi
i want to take a backup of database into one folder when iam pressing button in form module.
i should able to take backup of db daily or monthly or yearly
is there any method.
pls send me the reply as soon as possible
|
|
|
|
| Re: how to take back up of database from forms [message #177465 is a reply to message #177420] |
Wed, 14 June 2006 18:01  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I guess that HOST is the command you are looking for. Probably you'll need to write an operating system file (for example, a MS DOS .bat file) which would actually perform backup. You'd call this script from your form using the WHEN-BUTTON-PRESSED trigger with already mentioned HOST command.
Daily or weekly backup suggests that there's another term you might need: scheduling. You'll have to decide will it be Oracle-based scheduling (read more about DBMS_JOB or DBMS_SCHEDULER) or operating system specific scheduling (which differs from UNIX to MS WINDOWS to OpenVMS etc.).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
