ITPub博客

创建表：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

7、创建用户进入C:Program FilesApache Software FoundationApache2.2bin目录；键入命令：htpasswd -cm G:SVNRepositoryconfpasswd root 来创建用户root随后提示输入New Password和Re-type new password，当提示“Adding password for root”时表示添加成功参数c：表示创建，在第一次建用户时使用参数m：表示密码采用md5加密方式[@more@]

DIAGNOSING ORA-3113 ERRORS [ID 1020463.6][@more@]DIAGNOSING ORA-3113 ERRORS [ID 1020463.6] Modified21-OCT-2010 TypeBULLETIN StatusPUBLISHED Applies to:Oracle Server - Personal EditionOracle Server - Enterprise EditionOracle Server - Standard EditionInformation in this document applies to any platform.*** Checked for relevance on 05-Feb-2007 ****** Checked for relevance on 27-Jul-2010 ***PurposeThe ORA-3113 error is a general error reported by Oracle client tools,which signifies that they

今天生产数据库出现了几个direct path read等待事件，参考oracle文档，得知asynchronous disk operate有关，随即检查fuser /dev/async，kctune |grep aio_max_ops，show paramete disk_asynch_io 均正常。继续检查v$session_wait，发现file number 并不在dba_data_files中，据此推测此问题发生在temp tablespace中，随即检查v$sort_usage，发现出现的session，与v$session_wait中“direct path read”中的session吻合。继续检查pga的使用情况select * from v$pagstat发现，pga使用已较高（参考workarea_size_policy+pga_aggregate_target）

这个需要在安装时，安装oracle示例的程序。在10g,11g以后，都是在第三个压缩包或者companion压缩包中。安装过程就是调用mksample.sql[@more@]具体的命令示例： @?/demo/schema/mksample.sql systempwd syspwd hrpwd oepwd pmpwd ixpwd shpwd bipwd ts_example temp

oracle 10.2.0.4 windows 2003 X64 平台系统安装EMCA正常.第一次使用正常.但经过重新启动一次后,登录报下述错误:显示错误:java.util.MissingResourceException: Can't find resource for bundle oracle.sysman.db.rsc.LoginResource, key connectStringError at java.util.ResourceBundle.getObject(ResourceBundle.java:325) at java.util.ResourceBundle.getObject(ResourceBundle.java:322) at java.util.ResourceBundle.getString(ResourceBundle.java:285) at oracle.sysman.emo.adm.LoginBean.getErrMsg(LoginBean.java:416) at ora

在aix 6.1下安装oracle 11.2.0.2完成后，通过emca 配置dbconsole也正常完成。但就是https://ip:1158/em无法打开网页通过台。如果用http://ip:1158/em打开的话，就是显示“纳粹”的一个标志。后来通过多方研究，原来是ie的tsl安全选项要打开。[@more@]

==========================================ORA-39014: One or more workers have prematurely exited.ORA-39029: worker 1 with process name "DW00" prematurely terminatedORA-31671: Worker process DW00 had an unhandled exception.ORA-04030: out of process memory when trying to allocate 120048 bytes (session heap,kuxLpxAlloc)ORA-06512: at "SYS.KUPW$WORKER", line 1751ORA-06512: at line 2=========================================解决办法：1。 修改/etc/security/limits 将所有限制打开。2。

1.到oracle官网下载Oracle InstantClient,我下的是instantclient-basiclite-win32-10.2.0.4.zip,把它解压缩到oracle安装目录product下,其中还有一个目录为10.2.0.在其中的db_1/NETWORK/ADMIN目录下拷贝tnsnames.ora文件到InstantClient解压目录.2.非登录状态下进入PL/SQL developer,进入首选项,在connection中设置Oracle_Home和OCI Library,其中Oracle_Home设置为InstantClient的解压目录,OCI Library设置为该目录下的oci.dll.3.最后要设置启动PL/SQL developer的环境,在PL/SQL developer的安装目录下建立一个bat文件,文件内容如下:@echo

10.2.0.4redhat linux 5.4 Enterprise x64版本 。错误信息：Sun Apr 26 18:33:52 2009Errors in file /home/oracle/admin/mspdb/bdump/mspdb_ora_28285.trc:ORA-07445: exception encountered: core dump [kslgetl()+80] [SIGSEGV] [Address not mapped to object] [0x130] [] []ORA-00108: failed to set up dispatcher to accept connection asynchronouslySun Apr 26 18:33:55 2009found dead dispatcher 'D000', pid = (17, 84)Sun Apr 26 18:33:55 2009dispatcher 'D000' encountered error getting listening addressSun Apr 26 18:

在RedHat 5上配置了Vsftpd,一切都是没有问题,用户也可以正常登陆,但是在上传文件的时候总是提示： 553 Could not create file.的错误,百思不得其解,在网上搜了一下,原来是： Fedora Core 4缺省状态是打开selinux的,在这个状态下,vsftp会出现本地用户无法上传的问题（可能是本地用户的home目录,或者是整个目录）,错误信息为： 553 Could not create file. 要解决这个问题只要： 1. setsebool -P ftpd_disable_trans 1 2. service vsftpd restart [@more@]

答案是： ROWID顺序以下是转的测试内容：[@more@]创建一个1M的表空间：SQL> SHOW PARAMETER BLOCK_SIZENAME TYPE VALUE------------------------------------ ----------- -----------------------db_block_size integer 8192SQL> CREATE TABLESPACE TEST DATAFILE 'E:ORACLEORADATAYTK102TEST01.DBF' SIZE 1M;表空间已创建。下面建立一张表占用数据文件的大部分空间：SQL> CREATE TABLE T_TEST (ID NUMBER, NAME VARCHAR2(30)) TABLESPACE TEST2 STORAGE (INITIAL 896K);表已创建。去掉数据文件的头信息，这个数据文件只有不到1

bitandCREATE OR REPLACE FUNCTION bitor (n1 NUMBER, n2 NUMBER) RETURN NUMBER2 IS3 n1_tmp NUMBER := trunc(n1);4 n2_tmp NUMBER := trunc(n2);5 BEGIN6 RETURN n1_tmp + n2_tmp - bitand(n1_tmp, n2_tmp);7 END;8 /-----------------------------------------------------------------------CREATE OR REPLACE FUNCTION bitxor (n1 NUMBER, n2 NUMBER) RETURN NUMBER2 IS3 n1_tmp NUMBER := trunc(n1);4 n2_tmp NUMBER := trunc(n2);5 BEGIN6 RETURN n1_tmp + n2_tmp - bitand(n1_tmp, n2_tmp)*2;7 END;8 /[@more@]示例：select bitxo

select * from v$diag_info;[@more@]

环境：sqlserver 2000 on windows 2003mysql 5.在系统上配置了SQLSERVER的一个DTS包，希望定时完成：sqlserver 到 mysql的数据库同步。这个包本身可以手工执行，执行正常。但做为一个调度后，老是执行错误。检查SQLSERVER的日志。[@more@]系统日志显示“系统找不到指定的文件”错误。后经分析，发布SQLSERVER的AGENT 将一个DTS包，通过SQLSERVER的可执行程序：DTSRUN来运行。要解决上述问题，有两个办法：1。将调度所运行的命令换成WINDOWS 本身的作业计划；2。配置环境变量，使SQLSERVER agent能找到DTSRUN的程序。

mysql --socket=/tmp/mysql.sock同windows 下不一样，不需要再指定端口号了[@more@]