-
编辑 删除
oracle经典博文转载
Oracle SQL优化文章https://mp.weixin.qq.com/s?__biz=MzI4NTA1MDEwNg==&mid=400845760&idx=1&sn=8c0c54f4805abec43f92110853d7ac5b&scene=2&srcid=1118AlPAl8IY6kYUN6a8GVIM&from=timeline&isappinstalled=0&key=d4b25ade3662d6436295a6f465e0cb7d8af3d240bd6676436b43b064521ee0b949b5eeb4e7e58229343d54f0d3ef0342&a...
-
编辑 删除
RECORD、VARRY、TABLE示例
<p class="MsoNormal"><br /></p><p class="MsoNormal">问题：<span lang="EN-US">varry</span>和<span lang="EN-US">table</span>类型不能对其直接查询，只能对其遍历</p><p class="MsoNormal"><span lang="EN-US"> </span></p><h2>一、<span lang="EN-US">RECORD</span>（记录）</h2><p class="MsoN...
-
编辑 删除
Oracle 外部表
<h2><span lang="EN-US">1</span>、创建<span lang="EN-US">DIRECTORY</span>，并权限授予给用户</h2><p class="MsoNormal"><span lang="EN-US">create or replace directory dmp as'/OracleBackup/backup/';</span></p><p class="MsoNormal"><span lang="EN-US">grant read,write on directory dmp to scott;</...
-
编辑 删除
Oracle 11g Dataguard（物理备库安装实验）
<h2>环境描述</h2><p>主库<span>DG1:</span></p><p><span> 192.168.10.21 dg1.zytk.com dg1</span></p><p><span> </span>数据库<span>ORACLE_SID=zytk35</span></p><p><span> ...
-
编辑 删除
Oracle 表空间迁移
<p class="MsoNormal">平台必须支持表空间迁移（<span lang="EN-US">v$transportable_platform</span>）</p><p class="MsoNormal"><span lang="EN-US">convert tablespace</span>只能在源端执行</p><p class="MsoNormal"><span lang="EN-US">convert datafile : </span>只要能连接到源端就可以</p><p class="Ms...
