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
Printable View
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:
No semi-column (;) at the end!Code:host exp userid=user/password@alias_name file=c:\junk\xxx.dmp tables=(emp,dept)