Oracle Import and Export DMP file

Oracle Import and Export DMP file:

Open the Cmd window and, under the cmd window, enter the following corresponding commands as required by your individual:

1. IMP username/password @ NETWORK SERVICE name file=xxx.dmp fromuser=xxx touser=xxx;//Import dmp File

2. IMP username/password @ NETWORK SERVICE name file=xxx.dmp full=y;//Import DMP File

3. Imp aichannel/[email protected] full=y file= d:\data\newsmgnt.dmp ignore=y;//skip Build Table statement

4, exp system/[email protected] file=d:\daochu.dmp full=y;//export the entire database

5, exp system/[email protected] file=d:\daochu.dmp owner= (system,sys)//Export the data of the specified user

6, exp system/[email protected] file=d:\daochu.dmp tables= (table1) igonre = y;//Export the specified table (igonre optional)

7, exp aichannel/[email protected] file= d:\data\newsmgnt.dmp tables= (Inner_notify,notify_staff_relat);// Export Tables Inner_notify, Notify_staff_relat in the database

8, EXP user name/password @ NETWORK SERVICE name file=xxx.dmp tables= (table name);//Export DMP file

9, Exp user name/password @ NETWORK SERVICE name File=xxx.dmp tables= (table1,table2,table3). Export multiple DMP files

Oracle Import and Export DMP file