Home » Developer & Programmer » Forms » backup of tables's data on Cd or hard disk
backup of tables's data on Cd or hard disk [message #273596] Thu, 11 October 2007 01:16 Go to next message
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 #273609 is a reply to message #273596] Thu, 11 October 2007 01:29 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'backup' and 'export'. Try doing an 'export' via a 'host' command.

David
backup of tables's data on Cd or hard disk [message #273634 is a reply to message #273596] Thu, 11 October 2007 02:48 Go to previous messageGo to next message
chaudharyshamraiz
Messages: 4
Registered: May 2007
Location: Pakistan
Junior Member

u can do that with exporting the data
or can do it with ''create a tablespace"
firstly create a tablespace then import data in it
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 Go to previous messageGo to next message
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 Go to previous message
Littlefoot
Messages: 20900
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
For more options, type
EXP HELP=Y
on command prompt or, even better, read the Manual.

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.
Previous Topic: I don't want default alert oracle form.please help me!
Next Topic: What about Publishing my Project ??
Goto Forum:
  


Current Time: Wed Dec 07 16:27:06 CST 2016

Total time taken to generate the page: 0.18504 seconds