#Oracle
---
##倒庫操作
###step1.用戶文件導出DUMP：
```sql
exp gisnres/gisnres@GIS_NEW_RES owner=gisnres file=C:\TEMP\dmp\gisnres.dmp? consistent=n feedback=10000 direct=y recordlength=65535 compress=n buffer=512000 log=C:\TEMP\dmp\log\gisnres.log
```
###step2.新建用戶
```sql
--新建用戶
create user gisnres identified by gisnres;
--授予權限
grant dba to gisnres;--賦予所有權限（需要DBA）
grant create session to gisnres;--授予登錄權限
--grant users tablespace to gisnres;--授予表空間權限
grant create table to gisnres;--建表權限
grant drop table to gisnres;--刪除表權限
grant insert table to gisnres;--插入表權限
grant update table to gisnres;--更新表權限
```
###step3.導入數(shù)據(jù)
```sql
imp gisxzy/gisxzy@GIS_NEW_RES fromuser=gisxzy touser=gisnres file=C:\TEMP\dmp\gisxzy.dmp ignore=y
```
````
CMD 命令：導出用戶下所有文件
exp gisxzy/gisxzy@GIS_NEW_RES owner=gisxzy file=C:\TEMP\dmp\gisxzy.dmp? consistent=n feedback=10000 direct=y recordlength=65535 compress=n buffer=512000 log=C:\TEMP\dmp\log\gisxzy.log
賦予權限
grant dba to gisnres;
導入到指定用戶：
````sql
imp gisxzy/gisxzy@GIS_NEW_RES fromuser=gisxzy touser=gisnres file=C:\TEMP\dmp\gisxzy.dmp ignore=y
````
