课程第46/47/48/49次（2017-08-27星期天上下午和2017-09-03星期天上下午）

botang

第三阶段New Feature/OCM Exam Preparation（31-49）

1. CREATE TABLE sf_demo.resumes_interim
   
2. (id NUMBER, first_name VARCHAR2(15),
   
3. last_name VARCHAR2 (40), resume BLOB  encrypt )
   
4. LOB (resume) STORE AS SECUREFILE
   
5. (TABLESPACE users
   
6. COMPRESS HIGH
   
7. DEDUPLICATE)
   
8. partition by range (id)
   
9. ( partition p1 values less than ( 15 )  ,
   
10.   partition p2 values less than (maxvalue))
    
11. /
    
12. 
    
13. pause Press [Enter] to continue...
    
14. 
    
15. /*== Perform the online redefinition ==*/
    
16. 
    
17. DECLARE
    
18. error_count PLS_INTEGER := 0;
    
19. BEGIN
    
20. 
    
21. DBMS_REDEFINITION.START_REDEF_TABLE
    
22. ('sf_demo', 'resumes', 'resumes_interim');
    
23. 
    
24. DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS
    
25. ('sf_demo', 'resumes', 'resumes_interim', NUM_ERRORS=> error_count);
    
26. 
    
27. DBMS_OUTPUT.PUT_LINE('Errors := ' || TO_CHAR(error_count));
    
28. 
    
29. DBMS_REDEFINITION.FINISH_REDEF_TABLE
    
30. ('sf_demo', 'resumes', 'resumes_interim');
    
31. 
    
32. END;
    

复制代码

DATAGUARD  OBSERVER：