oracle倒库操作

#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.导入数据

```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

````