- 博客(7)
- 资源 (4)
- 收藏
- 关注
原创 创建触发器跟踪用户登录
$ sqlplus " / as sysdba"SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 26 22:56:23 2006Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Ed
2006-10-26 23:19:00 1093
原创 pl/sql developer的一个BUG
-- Create tablecreate table test_tab( col1 varchar2(100), col2 varchar2(100), col3 varchar2(100));-- Create/Recreate primary, unique and foreign key constraints alter table test_tab add constrain
2006-10-26 18:24:00 1072
原创 Concept内容的翻译_1026(英语水平差,发出来主要是想让大家帮我指正一下,谢谢!)
Shared Pool The shared pool portion of the SGA contains the library cache, the dictionary cache, buffers for parallel execution messages, and control structures. 共享池是SGA的一部分,包含库缓存、数据字典缓存,用来缓存并行执行信
2006-10-26 17:25:00 846
原创 Concept内容的翻译_1024(英语水平差,发出来主要是想让大家帮我指正一下,谢谢!)
The DB_nK_CACHE_SIZE parameters cannot be used to size the cache for the standard block size. If the value of DB_BLOCK_SIZE is nK, it is illegal to set DB_nK_CACHE_SIZE. The size of the cache for the
2006-10-25 21:11:00 1010
原创 Concept内容的翻译_1025(英语水平差,发出来主要是想让大家帮我指正一下,谢谢!)
Redo Log Buffer The redo log buffer is a circular buffer in the SGA that holds information about changes made to the database. This information is stored in redo entries. Redo entries contain the i
2006-10-25 21:04:00 1443 4
原创 如何将多个表空间的数据导入到单个表空间(USER_A到USER_B)
1.USER_A的数据保存在多个表空间中,首先导出USER_A的数据: exp USER_A/PASS_A@DB_A file=USER_A_BAK.dmp log=exp_USER_A.log 2.创建用户USER_B: create user USER_B identified by "USE
2006-10-09 16:55:00 2940 1
原创 HPUNIX下设置环境变量NLS_LANG
1、使用vi编辑profile: vi .profile2、在该文件中加入:export NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK3、使用如下命令,启用环境变量配置: $ . ./.profile4、查看环境变量设置: echo $NLS_LANG
2006-10-08 14:29:00 6281 1
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人