lujiancs的专栏

下载解压了Oracle SQL Developer工具，运行时，启动不了，报错信息如下： --------------------------- Unable to create an instance of the Java Virtual Machine Located at path: \jdk\jre\bin\client\jvm.dll --------------------

ORA-12505解决 2010-09-09 22:41 在使用oracle时遇到了一个问题： ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: loca

SELECT   TABLESPACE_NAME,TO_CHAR(SUM(BYTES)/(1024*1024),'999G999D999')   CNT_MB      FROM   DBA_EXTENTS        GROUP   BY   TABLESPACE_NAME;         Select Tablespace_Name,Sum(bytes)/1024/1024 Fr

导出命令 su - oracle exp user/pwd @127.0.0.1/database file=db.dmp full=y 未完待续