Forum Stats

  • 3,814,861 Users
  • 2,258,920 Discussions


Sql * plus command for DataPump

jp*609096* Member Posts: 140
edited Sep 10, 2008 7:55AM in SQL & PL/SQL
hai every one,

I have a problem with exporting and importing tables..I am using pl/sql developer to export and import tables..
now because of some reasons Admin unstalled from my system...So i have to back to the sqlplus command lines*..

I haven't got -create directory privilage from the Admin..So can u specify basic import and export command and its explanations...

Thanks in advance..


  • Gurjas
    Gurjas Member Posts: 1,190

  • jp*609096*
    jp*609096* Member Posts: 140
    edited Sep 10, 2008 6:29AM
    Actually i mean for datapump export...
    any way i don't know both of thease command...(actually i having very breif idea about sql*plus commands)

    i just tried with the link what u just pointed out ...but it is not working...

    please specify me to just one table to export...just a simple command (i haven't any create directory privillage) ...


    Edited by: jp_valapad on Sep 10, 2008 3:28 AM
  • Florian W.
    Florian W. Member Posts: 1,324
    edited Sep 10, 2008 6:31AM
    Hi again!

    The problem is that if you havn't a directory to export to then you can't export. But to answer your question a simple export with expdp looks like this:

    expdp DIRECTOR=data_pump_dir DUMPFILE=mydump.dmp TABLES=hr.employees

    Edited by: user553641 on 10.09.2008 12:31
  • 388131
    388131 Member Posts: 1,819
    edited Sep 10, 2008 7:55AM
    I guess you meant to write DIRECTORY, right? ;)

    And you should have also mentioned that both, expdp and impdp respectively, are not SQL*PLUS commands but independent tools. They are invoked from the OS prompt / command line.

    Edited by: Guido on Sep 10, 2008 1:53 PM
This discussion has been closed.