Oracle database Import and Export data

One. Export
1. Export the entire Database General Command: EXP database username/Database Password @ database alias file=e:\ directory \ file name. dmp
Example: Exp gwyxgldb/gwyxgldb @192.168.0.31 file=d:\gwyxgldb.dmp

2. Export partial Table general commands
EXP database username/Database Password @ Database alias grants=y tabes= (table 1 to export, table 2 to export,...) file=e:\ directory \ filename. dmp

Exp gwyxgldb/gwyxgldb @192.168.0.31 grants=y tables= (outbox,s_dict) file=d:\jlwater.dmp



Two. Import
IMP Import library user name/import library password @ Import library alias file=e:\ directory \ filename. dmp fromuser=dmp file Export Library touser=dmp file import library
Example: Imp jlwater/[email protected] file=d:\jlwater.dmp fromuser=gwyxgldb Touser=jlwater