-
2008-08-12 16:38:15
/ Oracle开发
DELETE ClauseAn optional DELETE WHERE clause can be used to clean up after a merge operation. Only those rows which match both the ON clause and the DELETE WHERE clause are deleted.MERGE INTO test1 aUSING all_objects bON (a.object_id = b.object_id)WHEN MATCHED THENUPDATE SET a.status = b.statusWHEREb.status != 'VALID'DELETE WHERE (b.status = 'VALID');这句delete部分怎么理解?试了几次 delete 部分没测试成功[ 本帖最后由 paulyibinyi 于 2008-8-12 17:06 编辑 ]
查看(127)
评论(5)
-
2008-08-01 15:42:04
/ Oracle新技术/11g
主库:linux rh4+oracle 11.1.0.6数据文件 /oradata/asm11g复制到:windows 2003 server+oracle 11.1.0.6数据文件 f:asm11g 下简称 主库和复制库主库只需要复制密码文件 $ORACLE_HOME/dbs/orapwasm11g 到 windows $ORACLE_HOME/database/目录下并且重命名为PWDasm11g.ora现在我们做需要复制到windows 2003库的准备:在windows 2003 server F盘上 新建asm11g 目录oracle_base d:appadministratoradmin 目录下新建asm11g 目录d:appadministratoradminasm11g目录下 新建adump,dpdump,pfile 三个目录
查看(168)
评论(2)
-
2008-07-31 12:53:25
/ Oracle新技术/11g
Network-Enabled Database Duplication Without BackupsPrior to Oracle 11g, an RMAN database duplication to a different host required copies ofthe relevant backups and archived redo logs to be manually copied to the remote server.Oracle 11g allows active database duplication, so there is no need for the presence of pre-existingdatabase backups and manual copying of files.Once the DUPLICATE command is initiated, RMAN automatically performs the following steps:Copies the spfile
查看(437)
评论(10)
-
2008-07-28 15:00:44
/ Oracle数据库管理
建立的密码文件 一定要orapw+实例名吗而不允许其他命名吗我在11g和10g 测试是必须要 orapw+实例名 才能登录成功[oracle@asm dbs]$ rm orapwasm[oracle@asm dbs]$ orapwd file=orapwdasm password=abcdefg entries=10[oracle@asm dbs]$ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 26 17:24:07 2008Copyright (c) 1982, 2005, Oracle.All rights reserved.SQL> conn sys/abcdefg@asm as sysdbaERROR:ORA-01031: insufficient pr
查看(209)
评论(11)
-
2008-07-25 11:28:33
/ Oracle新技术/11g
在11g 以前,在线表定义时 其他对象比如视图和存储过程与这个表有关系的都会失效,变成invalid11g[php]CONN test/test@db11gCREATE TABLE redef_tab (idNUMBER,descriptionVARCHAR2(50),CONSTRAINT redef_tab_pk PRIMARY KEY (id));CREATE VIEW redef_tab_v ASSELECT * FROM redef_tab;CREATE SEQUENCE redef_tab_seq;CREATE OR REPLACE PROCEDURE get_description (p_idINredef_tab.id%TYPE,p_description OUT redef_tab.description%TYPE) ASBEGIN
查看(363)
评论(5)
-
2008-07-24 18:13:46
/ Oracle新技术/11g
链接:http://space.itpub.net/7199859/viewspace-409921在11g版本中,对表的操作可以进行read only 操作 来保护表的数据和表定义对表执行DML和DDl都是不允许的 对表进行只读和恢复读写用以下两个语句:ALTER TABLE table_name READ ONLY;ALTER TABLE table_name READ WRITE;以下是测试过程:DML验证会抛出ORA-12081错误[oracle@asm11g ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.1.0.6.0 - Production on Tue Jul 22 19:41:18 2008Copyright (c) 1982, 2007, Oracle.All rights reserved.C
查看(260)
评论(1)
-
2008-07-24 15:59:15
/ MS SQL Server
sqlserver 下 修改表的某个字段默认值语法是怎么样的谢谢了
查看(228)
评论(7)
-
2008-07-09 17:13:13
/ Oracle入门与认证
70道题目,90分钟我用了四十分钟,98%通过就差培训了,就可以拿到OCP证书了发贴纪念下
查看(1412)
评论(32)
-
2008-06-30 12:32:06
/ Oracle新技术/11g
自己花了一个星期第一次装好的 10g r2 rac文档 整理出来给大家共享
查看(1421)
评论(12)