Oracle Import and Export command

Exp Upms/[email PROTECTED]:1521/ORCL File=d:\upms.log full=y

#oracle11g导入导出命令 #
EXPDP upms/[email protected]:1521/orcl directory=data_file_dir dumpfile=upms0823.dmp logfile=UPMS0823.log schemas= Upms

IMPDP sys/[email protected]:1521/orcl directory=data_file_dir dumpfile=upms0823.dmp logfile=FPMS0823.log remap_ Schema=upms:fpms

Note:

1. When Oracle deletes a user, it prompts the user to be connected and cannot be deleted:

Enter the cmd command to connect to the Oracle instance. Enter drop user sxk cascade; The following actions can occur if the connected users cannot delete:

Select username, sid, serial# from v$session where username=sxk ';

Enter ALTER system kill session ' **,** '; kill process resources;

Re-executes the delete user command. User successfully deleted.

Reference Blog : http://www.cnblogs.com/donghua2014/p/4203748.html

Oracle Import and Export command