data backup??

adroit89's Avatar
Go4Expert Member
can any one tell me how to get data back up of the data present in the data base.
for examlpe,
i am creating a table a inserting values into it.tell me how can i get a print out of the table or the data in the table.
If we cant get the print out can we atleast find the location where this table is being stored in the hard disk??
0
SIKO's Avatar, Join Date: Oct 2007
Light Poster
you can export the data into a dmp file then u need to import the data if u need to insert it in another database or to use it in the current database if lost.
To export the data to file C: backap.dmp
exp username/password@database file=C:\bacKAp.dmp tables = tablename full=y

To import the data
imp username/password@database file=C:\backAP.dmp fromuser=urusernamedatabase touser=tothenewuserdatabase ignore=y