Oracle creates tablespaces, authorizes, creates users, imports dmp files

Oracle creates tablespaces, authorizes, creates users, and imports dmp files, as detailed below:

1. create tablespace

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

2--create user

2. Create a LYOA user

create user LYOAidentified by LYOAdefault tablespace LYOAtemporary tablespace TEMPprofile DEFAULT;-- Grant/Revoke role privilegesgrant connect to LYOA;grant resource to LYOA;-- Grant/Revoke system privilegesgrant create database link to LYOA;grant create public database link to LYOA;grant create view to LYOA;

3 Creating KDB Users

create user KDBidentified by KDBdefault tablespace KDBtemporary tablespace TEMPprofile DEFAULT;-- Grant/Revoke role privilegesgrant connect to KDB;grant resource to KDB;

4 Authorize tables under LYOA to KDB users

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 privilegesgrant create view to KDB;grant unlimited tablespace to KDB;-- Create the usercreate user BPMidentified by BPMdefault tablespace BPMtemporary tablespace TEMPprofile DEFAULT;-- Grant/Revoke role privilegesgrant connect to BPM;grant resource to BPM;-- Grant/Revoke system privilegesgrant 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;

1. In orac data, give scott user connect resource sysdb permission to create three users

Login SYS/ AS SYSDBA

2. Log in Each user imports the table corresponding to the user

import user's table grant lyoa user dba grant dba to lyoa

imp lyoa/lyoa@localhost/orcl file=F:\lyoa.dmp full=y

3. User is not authorized. Login to SYS/ AS SYSDBA is required. sysdba authorizes password.

The above is a small series to introduce oracle create table space, authorization, create users, import dmp files, I hope to help you, if you have any questions please give me a message, small series will reply to you in time. Thank you very much for your support!