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.log6、数据库定期备份expdp zh/*****@192.168.0.12:1521/orcl directory=db_dir DUMPFILE=db%date:~0,10%.DMP logfile=db%date:~0,10%.log