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)"