http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [62]
02.File Book
File 자료실 [93]
Site Link [15]
개인폴더 [182]
03.Field Book
Altibase [15]
Tibero [22]
MS-SQL [17]
MySQL [27]
DB2 [75]
ORACLE [2453]
기타 DBMS [2]
기타정보 [136]
운영체제 [536]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Work Book :: ORACLE

 회원가입

DataPump Export (EXPDP) Of Partitioned Table Is Very Slow
최길호 [LIST]   2020-03-19 21:55:18, 조회 : 9

12.2 Expdp Is Very Slow After Upgrade To 12.1.0.2 (Doc ID 2033634.1)
alter system set optimizer_use_sql_plan_baselines =FALSE;


expdp ... tables=TEST1:P2013,TEST2:P2013
..... hang or very slow .....
조치안
expdp ... exclude=statistics



  LIST

제목 작성자 작성일 조회
Admin  진행중.    최길호 2008/11/26 105
Admin  [ 필요 하신게 있으시면 Login 하시고 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]    최길호 2006/07/14 122
Troubleshoot  ORA-01406: fetched column value was truncated    최길호 2020/04/08 1
Troubleshoot  impdp ORA-39168: Object path INDEX was not found.    최길호 2020/04/07 4
Script  shutdown abort 전에 OS kill script [ v$transaction v$process v$session ]    최길호 2020/04/05 6
Script  linux seq 1 10 [ alter tablespace test add datafile ... ]    최길호 2020/04/03 5
Troubleshoot  Rman debug    최길호 2020/04/02 4
Backup and Recovery  RMAN> recover table scott.emp until time    최길호 2020/03/31 5
Troubleshoot  RMAN-06617: UNTIL TIME (2020-03-31 22:00:00) is ahead of last NEXT TIME in archived logs (2020-03-31 10:28:51)    최길호 2020/03/31 3
Troubleshoot  ORA-31693: Table data object "SCOTT"."EMP" failed to load/unload and is being skipped due to error:    최길호 2020/03/28 7
Troubleshoot  DataPump Export (EXPDP) Of Partitioned Table Is Very Slow    최길호 2020/03/19 9
Troubleshoot  impdp EVENT: wait for unread message on broadcast channel    최길호 2020/03/17 13
Troubleshoot  UDE-00008: operation generated ORACLE error 31626 [ expdp compile ]    최길호 2020/03/16 13
Q/A  SQL 연결이 끊어진값 확인. [ 연결 연속된 값 확인 ]    최길호 2020/03/16 14
Troubleshoot  Error in invoking target 'agent nmhs' of makefile '/oracle/db/sysman/lib/ins_emagent.mk'.    최길호 2020/03/13 22
Script  job broken, scheduler disable from dba_jobs dba_scheduler_jobs    최길호 2020/03/12 13

    목록보기   다음페이지 1 [2][3][4][5][6][7][8][9][10]..[123]   [다음 10개]
       

Copyright 1999-2020 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2019/05/02
pkg 확인 SELECT * FROM AL...
by 최길호
2018/05/18
Name Type ...
by 최길호
2018/01/07
ORA-00020: maximum number of...
by 최길호
최근 게시물
04/08
[ORACLE]
ORA-01406: fetched column valu....
by 최길호
04/07
[ORACLE]
impdp ORA-39168: Object path I....
by 최길호
04/06
[운영체제]
nmon 16.
by 최길호