Skip to content

Latest commit

 

History

History
27 lines (23 loc) · 1.02 KB

README.md

File metadata and controls

27 lines (23 loc) · 1.02 KB
Raw

MwMServer

#sqlplus /nolog Oracle12c创建新用户会提示公共用户名或角色无效，建议使用11g 　　SQL> conn / as sysdba;

　　SQL>create user username identified by password

　　SQL> grant dba to username;

　　SQL> conn username/password

CREATE TABLE "LOYAL"."MWM_VER" ( "APK_NAME" VARCHAR2(20 BYTE), "APK_VERSION" VARCHAR2(20 BYTE), "APK_URL" BLOB, "APK_TIME" DATE, "APK_ZT" CHAR(1 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" LOB ("APK_URL") STORE AS BASICFILE ( TABLESPACE "USERS" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;