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
- iOS5
- iPhone
- PL/SQL
- parameter
- 독도
- 오라클
- 아이폰4
- 한글
- postgresql jsonb
- Managing Schema Objects
- oracle
- index
- postgresql jsonb index
- recovery
- MS-SQL
- Flashback
- tablespace
- SQLPlus
- query 잘림
- postgresql pg_stat_activity
- 아이폰
- Backup
- 윈도우
- 리눅스
- 출시일
- 갤럭시S
- 인덱스
- PostgreSQL
- 투싼
- linux