1、创建表空间
CREATE SMALLFILE TABLESPACE "BJZB" DATAFILE 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL10G\BJZB01' SIZE 2048M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
2、创建路径目录
create directory db_dir as 'D:\mzl\backup';
3、
建立用户
4、权限
grant read,write on directory db_dir to test;
5、导入数据库
impdp zh/sa@ORCL11g directory=db_dir DUMPFILE=zhwater2012-09-29.DMP logfile=zhwater2012-09-29.log
6、数据库定期备份
expdp zh/*****@192.168.0.12:1521/orcl directory=db_dir DUMPFILE=db%date:~0,10%.DMP logfile=db%date:~0,10%.log
oracle 建库常用命令
最新推荐文章于 2024-09-08 10:40:56 发布