1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

hii guys!!

Discussion in 'Oracle' started by adroit89, Sep 7, 2007.

  1. adroit89

    adroit89 New Member

    Joined:
    Jan 5, 2007
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    0
    can any one tell me the correct syntax of the query which is used to export data from database to a file.

    EXP username/password@instance TABLES=(tablename)
    exp scott/tiger tables=emp,bonus query="where job='SALESMAN' and
    sal<1600"

    this is the query which i know.But it is not working in oracle 9i version.please help!!
     
  2. SIKO

    SIKO New Member

    Joined:
    Oct 26, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Web Application Developper
    Location:
    Mars
    exp username/password@database file=C:\expfile.dmp tables = tablename full=y >for exporting all the data in the tablename you cant specify a query in exporting data u can only specify a table and will get all the data in the table with the constraints and indexes...
     
  3. Izaan

    Izaan New Member

    Joined:
    Oct 16, 2007
    Messages:
    215
    Likes Received:
    2
    Trophy Points:
    0
    I thought this to be an Introduction threads and was about to press Alt+S to welcome adroit89.
     
  4. Nadr

    Nadr New Member

    Joined:
    Oct 16, 2007
    Messages:
    165
    Likes Received:
    1
    Trophy Points:
    0
    Its just the title.
     

Share This Page