Brief description of oracle expdp impdp

A brief description of oracle expdp impdp using the Data Pump expdp. impdp can import and export data on the server side, which is highly efficient without setting the environment variable NLS_LANG, by default, the database will go to the character set create directory backup as '/backup'; grant read, write on directory backup to scott; 1 Database-based export, import database a full Database Export expdp system/root directory = backup dumpfile = full. dmp logfile = full. log full = y B Import impdp system/root directory = backup dumpfile = full. dmp logfile = full2.log full = y # import data of a user. schemas specifies impdp system/root directory = backup dumpfile = full. dmp logfile = full2.log schemas = scott impdp system/root directory = backup dumpfile = full. dmp logfile = full2.log schemas = scott, gpecnew, hsj1 2 Export and Import user (schema) (for example, scott user) a exports scott user data to grant read, write on directory backup to scott; expdp scott/root directory = backup dumpfile = scott. dmp logfile = scott. log schemas = scott or expdp system/root directory = backup dumpfile = scott. dmp logfile = scott. log schemas = scott B to import data, which is easier to use with imp. Instead of creating users, you only need to create tablespaces. impdp system/root directory = backup dumpfile = scott. dmp logfile = scott2.log schemas = scott or impdp system/root directory = backup dumpfile = scott. dmp logfile = scott2.log full = y; or impdp system/root directory = backup dumpfile = scott. dmp logfile = scott2.log 3 Table-based export and import only one solution table data at a time. a export data table dept, emp expdp system/root directory = backup dumpfile = tables. dmp logfile = tables. log TABLES = scott. dept, scott. emp or expdp scott/root directory = backup dumpfile = tables. dmp logfile = tables. log TABLES = dept, emp B imports the data file into impdp scott/root directory = backup dumpfile = tables. dmp logfile = tables2.log (full = y); 4. Based on the user export table, exclude all tables starting with V and starting with Z, and exclude t_bd_person, t_bd_users a export expdp hsj/hsj directory = backup dumpfile = hsj. dmp logfile = hsj. log schemas = hsj exclude = table: \ "like \ 'v % \ '\", table: \ "like \ 'z % \", table: \ "in \ (\'t _ BD_PERSON ', \'t _ BD_USERS' \) \" or use the parfile parameter file hsj. par userid = hsj/hsj directory = backup dumpfile = hsj. dmp logfile = hsj. log schemas = hsj exclude = table: "like 'v % '", table: "like 'z %", table: "in ('t _ BD_PERSON ', 't_ BD_USERS ') "expdp parfile = hsj. import impdp hsj/hsj directory = backup dumpfile = hsj. dmp logfile = hsj2.log Description: For the include parameter, the conditions for tables starting with V or starting with Z cannot be exported. The conditions can only be and, but cannot or expdp or impdp, we need to set directory parameters. You can refer to the following two statements create directory backup as '/backup'; grant read, write on directory backup to scott;