建库倒库

 

创建表空间：（需要有相对应的路径d:\database\）--一体化系统表空间create tablespace LTLOBDATA01datafile 'd:\database\LTLOBDATA01.def' size 1Gautoextend on next 100M maxsize unlimited loggingextent management local autoallocatesegment space management auto;

-- 1 create user username create user bj1220 identified by "1" default tablespace LTSYSDATA01 temporary tablespace TEMP profile default account unlock;

-- 3 grant role tempuser_role to username --grant tempuser_role to username; grant comment any table to bj1220; grant create any sequence to bj1220; grant create any table to bj1220; grant create any view to bj1220; grant alter any procedure to bj1220; grant create any procedure to bj1220; grant unlimited tablespace to bj1220; grant dba to bj1220; commit

drop user 用户名 cascade;select * from v$session where username ='用户名'

drop user EFM_PORTAL_LH01 cascade;select * from v$session where username ='EFM_PORTAL_LH01'select saddr,sid,serial#,paddr,username,status from v$session where username is not null and username = 'EFM_PORTAL_LH01'alter system kill session'74,52833'

 

export.bat文件

set username=HUILAI2017set password=HUILAI2017set filename=huilai.dmpset servername=192.168.100.97/orclset cd=F:\gx\exportexp %username%/%password%@%servername% file=%cd%\%filename% log=%cd%\%username%.log

pause

import.bat文件

set username=EFM_PORTAL_GXset password=EFM_PORTAL_GXset filename=efm_portal_650205.dmpset servername=127.0.0.1/orclset cd=F:\gximp %username%/%password%@%servername% file=%cd%\%filename% full=y ignore=y buffer=40960000 commit=y

pause

 

转载于:https://www.cnblogs.com/sx2zx/p/9264570.html

相关资源：cmd操作命令和linux命令大全收集