Oracle Tip

제약확인

set linesize 200
set pagesize 100
col constraint_name format a30
col table_name format a30
select constraint_name,constraint_type,table_name,status from user_constraints;

제약확인(상세)

set linesize 200
col constraint_name format a20
col table_name format a20
col column_name format a30
select
c.table_name, c.constraint_name, c.constraint_type,
cc.position, cc.column_name
from user_constraints c, user_cons_columns cc
where c.table_name = cc.table_name
and c.constraint_name = cc.constraint_name
and c.table_name = ‘UNIID_POLARIS_USER_ATTRIBUTES’
order by cc.table_name, cc.constraint_name, cc.position
;

테이블 스페이스

set linesize 200
SELECT tablespace_name, initial_extent “INITIAL”, next_extent “NEXT”, min_extents, max_extents, pct_increase, status FROM dba_tablespaces;

This entry was posted in Oracle. Bookmark the permalink.