-
2008-07-19 15:36:03 / Oracle数据库管理
可能标题不是很明白，我现在想做的事情是在整个数据库中，搜索每个表的每个字段内容包含“error”的内容，这个oracle能做到么？我自己想了一个办法，就是写个存储过程，就每个表的字段拼接在一起，比如select column1 || column2 || column3 ..... AS CONTENT from TESTwhere lower(content) like '%error%'然后写一个游标，遍历整个数据库的表，但是这样做，一是很慢，二是没法定位是哪个字段，只能知道是哪个表。小弟愚钝，不知道oracle有什么其他特性能做到这一点没？ 我听说过全文搜索，不知道可以实现该功能么？ 谢
查看(170)
评论(1)
-
2008-07-17 11:49:06 / Oracle数据库管理
C:Documents and Settingssupe>rman target /恢复管理器: Release 10.2.0.1.0 - Production on 星期四 7月 17 11:45:30 2008Copyright (c) 1982, 2005, Oracle.All rights reserved.RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00554: 内部恢复管理器程序包初始化失败RMAN-04005: 目标数据库中存在错误:ORA-12638: 身份证
查看(594)
评论(18)
-
2008-07-10 15:01:49 / Oracle数据库管理
The listener can do more than just listen for database requests. It can also be used to run binary executable programs on the database server and to return the output back to the caller. This functionality is referred to as external procedure support. This functionality was designed to allow command-line executables to be run from within a PL/SQL procedure. In Oracle Applications environments, this technique is commonly used.External procedure service definitions can be found in the liste
查看(158)
评论(0)
-
2008-07-09 15:37:29 / Oracle数据库管理
我在网上查到有这么一篇描述profile用法的blog我现在感到疑惑的是1.我设置了某个用户的profile之后，在哪里可以查到用户和那个profile对应2.每个用户都可以建立自己的profile吧，那存在多个profile的情况下，我如何查看这些profile设置的内容，3.如果用户使用了这个profile之后，这些profile中的限制应该就生效了吧，当前设置在哪里可以查看的到啊？ V$resource_limit？ 好像不像。create profileappl_profilelimitsessions_per_user2--cpu_per_session10000-- hun
查看(311)
评论(7)
-
2008-07-03 13:25:52 / Oracle数据库管理
小弟不是很明白，在listener上设置密码有什么用处？具体做法如下：LSNRCTL> change_passwordOld password:New password:Reenter new password:Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))Password changed for LISTENERThe command completed successfullyLSNRCTL> set passwordPassword:The command completed successfullyLSNRCTL> save_configConnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))Saved LISTENER configuration parameters.Listener Parameter File/home
查看(427)
评论(10)
-
2008-06-19 16:54:36 / Oracle数据库管理
急急急！[shang-test2:/var/10202_database_HP-Tru64/database]#uname -aOSF1 shang-test2 V5.1 2650 alpha在tru64上用root登陆之后，运行runInstaller，出现如下错误：[shang-test2:/var/10202_database_HP-Tru64/database]#./runInstallerERROR: Unable to convert from "UTF-8" to "ISO8859-1" for NLS!V5.1B, V5.1A or V5.1/var/temp/OraInstall2008-06-19_03-02-09PM.: No such file or directory请高手帮忙看看，或者提供一份安装文档，谢谢！以前从来没装过tru64上
查看(500)
评论(12)
-
2008-06-19 16:46:16 / Oracle入门与认证
[shang-test2:/var/10202_database_HP-Tru64/database]#uname -aOSF1 shang-test2 V5.1 2650 alpha在tru64上用root登陆之后，运行runInstaller，出现如下错误：[shang-test2:/var/10202_database_HP-Tru64/database]#./runInstallerERROR: Unable to convert from "UTF-8" to "ISO8859-1" for NLS!V5.1B, V5.1A or V5.1/var/temp/OraInstall2008-06-19_03-02-09PM.: No such file or directory请高手帮忙看看，或者提供一份安装文档，谢谢！以前从来没装过tru64上的oracle，不知道要注意什么！
查看(234)
评论(0)
-
2008-06-15 16:09:27 / Oracle开发
SQL> select dbms_metadata.get_ddl('TABLE','T') from dual;CREATE TABLE "SYS"."T"("X" NUMBER(*,0),"Y" DATE,"Z" CLOB,PRIM我通过sys登陆数据库想查看某个表的建表语句，但是返回结果不完整，这个是和sqlplus设置有关么？我通过pl/sql developer运行该语句，结果select dbms_metadata.get_ddl('TABLE','TEST') from dual;1请告知小弟如何查看，谢谢了！
查看(372)
评论(4)
-
2008-06-11 15:08:19 / Oracle数据库管理
本地数据库：oracle10g平台：windows具体步骤如下：create tablespace datadatafile 'C:My_applicationOracleproduct10.2.0oradataorclDATA.DBF' size 150mcreate user rman identified by rmandefault tablespace datatemporary tablespace temp ;grant resource , connect , recovery_catalog_owner to rman ;rmanconnect catalog rman/rmanRMAN> create catalog tablespace data;恢复目录数据库发生 ORACLE 错误:RMAN-00571: ==========================================================
查看(288)
评论(4)
-
2008-06-06 21:50:40 / Oracle数据库管理
我查了一下oracle官方文档，说明如下：Whenever you perform incomplete recovery or recovery with a backup control file, you must reset the online logs when you open the database. The new version of the reset database is called a new incarnation.The RESETLOGS option is always required after incomplete media recovery or recovery using a backup control file. Resetting the redo log does the following:Archives the current online redo logs (if they are accessible) and then erases the content
查看(403)
评论(8)
