oracle操作

Hermes333

已于 2024-01-29 09:27:51 修改

阅读量425

点赞数 11

文章标签： sql 数据库 mysql

于 2024-01-09 15:35:46 首次发布

本文链接：https://blog.csdn.net/Hermes333/article/details/135482019

版权

--表空间
create tablespace test_space
datafile '/home/oracle_data/test.db' size 100m 
autoextend on maxsize unlimited;


--用户
CREATE USER test_user IDENTIFIED BY 123456
    DEFAULT TABLESPACE test_space
    QUOTA UNLIMITED ON test_space;    

--授权
GRANT CONNECT,RESOURCE,CREATE SESSION TO test_user;
GRANT CREATE SESSION TO test_user ; 
GRANT SET CONTAINER TO test_user ; 
GRANT SELECT ON V_$DATABASE to test_user ; 
GRANT FLASHBACK ANY TABLE TO test_user ; 
GRANT SELECT ANY TABLE TO test_user ; 
GRANT SELECT_CATALOG_ROLE TO test_user ; 
GRANT EXECUTE_CATALOG_ROLE TO test_user ; 
GRANT SELECT ANY TRANSACTION TO test_user ; 
GRANT LOGMINING TO test_user ; 

GRANT CREATE TABLE TO test_user ; 
GRANT LOCK ANY TABLE TO test_user ; 
GRANT CREATE SEQUENCE TO test_user ; 

GRANT EXECUTE ON DBMS_LOGMNR TO test_user ; 
GRANT EXECUTE ON DBMS_LOGMNR_D TO test_user ; 

GRANT SELECT ON V_$LOG TO test_user ; 
GRANT SELECT ON V_$LOG_HISTORY TO test_user ; 
GRANT SELECT ON V_$LOGMNR_LOGS TO test_user ; 
GRANT SELECT ON V_$LOGMNR_CONTENTS TO test_user ; 
GRANT SELECT ON V_$LOGMNR_PARAMETERS TO test_user ; 
GRANT SELECT ON V_$LOGFILE TO test_user ; 
GRANT SELECT ON V_$ARCHIVED_LOG TO test_user ; 
GRANT SELECT ON V_$ARCHIVE_DEST_STATUS TO test_user ; 
GRANT SELECT ON V_$TRANSACTION TO test_user ; 

GRANT SELECT ON V_$MYSTAT TO test_user ; 
GRANT SELECT ON V_$STATNAME TO test_user ; 

CREATE TABLE test_user.student (
  id NUMBER,
  name VARCHAR2(32),
  description VARCHAR2(128),
  cdate TIMESTAMP,
  CONSTRAINT pk_t1 PRIMARY KEY (id) USING INDEX
) TABLESPACE test_tbs;


create sequence test_user.student increment by 1 start with 1 nomaxvalue nocycle cache 1000;

--表上启用补全日志
alter table test_user.student add supplemental log data (all) columns;