oracle·ÖÇø
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
¡¡¡¡ÒÔsystemÉí·ÝµÇ½Êý¾Ý¿â£¬²é¿´ v$optionÊÓͼ£¬Èç¹ûÆäÖÐPartitionΪTRUE£¬ÔòÖ§³Ö·ÖÇø¹¦ÄÜ£»·ñÔò²»Ö§³Ö¡£PartitionÓлùÓÚ·¶Î§¡¢¹þÏ£¡¢×ÛºÍÈýÖÖÀàÐÍ¡£ÎÒÃÇÓõıȽ϶àµÄÊÇ°´·¶Î§·ÖÇøµÄ±í¡£
¡¡¡¡ÎÒÃÇÒÔÒ»¸ö2001Ä꿪ʼʹÓõÄÁôÑÔ°æ×öÀý×Ó½²Êö·ÖÇø±íµÄ´´½¨ºÍʹÓãº
¡¡¡¡1 ¡¢ÒÔsystem Éí·Ý´´½¨¶ÀÁ¢µÄ±í¿Õ¼ä(´óС¿ÉÒÔ¸ù¾ÝÊý¾ÝÁ¿µÄ¶àÉÙ¶ø¶¨)
¡¡¡¡create tablespace g_2000q4 datafile '/home/oradata/oradata/test/g_2000q4.dbf' size 50M default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 1);
¡¡¡¡create tablespace g_2001q1 datafile '/home/oradata/oradata/test/g_2001q1.dbf' size 50M default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 1);
¡¡¡¡create tablespace g_2001q2 datafile '/home/oradata/oradata/test/g_2001q2.dbf' size 50M default storage (initial 100k next 100k minextents 1 maxextents unlimited pctincrease 1);
¡¡¡¡2 ¡¢ÓÃEXPORT¹¤¾ß°Ñ¾ÉÊý¾Ý±¸·ÝÔÚguestbook.dmpÖÐ
¡¡¡¡°ÑÔÀ´µÄguestbook±í¸ÄÃû
¡¡¡¡alter table guestbook rename to guestbookold;
¡¡¡¡ÒÔguestbook Éí·Ý´´½¨·ÖÇøµÄ±í
¡¡¡¡create table guestbook(
¡¡¡¡id number(16) primary key,
¡¡¡¡username varchar2(64),
¡¡¡¡sex varchar2(2),
¡¡¡¡email varchar2(256),
¡¡¡¡expression varchar2(128),
¡¡¡¡content varchar2(4000),
¡¡¡¡time date,
¡¡¡¡ip varchar2(64)
¡¡¡¡)
¡¡¡¡partition by range (time)
¡¡¡¡(partition g_2000q4 values less than (to_date('2001-01-01','yyyy-mm-dd'))
¡¡¡¡tablespace g_2000q4
¡¡¡¡storage(initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0),
¡¡¡¡partition g_2001q1 values less than (to_date('2001-04-01','yyyy-mm-dd'))
¡¡¡¡tablespace g_2001q1
¡¡¡¡storage(initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0),
¡¡¡¡partition g_2001q2 values less than (to_date('2001-07-01','yyyy-mm-dd'))
¡¡¡¡tablespace g_2001q2
¡¡¡¡storage(initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0)
¡¡¡¡);
¡¡¡¡(˵Ã÷£º·ÖÇøµÄÃû³Æ¿ÉÒԺͱí¿Õ¼äµÄÃû³Æ²»Ò
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ£¬±ØÏÈÀûÆäÆ÷¡£ÎÒÃÇ¿ªÊ¼°É£¡
¡¡¡¡Ê×ÏȽ«ORACLE 10gµÄ°²×°¹âÅÌ·ÅÈë¹âÇý£¬Èç¹û×Ô¶¯ÔËÐУ¬Ò»°ã»á³öÏÖÈçͼ1°²×°½çÃ棺
ͼ1
......
·½Ê½Ò».
Ö´ÐÐÒÔÏÂsqlÓï¾ä´´½¨database link
create database link test_link --Á´½ÓÃû
connect to Óû§Ãû identified by ÃÜÂë
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Êý¾Ý¿â·þÎ ......
Oracle´æ´¢¹ý³Ì°üº¬Èý²¿·Ö£º¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£¡£
Oracle´æ´¢¹ý³Ì¿ÉÒÔÓÐÎÞ²ÎÊý´æ´¢¹ý³ÌºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£
Ò»¡¢Î޲γÌÐò¹ý³ÌÓï·¨
1 create or replace procedure NoParPro
2 as ;
3 begin
4 ;
5 exception &nb ......