728x90
![](https://blog.kakaocdn.net/dn/daclFV/btrEHB8XIdn/IPOL46iBIrnXUKYdPulC9k/img.png)
HR, SCOTT 설정은 똑같음
![](https://blog.kakaocdn.net/dn/c1SVNt/btrEDQrCj6r/zVjkE1uGOkRQgiaTlVBes1/img.png)
![](https://blog.kakaocdn.net/dn/vGGUD/btrECzwWws8/Ef9KtSV0HivN299rUSHqn0/img.png)
SYS 설정
![](https://blog.kakaocdn.net/dn/6yUwF/btrEGI7vwpn/pFkcL7g4DuhNTej6KzVoFK/img.png)
오류종류
1. 테스트 실패 : IO 오류 : The Network Adapter could not establish the connection
해결 방법 : cmd => ipconfig => IPv4 주소 . . . . . . . . . : 192.168.100.131 를 SQL Developer 호스트 이름에 아이피 주소를 넣어주면 됩니다
2. ORA-28000: the account is locked
해결 방법 : sysdba
![](https://blog.kakaocdn.net/dn/dHCSf1/btrEHTnfs3P/2Yc9xwEfoVj7eCOYNZLdNk/img.png)
![](https://blog.kakaocdn.net/dn/em5mb3/btrEF8yF4a1/sck6Uk2e5NNWxBiveCaMD1/img.png)
SYS 질의작성에 명령
create user testt1 identified by testt1;
grant connect, resource to testt1;
![](https://blog.kakaocdn.net/dn/zVcQg/btrEGKSAS6o/0DCpzrIjtDjOzdLoPTP1ZK/img.png)
![](https://blog.kakaocdn.net/dn/caK7BJ/btrEwzYcuDb/xkgf2lzK7PvxtE960Tp7tK/img.png)
![](https://blog.kakaocdn.net/dn/7Vva9/btrExYwDCrE/WBcNh2JPHXVXxnqlFno5i0/img.png)
![](https://blog.kakaocdn.net/dn/tGuTL/btrEEV0dhRC/JLSvCvT3mW1pEJWZjTu8oK/img.png)
![](https://blog.kakaocdn.net/dn/cygCF4/btrEzJ65Kco/hXkvZ1Utf0kVHevf3CKdhk/img.png)
![](https://blog.kakaocdn.net/dn/bBN1AK/btrEHi1UPCY/Nvpk0VdlwvUzAmOeB1Xkkk/img.png)
![](https://blog.kakaocdn.net/dn/zS58l/btrEEWx2nSP/wk37OkiR0vNylcRI75U3nk/img.png)
![](https://blog.kakaocdn.net/dn/kKE1J/btrEIspbjSr/AB5fn1RwH5AkNy9mf524zK/img.png)
![](https://blog.kakaocdn.net/dn/dEI2It/btrECvU4LmL/LqycQyEmWLkIcJWg3ruFQK/img.png)
![](https://blog.kakaocdn.net/dn/E5Ef6/btrECvndzLH/KUbB7NKFmv7QyHyud63rH0/img.png)
관리자권한으로 메모장열고 C드라이브에 저장한다.파일명(emp_data.cvs / load_emp_data.ctl)
id,l_name,salary,hired
100,Steve,2000,00/01
101,Bill,2500/01/20
102,Larry,3000,02/22
103,Elon,3000,12/10
104,Watson,20700,15/13
105,Satya,5000,00/01
option(skip=1)
load data
infile 'C:\emp_data.cvs'
truncate into table empsss
fields terminated by ","
lines terminated by '\n' /* \tab,":", ";" , "," Delimiter(구분자)
(id,l_name,salary,hired)
![](https://blog.kakaocdn.net/dn/pT0YE/btrEF9j8hKe/iakRuFgqDNkrZ0OaSMf3VK/img.png)
![](https://blog.kakaocdn.net/dn/bFH6h1/btrEHUGw4tb/AorlftDkFNosD8TtSbzV80/img.png)
![](https://blog.kakaocdn.net/dn/bgiHLJ/btrEEVFYYv1/xTNsG55bY4M19HKafcn2V1/img.png)
데이터 들어갔는지 확인해보기
'일단 해보는 코딩 > Oracle SQL' 카테고리의 다른 글
[오라클/SQL] Cursor(커서) 종류와 구조 그리고 예제 (0) | 2022.06.13 |
---|---|
[오라클/SQL] Trigger(트리거) (0) | 2022.06.13 |
[오라클/SQL] PL/SQL 실행 (0) | 2022.06.13 |
[오라클/SQL] SYNONYM (동의어), MERGE(머지), Data Dictionary(딕셔너리) (0) | 2022.06.13 |
[오라클/SQL] Subqueries(서브쿼리) 종류와 규칙 (0) | 2022.06.12 |