qq_39731973的博客

CREATE TABLE USER(ID VARCHAR(32) DEFAULT SYS_GUID() PRIMARY KEY,NAME VARCHAR2(20))

oracle整理￥￥ 查看已经创建好的表空间：select default_tablespace, temporary_tablespace, d.username from dba_users d ；￥￥ 创建表空间create tablespace db_test datafile ‘D:\oracle\product\10.2.0\userdata\db_test.dbf’ size 50m autoextend on;￥￥ 查看用户select * from dba_users;￥￥