![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle and Sql server Database
文章平均质量分 65
chenyujin999
这个作者很懒,什么都没留下…
展开
-
RMAN Recipe Note 1
There are two types of restore points—normal and guaranteed create restore point rp1; flashback database to rp1; create guaranteed restore point rp1; -----------原创 2013-10-10 14:46:58 · 942 阅读 · 0 评论 -
RAC Tutorial
Tips: there are at most five OCR files/devices. #./osrcheck #./ocrdump -stdout -keyname SYSTEM.css/database.css #./ocrdump /home/RAC #crsctl query css votedisk #./ocrconfig check #cl原创 2013-10-15 11:52:50 · 500 阅读 · 0 评论 -
RMAN Tutorial Series
select table_name from dict where TABLE_NAME like "%SGA%" select * from V$SGAINFO; RMAN 脚本类型: 1:RMAN脚本 @bak_user-schem.rman or rman @bak_user-schem.rman or rman cmdfile=bak_user-schem.rman原创 2013-10-22 10:48:09 · 854 阅读 · 0 评论 -
RMAN Backup For RAC
For data files, it is ok to backup on any RAC node as they are shared by RAC instances; If parameter files are not in the same place, it should be paid attention to. If control files are not原创 2013-10-22 17:11:05 · 581 阅读 · 0 评论 -
PLS-1: Introduction to Oracle PL/SQL ended@T8
The PL/SQL and sql share the same variable type; Script could run across the different OS platform APEX libarary provided by oracle There is a constant keyword for pl/sql like c_tax=constan原创 2013-10-31 18:41:38 · 1202 阅读 · 0 评论 -
PLS-9-12 Oracle PL/SQL
retreving data using select statement v_sal emp.sal%TYPE select ename, sal infor v_name, v_sal from emp which only stores just 1 record; it also has a implicit cursor created by oracle also will原创 2013-11-01 00:56:20 · 767 阅读 · 0 评论 -
PLS-2--25Using Parameters in PL/SQL Procedure
PLS-21:PL/SQL Stored Procedure(PLS-21) Stored program includes procedure, function and package have a name;can take and return parameters;can be stored in database; all users can call. Adv原创 2013-11-01 14:59:35 · 825 阅读 · 0 评论