文章列表
select t0.BG_RESPONSIBLE, count(t0.BG_BUG_ID) ammount from
(select ap.ap_property_id, b.BG_BUG_ID, b.BG_RESPONSIBLE, b.BG_DETECTION_DATE from td.audit_properties ap
left join td.audit_log al on al.AU_ACTION_ID = ap.ap_action_id
left join td.bug b on b.BG_BUG_ID = al.au_entity_id
where b.BG_DETECTIO ...
-- 查询表空间存放位置信息
select * from dba_data_files ;
-- 创建表空间
CREATE TABLESPACE jhybup
LOGGING
DATAFILE '/oracle/oradata/orcl/jhybup.dbf'
SIZE 512M AUTOEXTEND ON NEXT 32M MAXSIZE 5120M
EXTENT MANAGEMENT LOCAL;
-- 创建用户并指定表空间
CREATE USER jhybup IDENTIFIED BY jhybup
DEFAULT TABLE ...