Athena Framework
Tag Archives: Oracle
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
