사용자 도구

사이트 도구


dbms:oracle:admin:oracletip:tablecreatedate

Table 생성시기를 알아오는 쿼리

SQL> SELECT OWNER,OBJECT_NAME,CREATED
FROM DBA_OBJECTS
WHERE CREATED > '2006-08-31' AND OWNER NOT IN ('SYS') AND OBJECT_TYPE = 'TABLE'
ORDER BY OWNER,CREATED ASC;
dbms/oracle/admin/oracletip/tablecreatedate.txt · 마지막으로 수정됨: 2007/06/22 02:14 저자 starlits