oracle 约束改表空间,在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';