https://blog.youkuaiyun.com/let5flyingzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/let5flying/article/details/84212524https://blog.youkuaiyun.com/let5flying/article/details/84212524let5flyingThu, 03 May 2012 09:35:26 +0800https://blog.youkuaiyun.com/let5flying/article/details/84212523https://blog.youkuaiyun.com/let5flying/article/details/84212523let5flyingThu, 03 May 2012 09:33:45 +0800https://blog.youkuaiyun.com/let5flying/article/details/84212500https://blog.youkuaiyun.com/let5flying/article/details/84212500let5flyingThu, 03 May 2012 09:07:31 +0800https://blog.youkuaiyun.com/let5flying/article/details/5887006https://blog.youkuaiyun.com/let5flying/article/details/5887006let5flyingWed, 15 Sep 2010 21:56:00 +0800　　Oracle的体系太庞大了，对于初学者来说，难免会有些无从下手的感觉，什么都想学，结果什么都学不好，所以把学习经验共享一下，希望让刚刚入门的人对oracle有一个总体的认识，少走一些弯路。

一、定位

　　oracle分两大块，一块是开发，一块是管理。开发主要是写写存储过程、触发器什么的，还有就是用Oracle的Develop工具做form。有点类似于程序员，需要有较强的逻辑思维和创造能力，个人觉得会比较辛苦，是青春饭J；管理则需要对oracle数据]]>https://blog.youkuaiyun.com/let5flying/article/details/5887003https://blog.youkuaiyun.com/let5flying/article/details/5887003let5flyingWed, 15 Sep 2010 21:55:00 +0800linux下手动删除数据库实例，直接删除相应的目录就可以了，不多说了....
1. $ORACLE_HOME/dbs/
[oracle9@frogger dbs]$ pwd
/u01/app/oracle/product/9.2.0.1/dbs
[oracle9@frogger dbs]$ rm inittest02.ora
[oracle9@frogger dbs]$ rm orapwdtest02
2. $ORACLE_BASE/o]]>https://blog.youkuaiyun.com/let5flying/article/details/5886976https://blog.youkuaiyun.com/let5flying/article/details/5886976let5flyingWed, 15 Sep 2010 21:39:00 +0800--查看oracle数据库字符集：
select userenv('language') from dual;
查询结果：
SIMPLIFIED CHINESE_CHINA.AL32UTF8
--修改oracle数据库字符集：（在SQL Plus中）
sql> conn / as sysdba;
sql> shutdown immediate;

database closed.
database dis]]>https://blog.youkuaiyun.com/let5flying/article/details/5886968https://blog.youkuaiyun.com/let5flying/article/details/5886968let5flyingWed, 15 Sep 2010 21:34:00 +0800文章分类:数据库
一.资源需要：
至少1024 MB物理内存
1024－2048 需1.5倍的交互空间
2048－8192 需1倍的交互空间
8192－ 需0.75倍的交互空间
至少400 MB /tmp 临时目录空间
oracle软件需要1.5 GB 到 3.5 GB 磁盘空间
默认数据库需要1.2 GB
二.创建数据库安装的准备工]]>https://blog.youkuaiyun.com/let5flying/article/details/5886958https://blog.youkuaiyun.com/let5flying/article/details/5886958let5flyingWed, 15 Sep 2010 21:30:00 +0800linux 下手工新建数据库
手工新建数据库create database
身为DBA,要永远记住甚用或者禁止使用rm命令，万不得以的情况下，使用时在敲enter也要看了又看、慎重又慎重才行！
Red Hat Enterprise 3 + Oracle 10g Release 2
$su – oracle
1---设置系统环境变量：
ORACLE_HOME=/opt/oracle/product/10.2
ORACLE_BA]]>https://blog.youkuaiyun.com/let5flying/article/details/5886913https://blog.youkuaiyun.com/let5flying/article/details/5886913let5flyingWed, 15 Sep 2010 21:07:00 +0800Linux下安装Oracle 11 此为参照CU论坛上的高人写的文章并结合自身环境增加了点细节性的东西

操作系统 CentOS 4.2 2.6.11.8内核

安装准备

下载Oracle11安装包
内存最少1G
硬盘空间最6G
交换分区最少1024M，如果不够就用dd命令扩容一个如:

dd if=/dev/zero of=/.swap bs=1k count=1024000    ]]>https://blog.youkuaiyun.com/let5flying/article/details/4803941https://blog.youkuaiyun.com/let5flying/article/details/4803941let5flyingThu, 12 Nov 2009 19:56:00 +0800https://blog.youkuaiyun.com/let5flying/article/details/4305402https://blog.youkuaiyun.com/let5flying/article/details/4305402let5flyingSun, 28 Jun 2009 22:28:00 +0800https://blog.youkuaiyun.com/let5flying/article/details/4305349https://blog.youkuaiyun.com/let5flying/article/details/4305349let5flyingSun, 28 Jun 2009 22:02:00 +0800https://blog.youkuaiyun.com/let5flying/article/details/4298857https://blog.youkuaiyun.com/let5flying/article/details/4298857let5flyingThu, 25 Jun 2009 22:06:00 +0800https://blog.youkuaiyun.com/let5flying/article/details/4298782https://blog.youkuaiyun.com/let5flying/article/details/4298782let5flyingThu, 25 Jun 2009 21:37:00 +0800https://blog.youkuaiyun.com/let5flying/article/details/4024870https://blog.youkuaiyun.com/let5flying/article/details/4024870let5flyingWed, 25 Mar 2009 21:48:00 +0800https://blog.youkuaiyun.com/let5flying/article/details/2642849https://blog.youkuaiyun.com/let5flying/article/details/2642849let5flyingSat, 12 Jul 2008 10:13:00 +0800https://blog.youkuaiyun.com/let5flying/article/details/1855945https://blog.youkuaiyun.com/let5flying/article/details/1855945let5flyingTue, 30 Oct 2007 09:42:00 +0800https://blog.youkuaiyun.com/let5flying/article/details/1853675https://blog.youkuaiyun.com/let5flying/article/details/1853675let5flyingMon, 29 Oct 2007 09:27:00 +0800function go(formname){var url = "http://www.baidu.com/baidu";formname.method = "get";if (formname.myselectvalue.value == "1") {document.search_form1.word.value = document.search_form1.word.]]>https://blog.youkuaiyun.com/let5flying/article/details/1853656https://blog.youkuaiyun.com/let5flying/article/details/1853656let5flyingMon, 29 Oct 2007 09:18:00 +0800https://blog.youkuaiyun.com/let5flying/article/details/1828544https://blog.youkuaiyun.com/let5flying/article/details/1828544let5flyingWed, 17 Oct 2007 08:54:00 +0800 helpと入力すると，使えるサブコマンドの一覧がでます．使えるサブコマン]]>