ITPUB个人空间 »
dongyidong的个人空间
欢迎访问 dongyidong 的个人空间
我的论坛主题
-
2008-04-24 20:28:10 / Oracle开发
今天再查看views的时候发现有很多奇怪的viewVIEW_NAME------------------------------SMP_VDN_VIEW_GROUP_TARGETSMP_VDN_VIEW_GROUP_CONTENTSMP_VDN_VIEW_TARGET_LISTSMP_VIEW_REGISTRYSMP
查看(224)
评论(1)
-
2008-04-23 15:57:15 / Oracle开发
小弟请教各位高手一个问题:比如我执行这样一个query: SELECT * FROM facture ORDER BY facture_id;, 假如这个表非常大,我有没有什么办法不通过在TEMP表空间钟生成一个临时表直接得到数据啊?我觉得这样会加快速度。。。。。。谢谢各位给我点建议
查看(494)
评论(11)
-
2008-02-12 22:07:23 / Oracle入门与认证
如题,近期想去考043,SG已经看了几遍了,但是还想在看看TK,不知道看那个比较好,我这里有一份OracleActualtests1Z0_043_v03_28_07_185q.pdf,是去年的,不知道有没有用处请近期考过043的高人指点一下小弟。。。。谢谢了
查看(438)
评论(2)
-
2008-01-05 09:28:08 / Oracle数据库管理
今天又接到个作业,让写个备份脚本,各位高手给点建议:The strategy is as follows:• Every first Sunday of the month, a full backup should be made on a medium-type external DVD-ROM. (You are not asked to burn the dvd, just to create files)• A partial backup (containing all changes since the last) should be done every weekend to synchronize the base with the base auxiliary present on a second server. Be content you to backup and store it on the server, someone else takes care
查看(776)
评论(12)