Backup table [message #516673] |
Wed, 20 July 2011 00:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d41f6bfbfd7a4d7d6804255d5a0ffb90?s=64&d=mm&r=g) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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
|
|
|
|
|
|