--表空间
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;
oracle操作
于 2024-01-09 15:35:46 首次发布