创建表空间
creat tablespace 表空间名 datafile ' ' size xxM autoextend on next xxM maxsize unlimited;
创建用户
create user username identified by pwd;
授予权限
grant resource,connect to user;
or
grant dba to user;
给表添加一列
alter table tablename add (列名 类型)
创建表空间
creat tablespace 表空间名 datafile ' ' size xxM autoextend on next xxM maxsize unlimited;
创建用户
create user username identified by pwd;
授予权限
grant resource,connect to user;
or
grant dba to user;
给表添加一列
alter table tablename add (列名 类型)