Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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³£Óýű¾Ê¾Àý

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Êý¾Ý¿âÐ¶ÔØ²½Öè

Ð¶ÔØOracle £º
1¡¢Í£Ö¹ËùÓÐOracle·þÎñ£¬µãUniversal InstallerÐ¶ÔØ
2¡¢É¾³ý×¢²á±íÖеÄËùÓйØÓÚOracleÏî
£¨1£©ÔÚHKEY_LOCAL_MACHINE\SOFTWAREÏ£¬É¾³ýOracleĿ¼
£¨2£©ÔÚHKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\ServicesÏ£¬É¾³ýËùÓÐOracleÏî
£¨3£©ÔÚHKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\ServicesÏ£¬É¾³ýË ......

oracleϵͳ±í²éѯ

Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
¡¡¡¡1¡¢Óû§£º
¡¡¡¡¡¡select username from dba_users;
¡¡¡¡¸Ä¿ÚÁî
¡¡¡¡¡¡alter user spgroup identified by spgtest;
¡¡¡¡2¡¢±í¿Õ¼ä£º
¡¡¡¡¡¡select * from dba_data_files;
¡¡¡¡¡¡select * from dba_tablespaces;//±í¿Õ¼ä
¡¡¡¡¡¡select tablespace_name,sum(bytes), sum(b ......

°²×°ÍêÁËOracleÊý¾Ý¿â£¬¸øscottÕË»§½âËø·½·¨

    ×°ÍêÁËOracle 10gÊý¾Ý¿â£¬ÍüÁ˸øscottÕË»§½âËø¡£Õâʱ¿ÉÒÔÔÚsql plus¹¤¾ßÀ¿ªÊ¼|ËùÓгÌÐò|<Oracle-Home>|Ó¦ÓóÌÐò¿ª·¢|SQL Plus£©£¬Ò²¿ÉÒÔÔÚ¿ØÖÆÌ¨Í¨¹ýÃüÁîÐиøscottÕË»§½âËø¡£
    ÔÚµÚÒ»ÖÖÇé¿öÏ£¬ÒÔsystemÕË»§µÇ¼SQL Plus£¬È»ºóʹÓÃÃüÁî“alter user scott account unl ......

ѧϰoracleµÚÒ»ÖÜ×ܽá

    ´ÓÉÏÖÜ¿ªÊ¼£¬ÎÒÏÂÔØÁËС²¼ÀÏʦµÄ½²¿ÎÊÓÆµ£¬¿ªÊ¼ÁËѧϰORACLEµÄ¼Æ»®¡£
    ѧϰORACLEµÄÄ¿µÄ£¬Ò»·½ÃæÊÇÌá¸ß×Ô¼ºµÄ¼¼ÊõÄÜÁ¦£¬¹¤×÷ÉϾ­³£¿ÉÒÔÓõõ½£¨ËäÈ»²»ÊÇרÃÅDBAµÄ¹¤×÷£¬µ«ÊǾ­³£ÐèҪʹÓÃÊý¾Ý¿â×÷Ϊ±¨±íͳ¼Æ·ÖÎöµÄ¹¤¾ß£©£»ÁíÒ»·½Ã棬ҲÊÇÎªÌø²Û×öºÃ¼¼ÊõÄÜÁ¦µÄ´¢±¸£¬ÏÖÔڵŤ×÷ÒѾ­¿ìÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ