버전 비교

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.

...

코드 블럭
languagebash
[oracle@rac1 ~]$ ifconfig eth0
eth0 Link encap:Ethernet HWaddr 00:0C:29:87:6B:D9 
inet addr:192.168.0.210 Bcast:192.168.0.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe87:6bd9/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:151011 errors:0 dropped:0 overruns:0 frame:0
TX packets:84100 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000 
RX bytes:21433599 (20.4 MiB) TX bytes:8651708 (8.2 MiB)
eth1 Link encap:Ethernet HWaddr 00:0C:29:87:6B:E3 
inet addr:10.10.1.210 Bcast:10.10.1.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe87:6be3/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:37133955 errors:0 dropped:0 overruns:0 frame:0
TX packets:40453291 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000 
RX bytes:43861323031 (40.8 GiB) TX bytes:20634811560 (19.2 GiB)
eth2 Link encap:Ethernet HWaddr 00:0C:29:87:6B:ED 
inet addr:10.10.2.210 Bcast:10.10.2.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe87:6bed/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:6094 errors:0 dropped:0 overruns:0 frame:0
TX packets:13626 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000 
RX bytes:1011453 (987.7 KiB) TX bytes:5258742 (5.0 MiB)
eth2:1 Link encap:Ethernet HWaddr 00:0C:29:87:6B:ED 
inet addr:10.10.2.200 Bcast:10.10.2.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
eth2:3 Link encap:Ethernet HWaddr 00:0C:29:87:6B:ED 
inet addr:10.10.2.100 Bcast:10.10.2.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
eth3 Link encap:Ethernet HWaddr 00:0C:29:87:6B:F7 
inet addr:10.10.3.210 Bcast:10.10.3.255 Mask:255.255.255.0
inet6 addr: fe80::20c:29ff:fe87:6bf7/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:33947312 errors:0 dropped:0 overruns:0 frame:0
TX packets:27646272 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000 
RX bytes:17395510253 (16.2 GiB) TX bytes:9001557481 (8.3 GiB)
eth3:1 Link encap:Ethernet HWaddr 00:0C:29:87:6B:F7 
inet addr:169.254.108.237 Bcast:169.254.255.255 Mask:255.255.0.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
lo Link encap:Local Loopback 
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:4872260 errors:0 dropped:0 overruns:0 frame:0
TX packets:4872260 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0 
RX bytes:8920204682 (8.3 GiB) TX bytes:8920204682 (8.3 GiB)
[oracle@rac1 ~]$ ls -l imsi.dmp
-rw-r----- 1 oracle oinstall 4481024 Feb 2 10:55 imsi.dmp

위에서 scp를 통해 파일을 복사해 넣은 192.168.0.210서버이다. 210서버에 접속하여 확인해 보니, 파일이 잘 복사되었음을 확인할 수 있다있었다.

 

코드 블럭
[oracle@rac1 ~]$ sqlplus / AS sysdba
SQL*Plus: RELEASE 11.2.0.2.0 Production ON Thu Feb 2 10:56:20 2012
Copyright (c) 1982, 2010, Oracle. ALL rights reserved.

Connected TO:
Oracle DATABASE 11g Enterprise Edition RELEASE 11.2.0.2.0 - 64bit Production
WITH the Partitioning, REAL Application Clusters, Automatic Storage Management, OLAP,
Data Mining AND REAL Application Testing options
-- 보시다싶이 더 상위 버전의 오라클 서버에 접속하였다.
SQL> CREATE DIRECTORY imsi AS '/home/oracle/';
DIRECTORY created.
-- 앞에서와 마찬가지로 디렉토리 객체를 먼저 생성해주었다.
SQL> CREATE TABLE ext_pump_test
2 (
3 OWNER VARCHAR2(30),
4 OBJECT_NAME VARCHAR2(30),
5 SUBOBJECT_NAME VARCHAR2(30),
6 OBJECT_ID NUMBER,
7 DATA_OBJECT_ID NUMBER,
8 OBJECT_TYPE VARCHAR2(19),
9 CREATED DATE,
10 LAST_DDL_TIME DATE,
11 TIMESTAMP VARCHAR2(19),
12 STATUS VARCHAR2(7),
13 TEMPORARY VARCHAR2(1),
14 GENERATED VARCHAR2(1),
15 SECONDARY VARCHAR2(1)
16 )
17 ORGANIZATION external
18 (
19 TYPE oracle_datapump
20 DEFAULT DIRECTORY imsi
21 location ('imsi.dmp')
22 );
TABLE created.
-- 그리고 방금 복사받은 파일을 이용하여 external table을 생성해주었다.
SQL> SELECT COUNT(*) FROM ext_pump_test;
COUNT(*)
----------
45585
SQL> SELECT * FROM ext_pump_test WHERE ROWNUM < 10;
OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS T G S
------------------------------ ------------------------------ ------------------------------ ---------- -------------- ------------------- ------------------ ------------------ ------------------- ------- - - -
SYS ICOL$ 20 2 TABLE 28-SEP-11 28-SEP-11 2011-09-28:18:07:00 VALID N N N
SYS I_USER1 44 44 INDEX 28-SEP-11 28-SEP-11 2011-09-28:18:07:00 VALID N N N
SYS CON$ 28 28 TABLE 28-SEP-11 28-SEP-11 2011-09-28:18:07:00 VALID N N N
SYS UNDO$ 15 15 TABLE 28-SEP-11 28-SEP-11 2011-09-28:18:07:00 VALID N N N
SYS C_COBJ# 29 29 CLUSTER 28-SEP-11 28-SEP-11 2011-09-28:18:07:00 VALID N N N
SYS I_OBJ# 3 3 INDEX 28-SEP-11 28-SEP-11 2011-09-28:18:06:59 VALID N N N
SYS PROXY_ROLE_DATA$ 25 25 TABLE 28-SEP-11 28-SEP-11 2011-09-28:18:07:00 VALID N N N
SYS I_IND1 39 39 INDEX 28-SEP-11 28-SEP-11 2011-09-28:18:07:00 VALID N N N
SYS I_CDEF2 51 51 INDEX 28-SEP-11 28-SEP-11 2011-09-28:18:07:00 VALID N N N
9 ROWS selected.
-- 이와 같이 로우 카운트도 동일하며 셀렉트도 잘 되는 것을 확인하실 수 있다.

...