스터디북125 [10/16] 정리 OMF NAME TYPE VALUE------------------------------------ ----------- ------------------------------db_create_file_dest string 여기에 경로를 주면 create tablespace xxx 뒤에 경로가 없어도 된다 나머지 옵션은 default db_create_online_log_dest_1 stringdb_create_online_log_dest_2 stringdb_create_online_log_dest_3 stringdb_create_online_log_dest_4 stringdb_create_online_log_dest_5 string 컨트롤 파일과 리두 로그 파일의 다중화 경로 관리자가 손대기가 애매해져.. 2015. 10. 16. [10/16] 실습 - 3 resumable space allocation 참조 http://cafe.naver.com/ocmkorea/3220 ==============================DBA session================================ SYS@orcl>create tablespace resum_test 2 datafile '/u01/app/oracle/oradata/orcl/resum_test01.dbf' size 1m; Tablespace created. create user u_resum identified by oracledefault tablespace resum_testtemporary tablespace temp 4 quota unlimited on resum_test; User created. SYS@orcl>grant co.. 2015. 10. 16. [10/16] 실습 - 2 Shrink Space SYS@orcl>grant select on hr.employees to scott; Grant succeeded. SYS@orcl>conn scott/tiger;Connected.SCOTT@orcl>create table employees as select * from hr.employees; Table created. SCOTT@orcl>insert into employees select * from employees; 107 rows created. SCOTT@orcl>/ 214 rows created. SCOTT@orcl>/ 428 rows created. SCOTT@orcl>/ 856 rows created. SCOTT@orcl>/ 1712 rows created. SCOTT@orcl>/ 342.. 2015. 10. 16. [10/16] 실습 - 1 RowMigration&&chaining ======================================Row Migration====================================== SYS@orcl>create table chain_test as (select * from hr.employees); Table created. SYS@orcl>select first_name, length(first_name) 2 from chain_test; FIRST_NAME LENGTH(FIRST_NAME)-------------------- ------------------Britney 7~~~~~~~중략Timothy 7Randall 7Sarah 5 107 rows selected. SYS@orcl>analyze table chain_t.. 2015. 10. 16. 이전 1 ··· 18 19 20 21 22 23 24 ··· 32 다음