-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|