oracle創(chuàng)建表空間、授權(quán)、創(chuàng)建用戶、導(dǎo)入dmp文件

Create tablespace　bpm datafile 'D:\ORACLE11\ORADATA\ORCL\BPM.DBF' size 400M autoextend on
Create tablespace　lyoa datafile 'D:\ORACLE11\ORADATA\ORCL\LYOA.DBF' size 400M autoextend on
Create tablespace　kdb datafile 'D:\ORACLE11\ORADATA\ORCL\KDB.DBF' size 400M autoextend on

create user LYOA
identified by LYOA
default tablespace LYOA
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to LYOA;
grant resource to LYOA;
-- Grant/Revoke system privileges
grant create database link to LYOA;
grant create public database link to LYOA;
grant create view to LYOA;

create user KDB
identified by KDB
default tablespace KDB
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to KDB;
grant resource to KDB;

grant all on lyoa.oa_public_address_book to KDB;
grant all on lyoa.oa_public_address_book_group to KDB;
grant all on bpm.bpm_orgdeptlist to KDB;
grant all on bpm.bpm_orguserdeptmap to KDB;
grant all on bpm.bpm_orguserlist to KDB;
-- Grant/Revoke system privileges
grant create view to KDB;
grant unlimited tablespace to KDB;
-- Create the user
create user BPM
identified by BPM
default tablespace BPM
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to BPM;
grant resource to BPM;
-- Grant/Revoke system privileges
grant create database link to BPM;
grant create public database link to BPM;
grant create view to BPM;
grant drop public database link to BPM;
grant unlimited tablespace to BPM;
grant all on lyoa.ly_im_news_2 to bpm;
grant all on lyoa.oa_system_message to bpm;