ITPub博客

主要是由于JDK版本导致的。<br /><br />根据MVN的具体版本设置正确的JDK即可。一般可用JDK1.6或者1.7

rem "aaaaaaaaaaaaaaaaaaaa"taskkill /F /FI "WINDOWTITLE EQ ctdsb"sleep 30000cd E:apache-tomcat-7.0.11binstartup.bat [@more@]rem "aaaaaaaaaaaaaaaaaaaa"taskkill /F /FI "WINDOWTITLE EQ ctdsb"sleep 30000cd E:apache-tomcat-7.0.11binstartup.bat

streams_pool_size = 10M ORA-31626: job does not existORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEMORA-06512: at "SYS.DBMS_SYS_ERROR", line 95ORA-06512: at "SYS.KUPV$FT_INT", line 798ORA-39080: failed to create queues "KUPC$C_1_20130902103057" and "KUPC$S_1_20130902103057" for Data Pump jobORA-06512: at "SYS.DBMS_SYS_ERROR", line 95ORA-06512: at "SYS.KUPC$QUE_INT", line 1530ORA-00832: no streams pool created and

grant debug connect session to db_test;[@more@]

11g 启用或关闭自动统计任务[@more@]11g启用或关闭自动统计等任务11g默认启动了三个任务，分别是统计信息收集、段指导、自动 SQL 优化，默认运行时间是周一到周五是运行4小时（22:00——次日2:00），周六日运行20小时（6:00——次日2:00）。禁用这三个任务的sql为：BEGINdbms_auto_task_admin.disable(client_name=>'auto optimizer stats collection',operation=>NULL,window_name=>NULL);dbms_auto_task_admin.disable(client_name=>'auto space advisor',operation=>NULL,window_name=>NULL);dbms_auto_task_admin.d

ORA-600 [kkopmCheckSmbUpdate:2] or [kkopmCheckSmbUpdate:3]这个错误可以确认的是oracle的缺陷。bug号是： 13555112oracle有相关的补丁出来了[@more@]DescriptionORA-600 [kkopmCheckSmbUpdate:2] or [kkopmCheckSmbUpdate:3] using plan baseline Workaround Disable the plan baseline that is used by the query. You can find out which plan baseline to disable by doing explain of the query and display its plan using /rdbms/admin/utlxpls.sql in SQLPlus Please note: The above is a summary description only. Ac

好久没有安装2005了，结果花了我2个小时。备注一下： 1. 内存最好大于1G; 2.一定要安装IIS。。。。。[@more@]sq

http://www.tianya.cn/publicforum/content/no11/1/1136654.shtml[@more@]

修改上传文件大小 <constant name="struts.multipart.saveDir" value="/tmp" /> <constant name="struts.multipart.maxSize" value="10485760" />structs.xml[@more@]

oracle bulk collects 之 java select[@more@]stmt.execute("CREATE TYPE EMPLOYEE AS OBJECT (EmpName VARCHAR2(50),EmpNo INTEGER))");stmt.execute("CREATE TYPE EMPLOYEE_LIST AS TABLE OF EMPLOYEE");stmt.execute("CREATE TABLE EMPLOYEE_TABLE (DeptName VARCHAR2(20), Employees EMPLOYEE_LIST) NESTED TABLE Employees STORE AS ntable1");stmt.execute("INSERT INTO EMPLOYEE_TABLE VALUES ("SALES", EMPLOYEE_LIST (EMPLOYEE('Susan Smith', 123), E

1. 现象： Incorrect key file for table ‘/xxxxxxxx/xxxx.MYI'; try to repair it 2.解决措施： 1）. 先停止MYSQL数据库进程； 2）. 备份整个文件。 3）. 重新启动数据库； 4）. 手工修复： check table xxx； repair table xxx；[@more@]

Windows Registry Editor Version 5.00[HKEY_CLASSES_ROOT*shellrunas]@="管理员取得所有权""NoWorkingDirectory"=""[HKEY_CLASSES_ROOT*shellrunascommand]@="cmd.exe /c takeown /f "%1" && icacls "%1" /grant administrators:F""IsolatedCommand"="cmd.exe /c takeown /f "%1" && icacls "%1" /grant administrators:F"[HKEY_CLASSES_ROOTexefileshellrunas2]@="管理员取得所有权""NoWorkingDi

ls *.txt |awk '{ print $0 }' |xargs -n1 gzip[@more@]ls *.txt |awk '{ print $0 }' |xargs -n1 gzip

To enable multipathing on RedHat Linux 5.3 By Robert Tsai on Aug 10, 2009 Set multiple cable connections per your design such as dual connections from the server to the SAN switch and then to the storage array. At Sun Solution center, we use QLogic HBA and its driver can be downloaded directly from Qlogic web site. Check the HBA used and ensure to get the correct driver. i.e. the HBA model we used is QLE2462, download its driver accordingly from below: http://driverdownloads.qlogic.com/QLogicDri

wmsys.wm_concatSELECT t.TABLE_NAME, wmsys.wm_concat(t.COLUMN_NAME) as result FROM user_tab_cols t where table_name = 'C_E_CELEVENTI_N' group by TABLE_NAME [@more@]

创建表：CREATE TABLE employees ( id INT NOT NULL, fname VARCHAR(30), lname VARCHAR(30), hired DATE NOT NULL DEFAULT '1970-01-01', separated DATE NOT NULL DEFAULT '9999-12-31', job_code INT, store_id INT)PARTITION BY LIST(store_id) ( PARTITION pNorth VALUES IN (3,5,6,9,17), PARTITION pEast VALUES IN (1,2,10,11,19,20), PARTITION pWest VALUES IN (4,12,13,14,18), PARTITION pCentral VALUES IN (7,8,15,16));[@more@]删除分区：ALTER TABLE employees DROP PARTITION pNorth ;

Oracle 用户报错：Too many processes already exist Maximum number of PROCESSES allowed per usere smitty chgsys Process startup failed, error stack:Errors in [@more@]Process startup failed, error stack:Errors in file /home/oracle/app/diag/rdbms/hbwy8/hbwy8/trace/hbwy8_psp0_602166.trc:ORA-27300: OS system dependent operation:fork failed with status: 11ORA-27301: OS failure message: Resource temporarily unavailableORA-27302: failure occurred at: skgpspawn3Mon Dec 05 14:41:52 2011Process J001 died, s

create table a(.....) compress for oltp;create table a(.....) compress for all operations;---------------------------------------------------------------压缩表不能超过255列。不能删除列，只能把列设置不null,或者不用列迁移不能被压缩.外部表、族表不能被压缩表不能包含long字段You cannot specify hybrid columnar compression on the following object-relational features: object tables, XMLType tables, columns with abstract data types, collections stored as tables, or OPAQUE types, including XMLType columns

set feedback offset trimspool onset lines 180set serveroutput on size 900000set verify offWHENEVER SQLERROR EXIT FAILURE ROLLBACK;WHENEVER OSERROR EXIT FAILURE ROLLBACK;[@more@]REM $Header: auclondb.sql 115.3 2010/10/11 09:50:58 gong noship $REMREM dbdrv: noneREM +==========================================================================+REM | Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA |REM | All rights reserved.

1、安装apache服务，安装过程中设置以下参数：Network Domain：localhostServer name：localhost安装到默认路径：C:Program FilesApache Software FoundationApache2.22、安装subversion安装到默认路径：C:Program FilesSubversion3、设置复制C:Program FilesSubversionbin下的文件mod_dav_svn.so，mod_authz_svn.so到Apache2.2/mudules/目录下复制C:Program FilesSubversionbin下所有dll文件到Apache2.2/bin目录下，如果有提示覆盖，就不要覆盖默认安装后，在apache配置文件中（在conf文件夹下，http.conf）加入以下两行：LoadModule dav