Athena Framework
Category Archives: DB
Oracle: 扩充TableSpace语句
Step1: check current status and get all file path
SELECT
B.FILE_NAME FILENAME,
B.TABLESPACE_NAME TABLESPACENAME,
B.BYTES/1024/1024 SIZE_MB,
(B.BYTES-S
Oracle SQLs: Get system date; count user tables. etc,.
Get system date
select to_char(sysdate, ‘yyyy-mm-dd hh24:mi:ss’) from dual; — Get the formatted system date.
select sysdate from dual; — Get date
Co
Oracle SQL Developper cannot show connections view/cannot create new connection
I installed Oracle 10g XE and SQL Developper 2 in my PC, they works perfect. Yesterday, I upgrade to 11g r2 XE, after restar my PC, the SQL Developper
修改Oracle 10g XE WEB服务器端口 – Modify the Oracle XE web console server port
we need to change one port when using Oracle 10g XE and Tomcat/JBoss, because they all use the 8080 port.
It’s very easy to change the web serve
Derby 不能修改列类型 CANNOT Alert Column Data type
Derby(10.5)中不能通过Alert修改Column的DataType, 可能需要重建Column才能实现DataType的修改.
