摘要:1.建立表空间, create tablespace "NETHRA" DATAFILE 'D:\DataBase\Oracle\iClass\iclass\iclass.DBF' SIZE 100M AUTOEXTEND ON NEXT 10M 2.创建用户并授权 CREATE USER "NETHRA" PROFILE "DEFAULT" IDENTIFIED BY "ne...
阅读全文
摘要:--查询死锁 select sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo, dba_objects ao, v$session s...
阅读全文
摘要:1.服务契约的定义 /* Copyright (c) 2014 HaiHui Software Co., Ltd. All rights reserved * * Create by huanglc@holworth.com at 2014-10-14 10:09:00 * */ using System; using System.Collections.Generic; usi...
阅读全文
摘要:private static byte[] CompressionObject(object DataOriginal) { if (DataOriginal == null) return null; BinaryFormatter bFormatter = new BinaryFormatter(); ...
阅读全文
摘要:CREATE PUBLIC DATABASE LINK MYDBLINK CONNECT TO RAMS IDENTIFIED BY RAMS USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.2.252)(PORT = 1521)))(CONNECT_DATA =(SID = hrarel...
阅读全文
摘要:原文 http://www.cr173.com/html/15350_1.html
阅读全文