在Oracle中建表空间--用户--表--约束

在Oracle中查询数据中的表个数
一句SQL语句搞定
SELECT OWNER,COUNT(*) FROM ALL_TABLES GROUP BY OWNER;
--创建表空间
CREATE TABLESPACE "BXFUND"
LOGGING
DATAFILE 'E:\Oralce\TableSpace\BXFUND.ora' SIZE 50M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ALTER DATABASE
DATAFILE 'E:\Oralce\TableSpace\BXFUND.ora' AUTOEXTEND
ON NEXT 50M;

--创建用户
CREATE USER "TKBX" PROFILE "DEFAULT"
IDENTIFIED BY "181818" DEFAULT TABLESPACE "BXFUND"
ACCOUNT UNLOCK;
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
CONNECT,RESOURCE,CREATE SESSION TO "TKBX";
/


--创建表
create table tzdy
(
FSETCODE NUMBER(5) not null,
dftz VARCHAR2(510) not null,
tzlb VARCHAR2(5) not null
)
--添加主键约束
alter table tzdy
add primary key (FSETCODE, dftz)

--添加默认约束
alter table tzdy modify tzlb VARCHAR2(5) default 'BX';