- 博客(5)
- 资源 (6)
- 收藏
- 关注
原创 ENSURE_COLUMN
CREATE OR REPLACE PROCEDURE ENSURE_COLUMN(var_table_name in varchar2, var_column_name in varchar2, var_column_type in varchar2) AS IS_TABLE_EXISTS NUMBER; IS_COLUMN_EXISTS NUMBER; BEGIN SEL
2013-04-17 15:15:45 1574
转载 AWR
http://t.askmaclean.com/thread-2086-1-1.html http://t.askmaclean.com/thread-2239-1-1.html http://blog.163.com/gengzhaoyun@yeah/blog/static/80664302200981841240295/
2013-04-12 16:25:10 1748
原创 User guide - install oracle using shell
1. Prepare the prerequest. 1.1 Check your OS prerequest First of all, we need some prerequisite before the installation: A server installed linux 4 or linux 5. Require the root account and pa
2013-04-08 17:09:59 1146
原创 How to install oracle by Command Line Interface(CLI) in silent mode on Linux
1. Why silent mode? Typically, Oracle Universal Installer runs in interactive mode, which means that we need to stay before the server to wait it prompts you to provide information in graphical use
2013-04-08 17:07:17 3424
转载 ORA-01591: lock held by in-doubt distributed transaction
ORA-01591: lock held by in-doubt distributed transaction 引文档如下: 错误代码:ORA-01591 错误原因:使用了分布式事务,造成这个问题的原因很多时候都是由于网络问题造成的 解决办法: 1.找到TRAN_ID Select 'Rollback force '''||LO
2013-04-01 17:30:16 1870
shell安装oracle
2013-04-08
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人