- 博客(6)
- 收藏
- 关注
原创 强行更换CHARACTER SET
<br />STARTUP MOUNT;<br />ALTER SYSTEM ENABLE RESTRICTED SESSION;<br />ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;<br />ALTER SYSTEM SET AQ_TM_PROCESSES=0;<br />ALTER DATABASE OPEN;<br />ALTER DATABASE CHARACTER SET INTERNAL_USER new_character_set;<br />SHUT
2010-07-26 14:45:00
246
原创 监控硬盘剩余空间
<br /> <br />disk_status.csv<br />==============================================================<br /> <br />Date,DiskName,DiskSize,FreeSpace,<br /> <br />==============================================================<br /> <br />disk_status.vbs<br />=====
2010-06-21 10:57:00
572
原创 韩文日文正则表达式
<br />PHP中GBK和UTF8编码处理<br />一、编码范围<br />1. GBK (GB2312/GB18030)<br />/x00-/xff GBK双字节编码范围<br />/x20-/x7f ASCII<br />/xa1-/xff 中文<br />/x80-/xff 中文<br />2. UTF-8 (Unicode)<br />/u4e00-/u9fa5 (中文)<br />/x3130-/x318F (韩文<br />/xAC00-/xD7A3 (
2010-06-13 10:19:00
3442
原创 Oracle 8i Restore HotBackup
<br />orapwd file=D:/oracle/ora81/database/PWDorcl.ora password=123456 entries=10<br /> <br />svrmgrl> connect sys/pwd@orcl as sysdba<br /> <br />svrmgrl>startup mount<br /> <br />svrmgrl>recover database using backup controlfile until cancel<br /> <br />s
2010-06-08 11:41:00
314
原创 Oracle8i 创建 Standby Database 步骤
create standby database1.backup primary database datafiles2.backup primary database controlfiles alter database create standby controlfile as 'd:/standby1.ctl'3.copy primary server pfile and standby controlfile to standby server d:/oracle/admi
2010-06-07 11:54:00
449
原创 每天自动记录表空间大小及数据文件大小
<br />每天自动记录表空间大小及数据文件大小<br /> <br />在d:/db_status 创建4个文件内容如下。<br /> <br />4个文件<br />Create_CSV.BAT <br />DB_status.sql<br />DiskFile_Status.csv<br />TableSpace_Status.csv<br /> <br /> <br />Create_CSV.BAT<br />---------------------------------------------
2010-06-07 11:51:00
519
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人