数据库常用操作

--查找链接会话
SELECT  *  FROM v$session WHERE username='SCCPDB240';
--杀掉会话
ALTER SYSTEM KILL SESSION  ',';
--删除用户
drop user sccpdb240  cascade;
--重建用户
create user sccpdb240 identified by oracle default tablespace TS_TESTDB_DATA temporary tablespace temp;
--赋权限
grant connect, resource, unlimited tablespace, debug any procedure, debug connect session  to sccpdb240;
grant read,write on directory BACKUP to sccpdb240;

--导入数据库(命令行执行)
impdp sccpdb240/oracle  DIRECTORY=BACKUP   DUMPFILE=sccpdb240_data_01.dmp,sccpdb240_data_02.dmp,sccpdb240_data_03.dmp,sccpdb240_data_04.dmp FULL=y

http://blog.chinaunix.net/uid-57865-id-3907418.html