ORACLE

IOTN :: Field Book :: ORACLE

회원가입

external table expdp

최길호 [LIST]

2022-06-18 02:01:55, 조회 : 24

-- exp

drop table SCOTT.DATA2 purge;

!rm /backup/expdp/SCOTT.DATA

create table SCOTT.DATA2

organization external

( type oracle_datapump default directory expdp

location ('SCOTT.DATA') )

as select DOCTSHKY,DOCTDATA from SCOTT.DATA;



-- imp

drop table SCOTT.DATA2 purge;

create table SCOTT.DATA2

(

DOCTSHKY  VARCHAR2(18),

DOCTDATA  CLOB

)

organization external

( type oracle_datapump default directory expdp

location ('SCOTT.DATA') )

;

3.235.78.122

LIST

	제목	작성자	작성일	조회
Admin	[ 공지 ] 😃 서비스 시간 08:00 ~ 23:00 / 안되면 나중에 다시 방문 해주세요~.😅	최길호	2008/11/26	113
Admin	[ 필요 하신게 있으시면 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]	최길호	2006/07/14	134
Troubleshoot	DDE: Problem Key 'ORA 600 [13310]' was completely flood controlled (0x6)	최길호	2022/06/29	2
Oracle GoldenGate	Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.	최길호	2022/06/25	12
Admin	ORA-14452: attempt to create, alter or drop an index on temporary table already in use	최길호	2022/06/24	6
Admin	external table expdp	최길호	2022/06/18	24
Admin	clob to file / file to clob / clob_to_file / file_to_clob	최길호	2022/06/17	23
Troubleshoot	ORA-13203: failed to read USER_SDO_GEOM_METADATA view	최길호	2022/06/14	17
Troubleshoot	ORA-13249: SRID 5186 does not exist in MDSYS.CS_SRS table	최길호	2022/06/13	21
Troubleshoot	Exception in kzam_upd_props, 942:ORA-00942: table or view does not exist	최길호	2022/06/11	20
Install and Config	Rocky Linux 8.6 Oracle 11.2	최길호	2022/06/03	28
Admin	RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time	최길호	2022/06/02	30
Admin	http://mirror.centos.org/centos/7/os/x86_64/Packages/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm	최길호	2022/05/30	21
Admin	한글 파일 ORA-22288: 파일 또는 LOB FILEOPEN 작업이 실패되었습니다	최길호	2022/05/26	36
Admin	ORA-00001: unique constraint (SCOTT.TEST_PK) violated	최길호	2022/05/06	212
Troubleshoot	windows ORA-01031: insufficient privileges	최길호	2022/04/22	56
Admin	impdp ORA-01400: cannot insert NULL into , ORA-01449: column contains NULL	최길호	2022/04/19	52

목록보기 다음페이지

1 [2][3][4][5][6][7][8][9][10]..[145] [다음 10개]

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