-
编辑 删除
虚拟列
Oracle11g支持虚拟列虚拟列是基于一个或多个实际列的表达式计算派生的，虚拟列的数据不存储在磁盘上，而是动态计算得出；可以在虚拟列上定义索引。create table emp(sal number(7,2),comm_pct number(7,2),income nu...
-
编辑 删除
PL/SQL打包
PL/SQL打包工具wrap:dbms_ddl包中有一个打包函数wrap和打包过程create_wrapped，把源代码转换成十六进制进行隐藏。wrap：打包函数，输入源码后，返回打包好的PL/SQL源代码；create_wrapped：打包过程，对输...
-
编辑 删除
Recover database using backup controlfile until cancel
What is checked or what happens when we run "recover database using backup controlfile until cancel;"? What does this command do and when do we use this command?If you were to recover the database wit...
-
编辑 删除
Where is the SCN number written?
Does the SCN number get written to the online redo log files? What are all the places where the SCN number does get written?The System Change Number (SCN) is how Oracle internally keeps track of the t...
-
编辑 删除
include current controlfile对RMAN备份的影响
include current controlfile对RMAN备份的影响1）如果controlfile autobackup设置为onbackup as compressed backupset database;备份数据文件——进行controlfile和spfile的自动备份。backup as compressed backupse...
