Oracle新建数据库
create tablespace HNNW logging datafile '\app\oratable_space\HNNW_20200114.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;
create temporary tablespace HNNW_ls
tempfile '\app\table_space\HNNW_20200114.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create user ias identified by ias
default tablespace HNNW
temporary tablespace HNNW_ls;
grant connect,resource,dba to ias;
备份数据库:
exp ias/ias@192.168.100.11:1521/PROD1 file=C:\Users\think\Desktop\拷贝\ceshi.dmp owner=ias;
还原数据库:
imp ias/ias@192.168.100.11:1521/PROD1 file=C:\Users\think\Desktop\拷贝\ias_HNNW_20200106.dmp full=y;