전체 글 (658) 썸네일형 리스트형 88 - [Oracle 19C] Managing Storage Space Managing Storage Space Space is automatically managed by the Oracle Database server. It generates alerts about potential problems and recommends possible solutions. Oracle Managed Files (OMF) No need to bother about the file names and storage requirements. Oracle provides a unique file name. Eliminates the need for the DBA to directly manage OS files. Allows operations to be specified .. 87 - [Oracle 19C] Segments, Extents, Blocks Segments, Extents, Blocks show user /* USER is "PDB10_ADMIN" */ show con_name /* CON_NAME ------------------------------ PDB10 */ create tablespace ts1; /* Tablespace TS1 created. */ # 오라클에서 자동으로 설정되는 옵션들은 아래와 같다 SELECT DBMS_METADATA.GET_DDL('TABLESPACE','TS1') FROM dual; /* CREATE TABLESPACE "TS1" DATAFILE SIZE 104857600 AUTOEXTEND ON NEXT */ /* CREATE TABLESPACE "TS1" DATAFILE SIZE 104857600 A.. 86 - [Oracle 19C] Moving and Renaming Online Data Files Moving and Renaming Online Data Files show user /* USER is "PDB10_ADMIN" */ show con_name /* CON_NAME ------------------------------ PDB10 */ create tablespace t4 DATAFILE '/u01/app/oracle/oradata/ORCL/PDB10/t4_01.dbf' size 5m; /* Tablespace T4 created. [oracle@test PDB10]$ pwd /u01/app/oracle/oradata/ORCL/PDB10 [oracle@test PDB10]$ ll 합계 960900 drwxr-x--- 3 oracle oinstall 63 12월 11 17:07 ORCL .. 85 - [Oracle 19C] Alter tablespace and datafile Alter tablespace and datafile show user; /* USER is "PDB10_ADMIN" */ show con_name; /* CON_NAME ------------------------------ PDB10 */ [oracle@test datafile]$ pwd /u01/app/oracle/oradata/ORCL/PDB10/ORCL/0BD9769D27CD39DCE063E102A8C059FB/datafile [oracle@test datafile]$ ll 합계 102408 -rw-r----- 1 oracle oinstall 104865792 12월 11 16:05 o1_mf_t1_lqg7x03o_.dbf create tablespace t3; /* Tablespace T3 c.. 84 - [Oracle 19C] Managing tablespace using SQL developer wizard CREATE SMALLFILE TABLESPACE TS2 DATAFILE '/u01/app/oracle/oradata/ORCL/PDB10/TS2_01.DBF' SIZE 104857600 AUTOEXTEND ON DEFAULT NOCOMPRESS ONLINE SEGMENT SPACE MANAGEMENT AUTO EXTENT MANAGEMENT LOCAL AUTOALLOCATE; CREATE SMALLFILE TABLESPACE TABLESPACE_TEST DATAFILE '/u01/app/oracle/oradata/ORCL/PDB10/ORCL/TABLESPACE_TEST_01.DBF' SIZE 104857600 AUTOEXTEND ON DEFAULT NOCOMPRESS ONLINE SEGMENT SPACE.. 83 - [Oracle 19C] Create permanent tablespace - example Create permanent tablespace - example SHOW USER /* USER is "PDB10_ADMIN" */ SHOW CON_NAME /* CON_NAME ------------------------------ PDB10 */ create tablespace t1; /* 테이블 스페이스의 용도를 정하지 않으면 에러가 발생한다. Error starting at line : 15 in command - create tablespace t1 Error report - ORA-02199: missing DATAFILE/TEMPFILE clause 02199. 00000 - "missing DATAFILE/TEMPFILE clause" *Cause: A CREATE TABLESPACE .. 82 - [Oracle 19C] Helpful queries for tablespace SQL> conn pdb10_admin/Manager123#@pdb10 Connected. SQL> show user USER is "PDB10_ADMIN" SQL> show con_name CON_NAME ------------------------------ PDB10 SQL> select * from database_properties where property_name in ('GLOBAL_DB_NAME','DEFAULT_PERMANENT_TABLESPACE','DEFAULT_TEMP_TABLESPACE'); /* PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ -------------------- ----------.. 81 - [Oracle 19C] Grant PDB admin - example -- grant PDB admin -- create new PDB or choose any PDB to test SQL> show user USER is "SYS" SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL> alter session set container=pdb10; Session altered. SQL> show con_name CON_NAME ------------------------------ PDB10 SQL> grant create session, dba to pdb10_admin; Grant succeeded. -- login as pdb10_admin [oracle@test ~]$ sqlplus pdb.. 이전 1 ··· 17 18 19 20 21 22 23 ··· 83 다음
