Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ORACLE±¸·ÝÖеÄѹËõ

     ĬÈϵÄÇé¿öÏ£¬Èç¹ûûÓÐÅäÖÃѹËõ±¸·Ý£¬»òÕß±¸·ÝµÄʱºòûÓз¢³öcompressed ÃüÁÄÇôORACLE»á²ÉÓÃNULLÊý¾Ý¿éµÄѹËõ·½·¨À´±¸·ÝÊý¾Ý¿â£¬²ÉÓÃÕâÖÖ·½·¨±¸·Ý£¬ORACLE¾Í²»»á±¸·Ý´ÓδʹÓùýµÄÊý¾Ý¿é¡£ÁíÍâÒ»ÖÖ±¸·Ý¾ÍÊDzÉÓÃcompressedÃüÁîѹËõ±¸·Ý£¬²ÉÓÃÕâÖÖ·½·¨£¬ORACLE»áʹÓÃѹËõËã·¨À´±¸·ÝÊý¾Ý£¬Í¨³£»áѹËõ´óÔ¼70%¡£11gµÄ±¸·ÝÓÖÓÐÁËÌá¸ß£¬ÌرðÊǶÔÓÚUNDO±í¿Õ¼äµÄ±¸·Ý£¬ÕâÀï²»×öÌÖÂÛ£¬ÏÂÃæÀ´±È½ÏÒ»ÏÂNULLÊý¾Ý¿éµÄѹËõ±¸·ÝÓëCOMPRESSEDѹËõ±¸·Ý
RMAN> show all;
RMAN ÅäÖòÎÊýΪ:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF;   ---ûÓÐÉèÖÿØÖÆÎļþ×Ô¶¯±¸·Ý
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default  -----ûÓÐÅäÖÃCOMPRESSED
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFROBINSON.ORA'; # default
RMAN> backup database; ----ÆÕͨµÄ±¸·Ý(NULLÊý¾Ý¿éѹËõ)
Æô¶¯ backup ÓÚ 30-10ÔÂ-09
·ÖÅäµÄͨµÀ: ORA_DISK_1
ͨµÀ ORA_DISK_1: sid=147 devtype=DISK
ͨµÀ ORA_DISK_1: Æô¶¯È«²¿Êý¾ÝÎļþ±¸·Ý¼¯
ͨµÀ ORA_DISK_1: ÕýÔÚÖ¸¶¨±¸·Ý¼¯ÖеÄÊý¾ÝÎļþ
ÊäÈëÊý¾ÝÎļþ fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROBINSON\DATAFILE\O1_MF_UNDOTBS1_5CLYNO9G_.DBF
ÊäÈëÊý¾ÝÎļþ fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROBINSON\DATAFILE\O1_MF_SYSTEM_5CLYNO0Q_.DBF
ÊäÈëÊý¾ÝÎļþ fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROBINSON\DATAFILE\O1_MF_SYSAUX_5CLYNO3J_.DBF
ÊäÈëÊý¾ÝÎļþ fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\ROBINSON\DATAFILE\O1_MF_ROBINSON_5CMKM0DV_.DBF
ÊäÈëÊý¾ÝÎļþ fno=


Ïà¹ØÎĵµ£º

spring+hibernateÖд¦Àíoracle BLOB

 1¡¢ÅäÖÃhibernate£º
    1.1¡¢ÅäÖÃhibernateµÄ³Ö¾ÃÀàÎļþÖжÔÓ¦µÄ×Ö¶ÎΪbyte[]ÀàÐÍ
    2.2¡¢ÅäÖÃhibernateµÄÀàÓ³ÉäÎļþÖжÔÓ¦µÄ×Ö¶ÎtypeΪ 
            org.springframework.orm.hibernate3.support.BlobByteArray ......

Oracleѧϰ±Ê¼Çժ¼5

 Êý¾Ý¿â¶ÔÏó
<1>±í(Ô¼Êø)
<2>ÈçºÎ×Ô¶¯±àºÅ
SQLserver
  --IDENTITYÊôÐÔ
  create table test(
    xh int identity(1,2) primary key,
    name varchar(20)
);
  insert into test(name) values ('mike');
ORACLE
  Ò»¸ö¶ÔÏó(ÐòÁÐsequenc ......

Oracleѧϰ±Ê¼Çժ¼7

 ÓÃ;: <1>Ä£¿é»¯
<Àý×Ó> --¹«Ë¾µÄÔ±¹¤µÄ¹ÜÀí
         1.Ôö¼ÓÒ»¸öÔ±¹¤
         2.Ô±¹¤ÀëÖ°
Óô洢¹ý³ÌºÍº¯ÊýÀ´ÊµÏÖ
1.Ôö¼ÓÒ»¸öÔ±¹¤
create sequence seq1 start with 7935;
create or replace function insert ......

ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ

ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ
ORACLE·ÖÇø±íµÄ²Ù×÷Ó¦ÓÃ
ÕªÒª£ºÔÚ´óÁ¿ÒµÎñÊý¾Ý´¦ÀíµÄÏîÄ¿ÖУ¬¿ÉÒÔ¿¼ÂÇʹÓ÷ÖÇø±íÀ´Ìá¸ßÓ¦ÓÃϵͳµÄÐÔÄܲ¢·½±ãÊý¾Ý¹ÜÀí£¬±¾ÎÄÏêϸ½éÉÜÁË·ÖÇø±íµÄʹÓᣡ¡¡¡ ÔÚ´óÐ͵ÄÆóÒµÓ¦ÓûòÆóÒµ¼¶µÄÊý¾Ý¿âÓ¦ÓÃÖУ¬Òª´¦ÀíµÄÊý¾ÝÁ¿Í¨³£¿ÉÒÔ´ïµ½¼¸Ê®µ½¼¸°ÙGB£¬ÓеÄÉõÖÁ¿ÉÒÔµ½TB¼¶¡£ËäÈ»´æ´¢½éÖʺÍÊý¾Ý´¦Àí¼¼ÊõµÄ·¢Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ