Database20 PostgreSQL Table 전체 조회 select * from pg_tables; 2013. 3. 25. ORA-00604 ERROR: ORA-00604: error occurred at recursive SQL level 2 ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","TRIGGER$SYS","sga heap","state objects") ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","unknown object","sga heap","state objects") DB를 관리하면서 다음과 같은 에러를 직면할때가 있느데 이럴 경우에는 신속하게 대처할 수 있는 방법 .. 2013. 3. 20. MySQL 예약어 Reserved Words in MySQL 5.5.27 ACCESSIBLE ADD ALL ALTER ANALYZE AND AS ASC ASENSITIVE BEFORE BETWEEN BIGINT BINARY BLOB BOTH BY CALL CASCADE CASE CHANGE CHAR CHARACTER CHECK COLLATE COLUMN CONDITION CONSTRAINT CONTITUTE CONVERT CREATE CROSS CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR DATABASE DATABASES DAY_HOUR DAY_MICROSECOND DAY_MINUTE DAY_SECOND DEC DECIMAL DECLARE DISTINC.. 2013. 3. 5. Oracle Server Start & Stop DBA로 접속 /as sysdba Oracle Server Stop > shutdown immediate Oracle Server Start > startup 2013. 2. 19. 이전 1 2 3 4 5 다음