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

OracleµÄÔÚÏßÖØ¶¨Òå

Basic Steps for Manual Online Reorganization Commands and procedures used:
1.DBMS_REDEFINITION.CAN_REDEF_TABLE
2.CREATE TABLE …
3.DBMS_REDEFINITION.START_REDEF_TABLE
4.DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS and DBMS_REDEFINITION.CONS_ORIG_PAGRAMS
SELECT object_name,base_table_name,ddl_txt from DBA_REDEFINITION_ERRORS;
6.DBMS_REDEFINITION.SYNC_INTERIM_TABLE
7.DBMS_REDEFINITION.FINISH_REDEF_TABLE
8.DROP TABLE ... PURGE
1.´´½¨±í
SQL> CREATE TABLE T (ID NUMBER PRIMARY KEY, TIME DATE);
2¡¢²åÈëÊý¾Ý
SQL> INSERT INTO T SELECT ROWNUM, CREATED from DBA_OBJECTS;
SQL> COMMIT;
3¡¢ÔÚÏßÖØ¶¨ÒåµÄ±í×ÔÐÐÑéÖ¤£¬¿´¸Ã±íÊÇ·ñ¿ÉÒÔÖØ¶¨Òå
SQL> EXEC DBMS_REDEFINITION.CAN_REDEF_TABLE(user, 'T', DBMS_REDEFINITION.CONS_USE_PK);
£¨Èç¹ûûÓж¨ÒåÖ÷¼ü»áÌáʾÒÔÏ´íÎóÐÅÏ¢£©
begin dbms_redefinition.can_redef_table(user,'pft_party_profit_detail'); end;
ORA-12089: cannot online redefine table "OFSA"."PFT_PARTY_PROFIT_DETAIL" with no primary key
422ORA-06512: at "SYS.DBMS_REDEFINITION", line 8
ORA-06512: at "SYS.DBMS_REDEFINITION", line 247
ORA-06512: at line 1
³ö´íÁË£¬¸Ã±íÉÏȱÉÙÖ÷¼ü£¬Îª¸Ã±í½¨Ö÷¼ü£¬ÔÙÖ´ÐÐÑéÖ¤.
SQL> alter table t add constraint pk_t primary key(id);
Table altered.
4¡¢½¨¸öºÍÔ´±í±í½á¹¹Ò»ÑùµÄ·ÖÇø±í£¬×÷ΪÖмä±í¡£°´ÈÕÆÚ·¶Î§·ÖÇø
SQL> CREATE TABLE T_NEW
(ID NUMBER PRIMARY KEY, TIME DATE)
PARTITION BY RANGE (TIME)
   (PARTITION P1 VALUES LESS THAN (TO_DATE('2004-7-1', 'YYYY-MM-DD')),
    PARTITION P2 VALUES LESS THAN (TO_DATE('2005-1-1', 'YYYY-MM-DD')),
    PARTITION P3 VALUES LESS THAN (TO_DATE('2005-7-1', 'YYYY-MM-DD')),
    PARTITION P4 VALUES LESS THAN (MAXVALUE));
SQL> CREATE TABLE T_NEW (ID NUMBER PRIMARY KEY, TIME DATE)
PARTITION BY RANGE (TIME)
    (PARTITION P20070201 VALUES LESS THAN (TO_DATE('2007-2-1', 'YYYY-MM-DD')),
     PARTITION P20070301 VALUES LESS THAN (TO_DATE('2005-3-1', 'YYYY-MM-DD')),
   


Ïà¹ØÎĵµ£º

oracle dbaÓ¦¸Ã¶¨ÆÚ×öʲô£¡

ÔØ×ÔoracleÖÐÎļ¼ÊõÂÛ̳¡£´ÓÕûÌåÉϽéÉÜÁËÒ»¸ödbaµÄÖ°ÔðºÍÈÎÎñµÈµÈ¡£¡¡¡¡
ORACLEÊý¾Ý¿â¹ÜÀíÔ±Ó¦°´ÈçÏ·½Ê½¶ÔORACLEÊý¾Ý¿âϵͳ×ö¶¨ÆÚ¼à¿Ø£º 
(1). ÿÌì¶ÔORACLEÊý¾Ý¿âµÄÔËÐÐ״̬,ÈÕÖ¾Îļþ,±¸·ÝÇé¿ö,Êý¾Ý 
¿âµÄ¿Õ¼äʹÓÃÇé¿ö,ϵͳ×ÊÔ´µÄʹÓÃÇé¿ö½øÐмì²é,·¢ÏÖ²¢½â¾ö 
ÎÊÌâ¡£ 
(2). ÿÖܶÔÊý¾Ý¿â¶ ......

Oracle³£Óýű¾Ê¾Àý

CREATE SEQUENCE s_report_id     INCREMENT BY 1   MAXVALUE 999999    START WITH 1;  
CREATE SEQUENCE checkup_no_seq  NOCYCLE          MAXVALUE 999999    START WITH 2;
 
CRE ......

oracle·ÖÒ³

racle·ÖÒ³²éѯÓï¾ä
ĬÈÏ·ÖÀà   2009-12-23 18:17   ÔĶÁ43   ÆÀÂÛ0   ×ֺţº ´ó´ó  ÖÐÖР СС Oracle·ÖÒ³²éѯÓï¾ä
±¾ÎÄ×ªÔØ×Ô£ºyangtingkun.itpub.net/post/468/100278
OracleµÄ·ÖÒ³²éѯÓï¾ä»ù±¾ÉÏ¿ÉÒÔ°´ÕÕ±¾Îĸø³öµÄ¸ñʽÀ´½øÐÐÌ×Óá£
·ÖÒ³²éѯ¸ñʽ£º
sql ´úÂë ......

ORACLEÊý¾Ýµ¼Èë

ÔÚÀûÓÃNETWORK_LINK·½Ê½µ¼³öµÄʱºò£¬³öÏÖÁËÕâ¸ö´íÎó¡£
Ïêϸ´íÎóÐÅÏ¢ÈçÏ£º
bash-3.00$ expdp yangtk/yangtk directory=d_temp dumpfile=jiangsu.dp network_link=test113 logfile=jiangsu.log tables=cat_org
Export: Release11.1.0.6.0 - 64bit Production onÐÇÆÚ¶þ, 16 9ÔÂ, 2008 17:08:22
Copyright (c) 2003, 2007, ......

´´½¨oracle·ÃÎÊmysqlµÄÊý¾ÝÁ´Â·²½Öè

(1)µÇ½µ½mysql
C:\Documents and Settings\Administrator>mysql -h localhost -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 69
Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' fo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ