oracle知识点累积（20110925~）

能1979

一、导出和导入数据库
运行>>cmd
【导出】：
exp username/password file=c:\data.dmp grants=y
【导入】
imp username/password file=d:\data.dmp full=y ignore=y commit=y

二、创建表空间和授权
（可以通过SqlDev来创建用户及授权）
1、创建表空间
CREATE TABLESPACE misspace DATAFILE 'D:\oracle10g\product\10.1.0\oradata\orcl\misspace.DBF' SIZE 200M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT MANUAL FLASHBACK ON;

2、CREATE USER sx_urms IDENTIFIED BY "password"  
DEFAULT TABLESPACE misspace  
TEMPORARY TABLESPACE "TEMP"  
PROFILE DEFAULT  
QUOTA UNLIMITED ON misspace;

3、授权
GRANT UNDER ANY TABLE TO sx_urms WITH ADMIN OPTION;
GRANT UNDER ANY TYPE TO sx_urms WITH ADMIN OPTION;  
GRANT UNDER ANY VIEW TO sx_urms WITH ADMIN OPTION;   


GRANT "DBA" TO sx_urms WITH ADMIN OPTION;