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Êý¾Ý¿â¹ÜÀíÔ±Ó¦°´ÈçÏ·½Ê½¶ÔORACLEÊý¾Ý¿âϵͳ×ö¶¨ÆÚ¼à¿Ø£º
(1). ÿÌì¶ÔORACLEÊý¾Ý¿âµÄÔËÐÐ״̬,ÈÕÖ¾Îļþ,±¸·ÝÇé¿ö,Êý¾Ý
¿âµÄ¿Õ¼äʹÓÃÇé¿ö,ϵͳ×ÊÔ´µÄʹÓÃÇé¿ö½øÐмì²é,·¢ÏÖ²¢½â¾ö
ÎÊÌâ¡£
(2). ÿÖܶÔÊý¾Ý¿â¶ ......
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 ......
racle·ÖÒ³²éѯÓï¾ä
ĬÈÏ·ÖÀà 2009-12-23 18:17 ÔĶÁ43 ÆÀÂÛ0 ×ֺţº ´ó´ó ÖÐÖРСС Oracle·ÖÒ³²éѯÓï¾ä
±¾ÎÄ×ªÔØ×Ô£ºyangtingkun.itpub.net/post/468/100278
OracleµÄ·ÖÒ³²éѯÓï¾ä»ù±¾ÉÏ¿ÉÒÔ°´ÕÕ±¾Îĸø³öµÄ¸ñʽÀ´½øÐÐÌ×Óá£
·ÖÒ³²éѯ¸ñʽ£º
sql ´úÂë
......
ÔÚÀûÓÃ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, ......
(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 ......