SQL> select owner, object_type, count(*) from dba_objects where owner in('SCOTT','HR','OE','PM') and object_type in('TABLE', 'VIEW', 'SEQUENCE','INDEX') group by cube(owner,object_type); OWNER OBJECT_TYPE COUNT(*) ------------------------------ ------------------- ---------- 113 VIEW 16 INDEX 57 TABLE 35 SEQUENCE 5 HR 30 HR VIEW 1 HR INDEX 19 HR TABLE 7 HR SEQUENCE 3 OE 61 OWNER OBJECT_TYPE COUN..
휴지통 비우기. S SYS> purge recyclebin; Recyclebin purged. S SYS> select * from dba_recyclebin; OWNER OBJECT_NAME ORIGINAL_NAME OPERATION ------------------------------ ------------------------------ -------------------------------- --------- TYPE TS_NAME CREATETIME DROPTIME DROPSCN ------------------------- ------------------------------ ------------------- ------------------- ---------- PARTITION_NA..
- Total
- Today
- Yesterday
- 인덱스
- parameter
- postgresql jsonb
- 오라클
- tablespace
- iPhone
- iOS5
- 독도
- 아이폰4
- 출시일
- PL/SQL
- postgresql pg_stat_activity
- index
- Managing Schema Objects
- 아이폰
- 투싼
- linux
- 리눅스
- Backup
- 윈도우
- recovery
- oracle
- SQLPlus
- query 잘림
- PostgreSQL
- MS-SQL
- postgresql jsonb index
- 갤럭시S
- Flashback
- 한글