oracle 创建测试表 t

创建测试表 t

create tablespace test datafile '/u01/app/oracle/oradata/orcl/test.dbf' size 1024m autoextend on next 10m;

create user c##test identified by test;

grant dba to c##test;

ALTER USER c##test DEFAULT TABLESPACE test;

ALTER USER c##test TEMPORARY TABLESPACE TEMP;

conn c##test/test

create table t (ID int,NAME varchar2(20));   

insert into t values(1,'ZhangSan');