https://blog.youkuaiyun.com/SongYang_Oraclezh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6646629https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6646629SongYang_OracleSat, 30 Jul 2011 15:18:19 +0800https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6597494https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6597494SongYang_OracleMon, 11 Jul 2011 15:36:08 +0800https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6558503https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6558503SongYang_OracleTue, 21 Jun 2011 13:38:00 +0800https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6445607https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6445607SongYang_OracleWed, 25 May 2011 17:57:00 +0800最近要做一个数据库的升级工作，提前在自己的PC机上练习了一下，这种文档在网上很多，但是大多都是使用命令编辑脚本，其实数据库还有一个DBUA的升级工具可以使用，使升级工作方便了很多。
 
OS环境：windows XP 32位 PC
 
数据库版本：10.20.01
 
升级版本：10.20.05
 
操作步骤：1.备份数据库软件和数据库，因为迁移一旦失败，可以迅速恢复。
             2.使用m]]>https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6433753https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6433753SongYang_OracleFri, 20 May 2011 09:55:00 +0800https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6432305https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6432305SongYang_OracleThu, 19 May 2011 15:49:00 +0800 show parameter sga     NAME ]]>https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6432182https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6432182SongYang_OracleThu, 19 May 2011 15:08:00 +0800https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6430496https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6430496SongYang_OracleWed, 18 May 2011 20:29:00 +0800 alter user u1 account unlock;SQL> grant dba to u1;2：为u1用户创建一个默认的表空间，表空间名为u1SQL> create ta]]>https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6426982https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6426982SongYang_OracleTue, 17 May 2011 14:59:00 +0800https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6426756https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6426756SongYang_OracleTue, 17 May 2011 13:48:00 +0800https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6426712https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6426712SongYang_OracleTue, 17 May 2011 13:32:00 +0800https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6424413https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6424413SongYang_OracleMon, 16 May 2011 15:03:00 +0800https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6424329https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6424329SongYang_OracleMon, 16 May 2011 14:32:00 +0800https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6422601https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6422601SongYang_OracleSun, 15 May 2011 16:20:00 +0800https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6422588https://blog.youkuaiyun.com/SongYang_Oracle/article/details/6422588SongYang_OracleSun, 15 May 2011 16:10:00 +0800