create user 用户名 identified by 密码 default tablespace 缺省表空间 Temporary tablespace 临时表空间;
grant connect,resource,dba to 用户名;
revoke unlimited tablespace from 用户名;
alter user 用户名 quota 0 on Users;
alter user 用户名 quota unlimited on 用户缺省表空间;
--关键是后面3行命令，必须执行。
--接着使用IMP工具导入数据即可导入到用户缺省表空间.
--EXAMPLE: USER NAME: GROUPCMS; tablespace:GROUPCMS
--DROP USER GROUPCMS CASCADE;
create user GROUPCMS identified by ABC123 default tablespace GROUPCMS ;
grant connect,resource,dba to GROUPCMS;
revoke unlimited tablespace from GROUPCMS;
alter user GROUPCMS quota 0 on Users;
alter user GROUPCMS quota unlimited on GROUPCMS;
建表
create table <table_name>(
column_name1 column_type [not null] [check (expression)]
[default value] [primary key][references <table_name>(column_name)],
column_name2 column_type [not null] [check (expression)]
[default value] [prima ......
