ÔÚAIX»·¾³ÏÂΪOracle¡¢sybase ʹÓÃÂãÉ豸 ¼¯ÖÐÌÖÂÛ35
¡¶oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/unixÉϵÄʵսÏê½â¡·¼¯ÖÐÌÖÂÛ35£ºÔÚAIX»·¾³ÏÂΪOracle¡¢sybase ʹÓÃÂãÉ豸 ÎÄƽ ÂãÉ豸ÊÂÒ»ÖÖÔÚUNIXϳ£ÓõÄÊý¾Ý¿âÊý¾Ý´æ´¢·½Ê½,ÔÚAIXÖÐÈç´Ë,ÔÚHP-UX\SCO UNIXµÈϵͳÖнÔÊÇÈç´Ë¡£Õâ¶ÎʱÆÚÒÔÀ´Ò»Ö±ÓÐͬ־ÃÇÓʼþѯÎÊÈçºÎʹÓÃÂãÉ豸¡£ÕâÀïÎÒ»ã×ÜһЩAIXÏÂÂãÉ豸µÄʹÓÃÎÊÌâ¡£ ÔÚAIXÖУ¬ÂãÉ豸ÊÇÒ»ÖÖδ´´½¨ÎļþϵͳµÄÂß¼¾íLV£¬ÔÚAIXÏÂͨ¹ýmklv´´½¨£¬ÔÚHP-UXÖС¢LinuxÖеÈͨ¹ýlvcreateµÈÃüÁî´´½¨¡£ÏÂÃæÎÒÃÇ»ã×ÜÒ»ÏÂAIXÂãÉ豸µÄʹÓÃÎÊÌâ¡£ 1£ºmklv ÃüÁîµÄʹÓãº
Creates a logical volume.
Óï·¨:
mklv [ -a Position ] [ -b BadBlocks ] [ -c Copies ] [ -d Schedule ] [ -e Range ][ -i ] [ -L Label ] [ -m MapFile ] [ -o Y / N
] [ -r Relocate ] [ -s Strict ] [-t Type ] [ -u UpperBound ] [ -v Verify ] [ -w MirrorWriteConsistency ] [ -xMaximum ] [ -y
NewLogicalVolume | -Y Prefix ] [ -S StripeSize ] [ -U Userid ] [-G Groupid ] [ -P Modes ] VolumeGroup Number [ PhysicalVolume
... ] ÀýÈ磬ÎÒÃÇΪsybaseÓû§´´½¨Ò»¸öÂß¼¾í£¬ÓÃÓÚsybaseµÄÊý¾Ý¿âÉ豸£º
mklv -t 'raw' -y 'lv_csystem ' -U sybase -G sybase datavg 1 hdisk2 ÆäÖк¬ÒåÊÇ£¬ÔÚdatavg¾í×éÉϵÄhdisk2ÅÌÉÏ´´½¨1¸öPP´óСµÄÂß¼¾ílv_system
ÔÚsybaseÖУ¬ÎÒÃÇÔÚisqlÖд´½¨¶ÔÓ¦µÄÉ߾ݿâÉ豸£º disk init name=device1 phyname=¡±/dev/lv_system¡± ¡ ¡ Èç¹ûÊÇoracleÊý¾Ý¿â£¬Ôò¿ÉÒÔÔÚsqlplus »òÕßͼÐνçÃ潨Á¢±í¿Õ¼ä¼´¿É£º
CREATE TABLESPACE "data"
LOGGING
DATAFILE ¡®/dev/lv_system¡¯ SIZE 60M REUSE EXTENT MANAGEMENT LOCAL SEGMENT SPACE
MANAGEMENT AUTO ÔõôÑù£¬±È½Ï¼òµ¥£¿
Ïà¹ØÎĵµ£º
ÔÚoracleÖУ¬ÓÐ4¸ö´ó¶ÔÏó£¨lobs£©ÀàÐÍ¿ÉÓ㬷ֱðÊÇblob,clob,bfile,nclob¡£
¡¡¡¡ÏÂÃæÊǶÔlobÊý¾ÝÀàÐ͵ļòµ¥½éÉÜ¡£
¡¡¡¡ blob:¶þ½øÖÆlob£¬Îª¶þ½øÖÆÊý¾Ý£¬×¿É´ï4GB£¬´æÖüÔÚÊý¾Ý¿âÖС£
¡¡¡¡ clob:×Ö·ûlob,×Ö·ûÊý¾Ý,×¿ÉÒÔ´ïµ½4GB,´æÖüÔÚÊý¾Ý¿âÖС£
¡¡¡¡ bfile:¶þ½øÖÆÎļþ;´æÖüÔÚÊý¾Ý¿âÖ®ÍâµÄÖ»¶ÁÐͶþ½øÖÆÊý¾Ý£¬×î´ó³¤ ......
oracleÌṩÈýÖָ߼¶±¸·Ý¹¦ÄÜ
¸ß¼¶¸´ÖÆ£¨Advanced Replication£©
Á÷¸´ÖÆ£¨Streams Replication£©
±¸¿â£¨Dataguard£©
Ò» dataguard£º
dataguardÔڸ߿ÉÓü°ÈÝÔÖ·½ÃæÒ»°ãÊÇdbaµÄÊ×Ñ¡£¬²»¹ÜÊÇÎïÀí±¸Óÿ⣨physical standby database£©»¹ÊÇÂß¼±¸Óÿ⣨logical standby database£©£¬ËüÃǶ¼¾ßÓÐһЩ¹²Í¬µÄ´ýÕ÷¡£
ÅäÖú͹ÜÀí· ......
·ÖÇø±í¡¢·ÖÇøË÷ÒýºÍÈ«¾ÖË÷Òý£º
ÔÚÒ»¸ö±íµÄÊý¾Ý³¬¹ý¹ý2000ÍòÌõ»òÕ¼ÓÃ2G¿Õ¼äʱ£¬½¨Ò齨Á¢·ÖÇø±í¡£
create table ta(c1 int,c2 varchar2(16),c3 varchar2(64),c4 int constraint pk_ta primary key (c1)) partition by range(c1)(partition p1 values less than (10000000),partition p2 values less than (20000000),part ......
SELECT UPPER(F.TABLESPACE_NAME) "±í¿Õ¼äÃû",
D.TOT_GROOTTE_MB "±í¿Õ¼ä´óС(M)",
D.TOT_GROOTTE_MB - F.TOTAL_BYTES "ÒÑʹÓÿռä(M)",
TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_G ......
package test;
import java.text.SimpleDateFormat;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;
import po.Stu;
public class Insert1 {
/**
* @param args
*/
public ......