전체 글 (658) 썸네일형 리스트형 001 - [Oracle PL/SQL] Block Types 오라클 환경은 19c 입니다. 타입 블록은 아래처럼 3가지로 나누어지고 크게 2 부분으로 나눈다면 Anonymous 와 Subprograms 으로 나누어 진다. Anonymous 와 Subprograms 차이를 간단히 표현하면 아래와 같다. 간단한 Anonymous 코드는 아래와 같다. # SQL Developer 화면에서 문자 출력이 되지 않으면 아래 명령어를 실행시키면 된다. SET SERVEROUTPUT ON begin dbms_output.put_line('--------------------------------------'); dbms_output.put_line('my first anonyms block'); end; --we will do same Exercise using sql*plus.. 119 - [Oracle 19C] Backup for pluggable db and restoring Backup for pluggable db and restoring [oracle@test ~]$ rman target=/ Recovery Manager: Release 19.0.0.0.0 - Production on Wed Dec 27 17:22:28 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1680360448) RMAN> RMAN> list backup of database orclpdb; using target database control file instead of recovery ca.. 118 - [Oracle 19C] Full backup for CDB and restoring Full backup for CDB and restoring # RMAN 을 위해서는 ARCHIVELOG mode = on, configure 'fast recovery area' 할 것. 2023.12.28 - [Database/Oracle] - 116 - [Oracle 19C] Enableing ARCHIVELOG mode. 116 - [Oracle 19C] Enableing ARCHIVELOG mode. Enableing ARCHIVELOG mode. show user; show con_name; /* USER is "SYS" CON_NAME ------------------------------ CDB$ROOT */ select * from v$logfile; /* GROUP# STATUS TYP.. 117 - [Oracle 19C] Configuring fast recovery area Configuring fast recovery area show user; show con_name; /* USER is "SYS" CON_NAME ------------------------------ CDB$ROOT */ The fast recovery area is an Oracle managed directory file system, or Oracle automatic storage management disk group that provides centralized storage for backup and recovery files. The fast recovery area is usually used to store the Oracle archived redo logs, the databas.. 116 - [Oracle 19C] Enableing ARCHIVELOG mode. Enableing ARCHIVELOG mode. show user; show con_name; /* USER is "SYS" CON_NAME ------------------------------ CDB$ROOT */ select * from v$logfile; /* GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE CON_ID ---------- ------- ------- ---------------------------------------- ------------------------- ---------- 3 ONLINE /u01/app/oracle/oradata/ORCL/redo03.log NO 0 2 ONLINE /u01/app/oracle/oradata/O.. 115 - [Oracle 19C] External table with PARTITIONS External table with PARTITIONS show user show con_name /* USER is "HR" CON_NAME ------------------------------ ORCLPDB */ CREATE TABLE sales_by_country (trans_id number, trans_amount number, country varchar2(3)) PARTITION BY LIST (country) (PARTITION c1 VALUES ('USA'), PARTITION c2 VALUES ('JOR') ); /* Table SALES_BY_COUNTRY created. */ SELECT table_name, partition_name, high_value, partition_po.. 114 - [Oracle 19C] SQL*Loader express mode SQL*Loader express mode The main benefit of SQL*Loader express mode is the savings for time and effort that results from not needing to write and test a SQL*Loader control file. Instead, you specify a single SQL*Loader command with a few parameters and the load starts. Another benefit of express mode is that it will try to use the fastest mechanism for loading data files: external tables using p.. 113 - [Oracle 19C] SQL*Loader Loading Methods - Direct Path Load Direct Path Load (DIRECT=TRUE) Uses data saves (faster operation) Generates redo only under specific conditions Enforces only PRIMARY KEY, UNIQUE, and NOT NULL Does not fire INSERT triggers Does not load into clusters Prevents other users from making changes to tables during load operation show user; show con_name; /* USER is "HR" CON_NAME ------------------------------ ORCLPDB */ create table d.. 이전 1 ··· 13 14 15 16 17 18 19 ··· 83 다음
