1.创建完数据库后默认的表空间:
SYSTEM
TOOLS
TEMP
UNDOTBS
USERS
INDX
EXAMPLE2.创建用户:
create user zhao
identified by password
default tablespace accounting_tbs
quota 100M/unlimited on accounting_tbs
quota 500k on indx
temporary tablespace temptbs
profile accounting_usersgrant connect to zhao3.select *
from all_users
SYSTEM
TOOLS
TEMP
UNDOTBS
USERS
INDX
EXAMPLE2.创建用户:
create user zhao
identified by password
default tablespace accounting_tbs
quota 100M/unlimited on accounting_tbs
quota 500k on indx
temporary tablespace temptbs
profile accounting_usersgrant connect to zhao3.select *
from all_users
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货