lnxtux wrote: >what is the command for oracle database backup inside linux ? >[in to a tape /CDROM ] > >
Hmm.. you can do a backup/restore in Oracle using the export (exp) and import (imp) commands in Oracle. both 9i and 10g both have these utilities. The exported file dumps , you can copy to a tape/CDROM. These dumps you can use to transfer data from one machine to the other. Note, that however the exp/imp utilities on 9i and 10g are not compatible. It's a bit of a painful process to migrate from 9i to 10g. In case you need to export from 9i to 10g, you need to create a dump from 9i using the 10g exp/imp commands, the resultant dump from the 10g commands you can import to 10g. The reason being the dump (binary) formats are different for the 9i and 10g imp/exp commands. I am surprised that you do not have a DBA for this job .. ? You can break hell loose if you are trying to learn all these on a production server. Manu ------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/WpTY2A/izNLAA/yQLSAA/0XFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/dubailug/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
