oracle-1

1.  创建临时表空间CREATE TEMPORARY TABLESPACE test_temp TEMPFILE 'G:\app\Administrator\oradata\orcl1\test_temp.DBF' SIZE 32M AUTOEXTEND ON NEXT 32M MAXSIZE 2048M EXTENT MANAGEMENT LOCAL;2.  创建表空间CREATE TABLESPACE test_data LOGGING DATAFILE 'G:\app\Administrator\oradata\orcl1\test_data.DBF' size 32M AUTOEXTEND ON NEXT 32M MAXSIZE 1024M EXTENT MANAGEMENT LOCAL;3.  创建用户CREATE USER test IDENTIFIED BY zctech DEFAULT TABLESPACE test_data TEMPORARY TABLESPACE test_temp;4. 授权GRANT CREATE SESSION ,CREATE ANY TABLE,CREATE ANY VIEW,CREATE ANY INDEX ,CREATE ANY PROCEDURE, ALTER ANY TABLE,ALTER ANY PROCEDURE,DROP ANY TABLE ,DROP ANY VIEW,DROP ANY INDEX,DROP ANY PROCEDURE,SELECT ANY TABLE,INSERT ANY TABLE,UPDATE ANY TABLE,DELETE ANY TABLE TO test;5. 创建表CREATE TABLE "test"   ( "ID" VARCHAR2(32) NOT NULL ENABLE,  "sex" VARCHAR2(1),  "create_time" TIMESTAMP )    PCTFREE 10  PCTUSED 40  INITRANS 1  MAXTRANS 255  STORAGE( INITIAL 10485760  NEXT 1048576  MINEXTENTS 1  FREELISTS 1  FREELIST GROUPS 1  BUFFER_POOL DEFAULT )   TABLESPACE "test_data"  LOGGING "NOCOMPRESS"  " ALTER TABLE "test" MODIFY ("ID" DEFAULT sys_guid() )" " ALTER TABLE "test" MODIFY ("sex" DEFAULT '1')" " ALTER TABLE "test" MODIFY ("create_time" DEFAULT SYSDATE)"