장기기억장치

#exportDECLARE h1 NUMBER;BEGIN h1 := DBMS_DATAPUMP.OPEN( operation => 'EXPORT', job_mode => 'TABLE', job_name => 'SAMJEON_T2'); DBMS_DATAPUMP.ADD_FILE( handle => h1, filename => 't2.dmp', directory => 'DATA_PUMP_DIR', filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_DUMP_FILE); DBMS_DATAPUMP.ADD_FILE( handle => h1, ..

# Openmediavault는 debian리눅스로 Nas,cloud-filesystem,iscsi 같은 부분을 지원합니다. # 저는 Openmediavault 8.2.4 # 밑에 주소에서 설치가능. Openmediavault # Openmediavault서버의메모리는 2기가면 될 것 같습니다#파티션 생성fdisk -l|grep /dev/sdDisk /dev/sda: 15 GiB, 16106127360 bytes, 31457280 sectors /dev/sda1 * 2048 29728767 29726720 14.2G 83 Linux /dev/sda2 29730814 31455231 1724418 842M f W95 Ext'd (LBA) /dev/sda5 29730..

#bash-shell 명령어 만들기.#!/bin/bashparam=$*export oracle_id=export oracle_pw=export oracle_instance=export oracle_query=export oracle_sysdba=while read o_linedoif [ "${o_line:0:1}" = "u" ];thenoracle_id="${o_line:1}"elif [ "${o_line:0:1}" = "x" ];thenoracle_pw="${o_line:1}"elif [ "${o_line:0:1}" = "I" ];thenoracle_instance="@"$(echo "${o_line:1}"|xargs)elif [ "${o_line:0:1}" = "X" ];thenoracle_query..

limactl stop mv ~/.lima/ ~/.lima/cp ~/.lima/qemu-img rebase -u -F qcow2 -b basedisk diffdisk

# lima.yaml# This example requires Lima v0.9.0 or later.# Oracle image licence: https://www.oracle.com/downloads/licenses/oracle-linux-license.html# Image source: https://yum.oracle.com/oracle-linux-templates.htmlvmType: "qemu"arch: "x86_64"images:#자신이 쓸 os버전을 다운로드한다.- location: "https://yum.oracle.com/templates/OracleLinux/OL8/u5/x86_64/OL8U5_x86_64-olvm-b113.qcow2" arch: "x86_64" digest: "sh..

-- postgresql 17.2pg_basebackup -h -p 5432 -D $PGDATA -U dbarep -c fast -X stream -v -R -P --waldir=/pg_wal -W listen_addresses 파라메터의 기본값이 localhost로 되어있음 그래서 연결을 거부함.pg_basebackup: error: connection to server at "", port 5432 failed: 연결이 거부됨 Is the server running on that host and accepting TCP/IP connections?listen_addresses 파라메터 값을 *(아스타)로 바꿔줌떨어지는 에러내용이 바뀜 pg_basebackup: error: connection t..

Function Description current_catalog → name current_database () → name Returns the name of the current database. (Databases are called “catalogs” in the SQL standard, so current_catalog is the standard's spelling.) ..

# vmware player에서 네트워크 주소 변경하는 방법 c:\Program Files (x86)\VMware\VMware Player>vnetlib.exe vnetlib.exe -- stop nat vnetlib.exe -- stop dhcp vnetlib.exe -- set vnet vmnet8 mask  255.255.255.0 vnetlib.exe -- set vnet vmnet8 addr  192.168.100.0 vnetlib.exe -- set adapter vmnet8 addr 192.168.100.2 vnetlib.exe -- set nat vmnet8 internalipaddr 192.168.100.254 vnetlib.exe -- update dhcp vmnet8 vnetlib.e..

// 15회 실기 1번// 19회 실기 1,2번// 43회 실기 1,2번,단답// 44회 실기 1,2번// 50회 실기 1,2번// 51회 실기 1,2번// 52회 실기 1,2번