oracle 建库常用命令

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