oracle初体验

在sqlplus中创建表：create table  table_name

（col_name1 number(7,2) constraint pk_name primary key,

col_name2 varchar2(20) ,

..........);

创建表空间 create tablespace scott_tbs datafile 'E:/oracle/data/grace/01.dbf' size 100m; rem create tablespace

alter user scott default tablespace scott_tbs quota unlimited on scott_tbs; rem grant to scott

revoke unlimited tablespace from scott;rem 回收不受限表空间权限