| Backup table [message #516673] |
Wed, 20 July 2011 00:35  |
 |
form_user1
Messages: 18
Registered: July 2011
Location: chennai
|
Junior Member |
|
|
Hi,
Im using oracle forms 10g. i want to take backup of user's table.
i.e, scott user has 4 tables. if i login as scott user and select the tables what i have to take backup using check box and click a backup button,the selected tables backup and stored in .MDB(MS Access).
How to achive this?
Thanks...
|
|
|
|
| Re: Backup table [message #516675 is a reply to message #516673] |
Wed, 20 July 2011 00:52  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
From my point of view, the simplest way would be the following: tables should already be pre-created in MS Access. In a form, you'd select tables you want to "backup". In a push button, you'd copy those tables' contents into MS Access tables. "Copy" would probably have to be "replace" (because you might violate uniqueness). See this Maaher's message which explains how to connect Oracle and MS Access.
[EDIT] Fixed invalid URL
[Updated on: Wed, 20 July 2011 03:57] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
