data backup??

Discussion in 'Oracle' started by adroit89, Aug 1, 2007.

  1. adroit89

    adroit89 New Member

    Joined:
    Jan 5, 2007
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    0
    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??
     
  2. SIKO

    SIKO New Member

    Joined:
    Oct 26, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Web Application Developper
    Location:
    Mars
    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
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice