| backup of tables's data on Cd or hard disk [message #273596] |
Thu, 11 October 2007 01:16  |
sams
Messages: 100
Registered: August 2007
|
Senior Member |
|
|
i want to take backup of one table(tables's data) of database, on hard disk or cd.i have a button "backup" on my form that should ask for backup when clicked.(it should allow to take backup on Cd)
Tell me any solution
i have no idea of backup.
thanks
|
|
|
|
|
|
|
|
| Re: backup of tables's data on Cd or hard disk [message #274002 is a reply to message #273596] |
Fri, 12 October 2007 11:19  |
sams
Messages: 100
Registered: August 2007
|
Senior Member |
|
|
but i have no idea of creating tablespace
i want to take backup of only one table not whole datbase so tablespace for only one table is allowed??/
and how to export it
plz tell me steps or procedure to follow
thanks
waiting
|
|
|
|
| Re: backup of tables's data on Cd or hard disk [message #274021 is a reply to message #274002] |
Fri, 12 October 2007 15:07 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Perhaps the easiest way would be to create an operating system executable (if on MS Windows, a simple DOS .bat file would do the job as well). All the form's push button should do is to run this script (using the HOST command).
Export part is relatively easy, unless you need something "complicated":EXP scott/tiger@db_alias TABLES=emp FILE=emp_export.dmp
Burning this file on a CD is beyond my knowledge. I know how to "copy" a file to a floppy, another hard drive, FTP it somewhere, but never burned anything from the command prompt. So, I'll leave this part to you. Perhaps you might invoke a GUI utility from Oracle form? Or, leave this part of the manual job to the user (you know - open Nero and burn this file him/herself).
Finally, saying that "you don't know anything about backup" doesn't sound very promising. After all, export is not a backup.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
