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

사용자

ID:
PW:

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

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

 회원가입

regexp_replace 사용예
최길호 [LIST]   2019-10-06 01:15:34, 조회 : 531

select * from dd;

time dd if=/TNG/oradata/XPMA30.dbf bs=512k | ssh -p 2222 root@aix2 dd of=/oradata_dev12/XPMA_030.dbf bs=512k
time dd if=/TNG/oradata/XPMA31.dbf bs=512k | ssh -p 2222 root@aix3 dd of=/oradata_dev13/XPMA_031.dbf bs=512k
time dd if=/TNG/oradata/XPMA32.dbf bs=512k | ssh -p 2222 root@aix4 dd of=/oradata_dev14/XPMA_032.dbf bs=512k
time dd if=/TNG/oradata/XPMA33.dbf bs=512k | ssh -p 2222 root@aix5 dd of=/oradata_dev15/XPMA_033.dbf bs=512k
time dd if=/TNG/oradata/XPMA34.dbf bs=512k | ssh -p 2222 root@aix1 dd of=/oradata_dev16/XPMA_034.dbf bs=512k
time dd if=/TNG/oradata/XPMA35.dbf bs=512k | ssh -p 2222 root@aix2 dd of=/oradata_dev17/XPMA_035.dbf bs=512k

select 'ls '||regexp_replace(a,' bs=512k ','') from (select regexp_replace(run,'(^(.*)of=)','') a from dd);

ls /oradata_nps12/XPMA_030.dbf
ls /oradata_nps13/XPMA_031.dbf
ls /oradata_nps14/XPMA_032.dbf
ls /oradata_nps15/XPMA_033.dbf
ls /oradata_nps16/XPMA_034.dbf
ls /oradata_nps17/XPMA_035.dbf


  LIST

제목 작성자 작성일 조회
Admin  진행중.    최길호 2008/11/26 106
Admin  [ 필요 하신게 있으시면 Login 하시고 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]    최길호 2006/07/14 123
Admin  unzip: cannot find or open LINUX.X64_180000_db_home.zip    최길호 2020/08/07 7
Install and Config  docker oracle 12c,18c,19c on oracle linux 7 test    최길호 2020/08/07 12
Install and Config  docker oracle 11g on oracle linux 7 test    최길호 2020/08/06 11
Install and Config  docker oracle 10g on oracle linux 6 test    최길호 2020/08/06 13
Install and Config  docker oracle 9i on oracle linux 5 test    최길호 2020/08/05 9
Troubleshoot  ORA-00600: internal error code, arguments: [qertbFetchByRowID] ORA-00600: internal error code, arguments: [ktspfupdst-1] rdba.sql    최길호 2020/08/03 12
WebLogic  postgresql jdbc weblogic    최길호 2020/07/31 23
WebLogic  docker weblogic 12.2    최길호 2020/07/29 27
Admin  otpack    최길호 2020/07/21 50
Troubleshoot  ORA-02291: integrity constraint / ORA-02292: integrity constraint / ORA-02449: unique/primary keys / ORA-02298: cannot validate [ 제약조건 조치 방안 ]    최길호 2020/07/14 95
Admin  데이터 유지 ASM 재설치 test [ asmcmd md_backup ]    최길호 2020/07/13 102
Troubleshoot  PLS-00103: Encountered the symbol / PLS-00201: identifier    최길호 2020/07/08 105
Troubleshoot  ADVM Driver Not installed / ORA-15032 ORA-15489 delete waiting for last close    최길호 2020/07/08 138
Troubleshoot  dba_scheduler_running_jobs session_id is null    최길호 2020/07/05 98
Script  linux config, dbca, create tablespace, expdp, rman backup script    최길호 2020/07/02 121
Troubleshoot  PLS-00302: component 'table' must be declared    최길호 2020/07/02 103

    목록보기   다음페이지 1 [2][3][4][5][6][7][8][9][10]..[126]   [다음 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 최길호
최근 게시물
08/13
[PostgreSQL]
install edb12 / pem / on docke....
by 최길호
08/13
[기타정보]
Apache txt deny /robots.txt 만 ....
by 최길호
08/10
[기타정보]
java delete [ java archvie log....
by 최길호