Tag Archives: Oracle

Oracle 11 XE & JDBC

May 1, 2013 by Li Guoliang,

How to get Oracle 11 XE for Windows 64? Download the Oracle 11 XE 32 bit and install it. No problem for me ( Win7 64) Forgot the sys password, how to reset? Conn / as sysdba passw system input …

Posted in Java | Tagged , , | Leave a comment

Oracle: 扩充TableSpace语句

November 13, 2011 by Li Guoliang,

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-SUM(NVL(A.BYTES,0)))/1024/1024 USED_MB, substr((b.bytes-sum(nvl(a.bytes,0)))/(b.bytes)*100,1,5) Percentage from dba_free_space a,dba_data_files b where a.file_id=b.file_id GROUP BY B.TABLESPACE_NAME,B.FILE_NAME,B.BYTES order by b.tablespace_name; Step2: enlarge table space file alter database datafile …

Posted in Database | Tagged , | Leave a comment

Oracle SQLs: Get system date; count user tables. etc,.

October 22, 2011 by Li Guoliang,

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 Count user tables: SELECT OWNER,COUNT(*) FROM ALL_TABLES GROUP BY OWNER; — List all user and table number they own; select count(*) from dba_tables t where t.owner=’NAME’; …

Posted in Database | Tagged , | Leave a comment

Oracle SQL Developper cannot show connections view/cannot create new connection

October 15, 2011 by Li Guoliang,

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 2 cannot work: oracle.dbtools.raptor.timesten.TTAddin Failed to create addin oracle.dbtools.raptor.report.addin.ReportAddin I removed all data, …

Posted in Database | Tagged | Leave a comment

修改Oracle 10g XE WEB服务器端口 – Modify the Oracle XE web console server port

August 21, 2011 by Li Guoliang,

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 server port, just need to update some config xml file. For Oracle, we …

Posted in Database | Tagged , | Leave a comment
  • Page 1 of 2
  • 1
  • 2
  • >