Database/Oracle (118) 썸네일형 리스트형 111 - [Oracle 19C] SQL Loader - discard file example SQL loader Discard file Discard file: The discard file contains rows that were discarded because they were filtered out because of a statement in the SQL*Loader control file ( when clause ) show user; show con_name; /* USER is "HR" CON_NAME ------------------------------ ORCLPDB */ CREATE TABLE EMP_LOAD (EMPNO NUMBER , FNAME VARCHAR2(100), LNAME VARCHAR2(100) ); /* Table EMP_LOAD created. */ SEL.. 110 - [Oracle 19C] Moving data from PDB to PDB 이전에 이미 만들었던 디비를 이용해서 데이터 이관에 대해서 테스트 합니다. 디비가 없어서 새로만들어야 한다면 아래 링크를 참고하세요 2023.12.01 - [Database/Oracle] - 62 - [Oracle 19C] DB Link 62 - [Oracle 19C] DB Link DATABASE LINK • A database link is a schema object in one database that enables you to access objects on another database. • The other database need not be an Oracle Database system. However, to access non-Oracle systems you must use Oracl.. 109 - [Oracle 19C] External Table - ORACLE_DATAPUMP external table using ORACLE_DATAPUMP show user; show con_name; /* USER is "HR" CON_NAME ------------------------------ ORCLPDB */ # method 1 # create external table that create .dmp file from select statement # 테이블이 만들어지는 순서, select >> EMP.dmp >> create table EMP_pump. # 테이블의 데이터 타입이 없는 이유는 해당 데이터 타입은 select 문의 데이터 타입에 의해서 정해짐. cREATE TABLE EMP_pump (EMPLOYEE_NUMBER , FNAME , LNAME ) ORGANIZATIO.. 108 - [Oracle 19C] External Table - ORACLE_LOADER -now we will learn how to create external tables -external table is read only table whose metadata is stored in the Db, -but whose data is stored outside the db. -no DML allowed, no indexes can be created on external tables -you can access the data with 2 methods (oracle_loader or oracle_datapump ) -to read external data, first you need to create directory in the database conn sqlplus sys as sys.. 107 - [Oracle 19C] How to use SQL*Loader # we will learn the sql loader # SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database # move the file emp.csv to server /u01/app/oracle show user show con_name /* USER is "HR" CON_NAME ------------------------------ ORCLPDB */ CREATE TABLE EMP_LOAD (EMPNO NUMBER , FNAME VARCHAR2(100), LNAME VARCHAR2(100) ); /* Table EMP_LOAD created. */ SELECT * F.. 106 - [Oracle 19C] Automatic Tuning of Undo Retention, example Automatic Tuning of Undo Retention Oracle Database automatically tunes the undo retention period based on how the undo tablespace is configured. If the undo tablespace is configured with the AUTOEXTEND option, the database dynamically tunes the undo retention period to be somewhat longer than the longest-running active query on the system. However, this retention period may be insufficient to ac.. 105 - [Oracle 19C] Flashback table and Flashback Version Query show user show con_name /* USER is "HR" CON_NAME ------------------------------ ORCLPDB */ select * from employees; /* EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL ----------- -------------------- ------------------------- -------------- 198 Donald OConnell DOCONNEL 199 Douglas Grant DGRANT 200 Jennifer Whalen JWHALEN 201 Michael Hartstein MHARTSTE 202 Pat Fay PFAY 203 Susan Mavris SMAVRIS 204 Hermann.. 104 - [Oracle 19C] Categories of Undo Active Uncommitted undo information required if a user wants to roll back or if the transaction has failed. Uncommitted undo information is never overwritten. Unexpired Committed undo information Old undo information with an age that is less than the current undo retention period retained for consistent read and Oracle Flashback operations Expired Expired undo information Old (committed) undo in.. 이전 1 2 3 4 5 ··· 15 다음
