ORACLE表空间和导入导出

-- 创建 WEBCQ 表空间
CREATE SMALLFILE TABLESPACE "WEBCQ" DATAFILE 'D:\oracle\product\10.2.0\oradata\DZJC\WEBCQ' SIZE 1000M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;


-- 创建 WEBCQ_INDEX 表空间
CREATE SMALLFILE TABLESPACE "WEBCQ_INDEX" DATAFILE 'D:\oracle\product\10.2.0\oradata\DZJC\WEBCQ_index' SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;


-- 创建 WEBCQ_TEMP 表空间
CREATE SMALLFILE TEMPORARY TABLESPACE "WEBCQ_TEMP" TEMPFILE 'D:\oracle\product\10.2.0\oradata\DZJC\WEBCQ_temp' SIZE 250M AUTOEXTEND ON NEXT 25M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

-- 创建 WEB_CQ 用户
CREATE USER "WEBCQ" PROFILE "DEFAULT" IDENTIFIED BY "12345678" DEFAULT TABLESPACE "WEBCQ" TEMPORARY TABLESPACE "WEBCQ_TEMP" ACCOUNT UNLOCK;
GRANT "CONNECT" TO "WEBCQ" WITH ADMIN OPTION;
GRANT "DBA" TO "WEBCQ" WITH ADMIN OPTION;
---------------------------------------------------------------------

exp webcq/12345678@dzjc file=d:dzjc.dmp full=y(导出)
imp webcq/12345678@dzjc full=y  file=d:dzjc.dmp ignore=y(导入)