Export from SQL Plus
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Export from SQL Plus

  1. #1
    Join Date
    Mar 2002
    Posts
    1
    Could anyone provide me with the syntax to export a database from SQLPLUS? I can not seem to locate the example that I was using. Any help would be greatly appriciated.

    Regards,
    Ben

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Say you have an open session in SQL*Plus and you want to export 2 tables: EMP & DEPT. Then type:

    Code:
    host exp userid=user/password@alias_name file=c:\junk\xxx.dmp tables=(emp,dept)
    No semi-column ( at the end!

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width