快乐每一天

安装好Oracle和pl/sql后，用pl/sql连接Oracle报错弹窗，报错内容：“SQL*Net not properly installed OracleHomeKey:SOFTWARE\ORACLE”  解决方案：在PLSQL Developer选择Tools > Preferences > options > 如图所示（添加Oracle h...

[color=red][size=medium]ConnectHSQLDB.java[/size][/color][code="java"]/** * ConnectHSQLDB.java */package com.javaworkspace.connecthsqldb;import java.sql.Connection;import java.sql.Driver...

新建bat文件，复制以下内容，然后执行。[code="bat"]@echo offREMREM The script assumes that user can connect using "/ as sysdba"REMREM =================REM Restore procedureREM =================REMREM ...

新建一个bat文件，复制内容进去，双击启动.[code="cmd"]@echo offnet start OracleXETNSListener 2>nulnet start OracleServiceXE 2>nul@oradim -startup -sid XE -starttype inst > nul 2>&1[/code]...

[code="help"]D:\JAVA\DATABASE\ORACLEXE\APP\ORACLE\product\11.2.0\server\bin>impdp help=yImport: Release 11.2.0.2.0 - Production on 星期四 12月 22 17:10:30 2011Copyright (c) 1982, 2009, Oracle and/...

[code="help"]D:\JAVA\DATABASE\ORACLEXE\APP\ORACLE\product\11.2.0\server\bin>imp help=yImport: Release 11.2.0.2.0 - Production on 星期四 12月 22 17:07:59 2011Copyright (c) 1982, 2009, Oracle and/...

进入[code="sql"]D:\Java\Database\oraclexe\app\oracle\product\11.2.0\server\bin[/code]文件夹执行cmd命令[code="java"]D:\Java\Database\oraclexe\app\oracle\product\11.2.0\server\bin>IMPDP hefa/hefa d u...

[code="sql"]conn sys/password as sysdba[/code][code="sql"]call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),'/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()',8088));[/c...

[code="java"]"D:\Java\Database\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf"[/code][code="java"]SetJavaHome D:\Java\Java\jdk1.6.0_24[/code]