一、导出和导入数据库
运行>>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;
运行>>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;