Oracle database Data export and import

Oracle's client has two executable files under the bin, named Exp.exe and Imp.exe, respectively.

They are used to export and import data.

Full Library

Export:exp User name/password @ database name full=y file=c:xxxx.dmp owner= database user

Import:imp user name/password @ database name full=y file=c:xxxx.dmp owner= database user

Single table

Export:exp User name/password @ database name grants=y tables=table_name file=c:xxx.dmp owner= Database user

Import:imp user name/password @ database name ignore=y file=c:xxx.dmp owner= database user

Oracle database Data export and import