创建表空间，创建用户，分配表空间，导入导出数据库；

--删除用户
--drop user KQMANAGER CASCADE;

 

--创建表空间：

CREATE TABLESPACE "KQMANAGER"
    LOGGING
    DATAFILE 'KQMANAGER.ORA' SIZE 512M
    REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;    
ALTER DATABASE
    DATAFILE 'KQMANAGER.ORA' AUTOEXTEND
    ON NEXT  16M MAXSIZE UNLIMITED;  

 

--创建用户
CREATE USER "KQMANAGER"  PROFILE "DEFAULT"
    IDENTIFIED BY "kqmanager" DEFAULT TABLESPACE "KQMANAGER"
    ACCOUNT UNLOCK;
GRANT "CONNECT" TO "KQMANAGER";
GRANT "RESOURCE" TO "KQMANAGER";

 

--用户权限
grant select on SYS.DBA_DATA_FILES to KQMANAGER;
GRANT ALTER ANY TABLE TO "KQMANAGER";
GRANT CREATE ANY INDEX TO "KQMANAGER";
GRANT CREATE ANY PROCEDURE  TO "KQMANAGER";
GRANT CREATE ANY TABLE TO "KQMANAGER";
GRANT CREATE ANY TRIGGER TO "KQMANAGER";
GRANT DELETE ANY TABLE TO "KQMANAGER";
GRANT DROP ANY INDEX TO "KQMANAGER";
GRANT DROP ANY PROCEDURE TO "KQMANAGER";
GRANT DROP ANY TABLE TO "KQMANAGER";
GRANT DROP ANY TRIGGER TO "KQMANAGER";
GRANT EXECUTE ANY PROCEDURE TO "KQMANAGER";
GRANT EXECUTE ANY TYPE TO "KQMANAGER";
GRANT INSERT ANY TABLE TO "KQMANAGER";
GRANT SELECT ANY TABLE TO "KQMANAGER";
GRANT UPDATE ANY TABLE TO "KQMANAGER";
GRANT ALTER ANY PROCEDURE TO "KQMANAGER";
GRANT Create ANY View TO "KQMANAGER";

 

--数据库导入导出步骤：
--1.exp system/system@原数据库服务连接名 file=c:\KqDatamanager.dmp log=c:\KqDatamanagerExp.log owner=(KqManager, KqService)

--3.导入 imp system/system@现数据库服务连接名 file=\KqDatamanager.dmp log=c:\KqDatamanagerImp.log fromuser=(KqManager, KqService) touser=(KqManager, KqService)