oracle
grant all privileges to 用戶题禀；
impdp vis/123456? dumpfile= DSM-EXPDP-20170511.DMP full=y;? //導入數(shù)據(jù)泵
expdp用戶名/密碼@實例directory=目錄dumpfile=數(shù)據(jù)泵.dmp schemas=用戶名logfile=日志.log; //導出數(shù)據(jù)泵
select* from dba_directories//查看oracle的目錄
drop tablespace orclOne including contents and datafiles cascade constraints ;//刪除表空間
drop user 用戶名 cascade;//刪除用戶包括級聯(lián)
sqlplusbdc_jh/123456!bpit@192.168.1.122/orcl//遠程連接數(shù)據(jù)庫
exp
user/password@orcl file=’path’//客戶端導出數(shù)據(jù)
imp
system/123456@ATSTestDB file=c:/export.dmp//客戶端導入數(shù)據(jù)
mysql
source?? e:\bpm20170620.sql
pg
psql –U用戶名 ? 數(shù)據(jù)庫名<數(shù)據(jù)庫文件路徑
