Oracle安装

docker run -itd  -p 1524:1521 -p 5502:5500 -e ORACLE_SID=ORCLCDB -e ORACLE_PDB=ORCLPDB1 -e ORACLE_PWD=123456 -e ORACLE_EDITION=standard -e ORACLE_CHARACTERSET=AL32UTF8 -v C:\oracle\oradata:/opt/oracle/oradata --name orcl19c_03 registry.cn-hangzhou.aliyuncs.com/zhuyijun/oracle:19c

https://www.cnblogs.com/werr370/p/16009374.html
https://blog.csdn.net/m0_51197424/article/details/128210101

https://blog.csdn.net/arcsin_/article/details/123707618


create tablespace "XIE" datafile '/home/oracle/xie_1.dbf' size 100m;


alter user C##XIE default tablespace "XIE";

grant create session,create table,unlimited tablespace to C##XIE;


CREATE TABLESPACE TEST_DATA LOGGING DATAFILE 'TEST_DATAF.dbf' SIZE 500M
AUTOEXTEND ON NEXT  10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;

CREATE TEMPORARY TABLESPACE TEST_TEMP TEMPFILE 'TEST_TEMPF.dbf' SIZE 100M
AUTOEXTEND ON NEXT  5M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL ;

CREATE TABLESPACE TEST_INDEX LOGGING DATAFILE 'TEST_INDEXF.dbf' SIZE 100M
AUTOEXTEND ON NEXT  5M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;


CREATE USER C##TEST  PROFILE DEFAULT IDENTIFIED BY 11111111 DEFAULT TABLESPACE TEST_DATA TEMPORARY TABLESPACE TEST_TEMP ACCOUNT UNLOCK;

ALTER USER C##TEST QUOTA UNLIMITED ON TEST_DATA;

ALTER USER C##TEST QUOTA UNLIMITED ON TEST_INDEX;

GRANT CONNECT, resource TO C##TEST;