oracle与mysql不同之处
常见场景
1、oracle创建一个数据库:
CREATE TABLESPACE DS_CDEG DATAFILE 'DS_CDEG.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
CREATE USER CDEG IDENTIFIED BY CDEG DEFAULT TABLESPACE DS_CDEG;
GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO CDEG identified by CDEG