{"id":1410,"date":"2016-09-20T12:28:05","date_gmt":"2016-09-20T03:28:05","guid":{"rendered":"http:\/\/www.dbsheetclient.jp\/blog\/?p=1410"},"modified":"2018-06-27T15:50:44","modified_gmt":"2018-06-27T06:50:44","slug":"%e5%a4%96%e9%83%a8%e8%a1%a8%ef%bc%88%ef%bc%92%ef%bc%89%ef%bc%88oracle%ef%bc%89","status":"publish","type":"post","link":"https:\/\/www.dbsheetclient.jp\/blog\/?p=1410","title":{"rendered":"\u5916\u90e8\u8868\uff08\uff12\uff09\uff08ORACLE\uff09"},"content":{"rendered":"

IT\u30b3\u30fc\u30c7\u30a3\u30cd\u30fc\u30bf\u306e\u30b7\u30e5\u30a6\u3067\u3059\u3002<\/p>\n

\"img_0418\"<\/a><\/p>\n

\u5199\u771f\u306f\u3001\u524d\u56de\u3082\u8f09\u305b\u307e\u3057\u305f\u304c\u3001\u5bcc\u5c71\u306e\u4e94\u7b87\u5c71\u3068\u3044\u3046\u4e16\u754c\u907a\u7523\u5408\u638c\u9020\u308a\u96c6\u843d\u306b\u884c\u3063\u305f\u3068\u304d\u306e\u5199\u771f\u3067\u3059\u3002<\/p>\n

\u3055\u3066\u3001\u3068\u3046\u3068\u3046\u30d6\u30e9\u30b8\u30eb\u30fb\u30ea\u30aa\u30c7\u30b8\u30e3\u30cd\u30a4\u30ed\u3067\u884c\u308f\u308c\u3066\u3044\u305f\u30d1\u30e9\u30ea\u30f3\u30d4\u30c3\u30af\u3082\u7d42\u308f\u308a\u307e\u3057\u305f\u3002\u30aa\u30ea\u30f3\u30d4\u30c3\u30af\u3001\u30d1\u30e9\u30ea\u30f3\u30d4\u30c3\u30af\u3068\u3082\u3001\u591a\u304f\u306e\u611f\u52d5\u3092\u79c1\u305f\u3061\u306b\u4e0e\u3048\u3066\u9802\u3044\u305f\u3068\u3001\u9078\u624b\u306e\u65b9\u3005\u306b\u672c\u5f53\u306b\u611f\u8b1d\u3057\u307e\u3059\u3002
\u30d1\u30e9\u30ea\u30f3\u30d4\u30c3\u30af\u3067\u306f\u91d1\u30e1\u30c0\u30eb\u306f\u306a\u304b\u3063\u305f\u3068\u3044\u3046\u3053\u3068\u3067\u3059\u304c\u3001\u904e\u53bb\u6700\u9ad8\u306e\u30e1\u30c0\u30eb\u6570\u3092\u7372\u5f97\u3002\u307e\u305f\u3001\u3061\u3087\u3063\u3068\u8a71\u984c\u306f\u53e4\u304f\u306a\u308a\u307e\u3059\u304c\u3001\u5148\u6708\u306e\u30aa\u30ea\u30f3\u30d4\u30c3\u30af\u3067\u306f\u3001\u4f53\u64cd\u56e3\u4f53\u3067\u306e\u60b2\u9858\u306e\u91d1\u30e1\u30c0\u30eb\u3001\u500b\u4eba\u7dcf\u54082\u9023\u8987\u306e\u5185\u6751\u9078\u624b\u306e\u6700\u5f8c\u306e\u5927\u9006\u8ee2\u306f\u5727\u5dfb\u3067\u3057\u305f\u306d\u3002\u4f0a\u8abf\u99a8\u9078\u624b\u306e\u30ec\u30b9\u30ea\u30f3\u30b04\u9023\u8987\u306f\u3001\u5973\u5b50\u500b\u4eba\u7af6\u6280\u3067\u53f2\u4e0a\u521d\u3081\u3066\u306e\u3053\u3068\u3002\u5353\u7403\u3067\u3082\u7537\u5b50\u56e3\u4f53\u3067\u9280\u30e1\u30c0\u30eb\u3001\u5973\u5b50\u56e3\u4f53\u3082\u9285\u30e1\u30c0\u30eb\u3001\u5973\u5b50\u30d0\u30c9\u30df\u30f3\u30c8\u30f3\u30c0\u30d6\u30eb\u30b9\u306e\u65e5\u672c\u521d\u306e\u91d1\u30e1\u30c0\u30eb\u3001\u672c\u5f53\u306b\u624b\u306b\u6c57\u63e1\u3063\u3066\u5fdc\u63f4\u3057\u307e\u3057\u305f\u3002\u67d4\u9053\u3082\u7537\u5b50\u306f\u5168\u968e\u7d1a\u3067\u30e1\u30c0\u30eb\u3001\u7537\u5b50\u306e\u9678\u4e0a4*100\u30e1\u30fc\u30c8\u30eb\u30ea\u30ec\u30fc\u9280\u30e1\u30c0\u30eb\u3001\u7af6\u6cf3\u9663\u306e\u6d3b\u8e8d\u3001\u6570\u3048\u4e0a\u3052\u308c\u3070\u304d\u308a\u304c\u306a\u3044\u3067\u3059\u3002<\/p>\n

\u6b21\u306f\u3044\u3088\u3044\u3088\u6771\u4eac\u30aa\u30ea\u30f3\u30d4\u30c3\u30af\u3001\u30d1\u30e9\u30ea\u30f3\u30d4\u30c3\u30af\uff01 4\u5e74\u9593\u3068\u3044\u3046\u9577\u3044\u52aa\u529b\u3068\u8a13\u7df4\u306e\u671f\u9593\u3001\u60f3\u50cf\u3092\u7d76\u3059\u308b\u6226\u3044\u306e\u672b\u306b\u3001\u6804\u5149\u304c\u3042\u308b\u306e\u3067\u3057\u3087\u3046\u3002\u79c1\u305f\u3061\u3082\u3001\u9053\u306f\u9055\u3044\u307e\u3059\u304c\u3001\u9078\u624b\u306e\u65b9\u3005\u306b\u8ca0\u3051\u306a\u3044\u3088\u3046\u3001\u4e0e\u3048\u3089\u308c\u305f\u74b0\u5883\u306e\u4e2d\u3067\u7cbe\u3044\u3063\u3071\u3044\u9811\u5f35\u3063\u3066\u884c\u304b\u306a\u3051\u308c\u3070\u3068\u80cc\u4e2d\u3092\u62bc\u3055\u308c\u308b\u6c17\u304c\u3057\u307e\u3059\u3002
\u9078\u624b\u306e\u7686\u3055\u3093\u3001\u672c\u5f53\u306b\u304a\u75b2\u308c\u69d8\u3067\u3057\u305f\u3002\u305d\u3057\u3066\u3001\u611f\u52d5\u3092\u3042\u308a\u304c\u3068\u3046\uff01

\uff1c\u672c\u65e5\u306e\u984c\u6750\uff1e
Oracle\u306e\u5916\u90e8\u8868\uff08\uff12\uff09<\/p>\n

<\/strong>\u524d\u56de<\/a>\u3001ORACLE\u306e\u5916\u90e8\u8868\u306b\u3064\u3044\u3066ORACLE_LOADER\u578b\u3092\u53d6\u308a\u4e0a\u3052\u307e\u3057\u305f\u304c\u3001\u4eca\u56de\u306f\u3001ORACLE_DATAPUMP\u578b\u3068\u3044\u3046\u3082\u306e\u3092\u8a66\u3057\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002ORACLE_LOADER\u578b\u3067\u306f\u3001CSV\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u306e\u8aad\u8fbc\u3057\u304b\u3067\u304d\u307e\u305b\u3093\u304c\u3001ORACLE_DATAPUMP\u578b\u3067\u306f\u3001\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u66f8\u304d\u8fbc\u3093\u3060\u308a\u3001\u8aad\u8fbc\u3093\u3060\u308a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u4f8b\uff09
\u5546\u54c1\u58f2\u4e0a\u3068\u3044\u3046\u3001\u5546\u54c1\u30b3\u30fc\u30c9\u6bce\u3001\u5e74\u5ea6\u6bce\u306e\u5404\u6708\u306e\u58f2\u4e0a\u91d1\u984d\u3092\u96c6\u8a08\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u304c\u3042\u308a\u3001\u305d\u3053\u306b\u30012014\u5e74\u30012015\u5e74\u30012016\u5e74\u306e\u30c7\u30fc\u30bf\u304c\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u3068\u3057\u307e\u3059\u3002
\u30c6\u30fc\u30d6\u30eb\u306e\u5b9a\u7fa9\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002
DESC \u5546\u54c1\u58f2\u4e0a<\/p>\n

\"desc_%e5%95%86%e5%93%81%e5%a3%b2%e4%b8%8a\"<\/p>\n

<\/a>\u30c7\u30fc\u30bf\u3068\u3057\u3066\u306f\u3053\u3093\u306a\u611f\u3058\u3002
<\/a><\/p>\n

\"%e5%95%86%e5%93%81%e5%a3%b2%e4%b8%8a%e3%83%87%e3%83%bc%e3%82%bf\"<\/a><\/p>\n

\u00a0\u5e74\u5ea6\u6bce\u306e\u4ef6\u6570\u306f\u3001
SELECT \u5e74\u5ea6, COUNT(*) FROM \u5546\u54c1\u58f2\u4e0a
GROUP BY \u5e74\u5ea6
ORDER BY \u5e74\u5ea6;<\/p>\n

\"%e5%b9%b4%e5%ba%a6%e3%81%94%e3%81%a8%e4%bb%b6%e6%95%b0\"<\/a><\/p>\n

\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u306a\u306e\u3067\u4ef6\u6570\u306f\u5c11\u306a\u3044\u3067\u3059\u3002
\u305d\u308c\u3067\u3001\u4eca\u5e74\u5ea6\uff082016\uff09\u306e\u30c7\u30fc\u30bf\u3060\u3051\u6b8b\u3057\u3066\u3001\u904e\u53bb\u306e\u5e74\u5ea6\u306e\u30c7\u30fc\u30bf\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u3068\u3057\u3066\u306f\u6301\u305f\u306a\u3044\u3067\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\u306b\u4fdd\u5b58\u3057\u3001\u5fc5\u8981\u306a\u3068\u304d\u306b\u306f\u5916\u90e8\u8868\u3068\u3057\u3066\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3088\u3046\u306b\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

\u307e\u305a\u30012014\u5e74\u306e\u30c7\u30fc\u30bf\u306e\u5916\u90e8\u8868\u3092\u4f5c\u6210\u3057\u3001\u5916\u90e8\u8868\u306e\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u767b\u9332\u3057\u307e\u3059\u3002<\/p>\n

CREATE TABLE SYO_URIAGE_2014
ORGANIZATION EXTERNAL
(
\u00a0 TYPE ORACLE_DATAPUMP
\u00a0 DEFAULT DIRECTORY temp_dir
\u00a0 LOCATION (‘uriage_2014.dmp’)
)
AS SELECT * FROM \u5546\u54c1\u58f2\u4e0a
\u00a0 \u00a0 WHERE \u5e74\u5ea6 = ‘2014’;<\/p>\n

\"syo_uriage_2014\"<\/a><\/p>\n

\u00a0\u6b21\u306b\u3001\u540c\u69d8\u306b\u3057\u3066\u30012015\u5e74\u306e\u30c7\u30fc\u30bf\u306e\u5916\u90e8\u8868\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n

CREATE TABLE SYO_URIAGE_2015
ORGANIZATION EXTERNAL
(
\u00a0 TYPE ORACLE_DATAPUMP
\u00a0 DEFAULT DIRECTORY temp_dir
\u00a0 LOCATION (‘uriage_2015.dmp’)
)
AS SELECT * FROM \u5546\u54c1\u58f2\u4e0a
\u00a0 \u00a0 WHERE \u5e74\u5ea6 = ‘2015’;<\/p>\n

\"syo_uriage_2015\"<\/a><\/p>\n

\u5b9f\u969b\u306b\u3001\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\u304c\u6307\u5b9a\u306e\u30d5\u30a9\u30eb\u30c0\u306b\u4f5c\u6210\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3059\u3002\u4eca\u56de\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u6307\u5b9a\u3057\u305f\u300ctemp_dir\u300d\u306f\u3001\u524d\u56de\u306e\u30d6\u30ed\u30b0\u3067\u4f5c\u6210\u3057\u305f\u3088\u3046\u306b\u3001\u300cC:\\temp\u300d\u30d5\u30a9\u30eb\u30c0\u306b\u306a\u308a\u307e\u3059\u306e\u3067\u3001\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u3067\u78ba\u8a8d\u3059\u308b\u3068\u3001<\/p>\n

\"temp_dir\"<\/a><\/p>\n

\u78ba\u304b\u306b\u3001\u300cURIAGE_2014.DMP\u300d\u300cURIAGE_2015.DMP\u300d\u30d5\u30a1\u30a4\u30eb\u304c\u4f5c\u6210\u3055\u308c\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n

\u305d\u308c\u305e\u308c\u4f5c\u6210\u3057\u305f\u5916\u90e8\u8868\u306e\u30c7\u30fc\u30bf\u4ef6\u6570\u3092\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3059\u3002
SELECT COUNT(*) FROM SYO_URIAGE_2014;<\/p>\n

\"syo_uri_2014_count\"<\/a><\/p>\n

SELECT COUNT(*) FROM SYO_URIAGE_2015;<\/p>\n

\"syo_uri_2015_count\"<\/a><\/p>\n

\u5143\u306e\u5546\u54c1\u58f2\u4e0a\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u306f\u3001\u904e\u53bb\u306e\u5e74\u5ea6\u306e\u30c7\u30fc\u30bf\u306f\u524a\u9664\u3057\u30012016\u5e74\u5ea6\u306e\u30c7\u30fc\u30bf\u306e\u307f\u3092\u6b8b\u3059\u3053\u3068\u306b\u3057\u307e\u3059\u3002<\/p>\n

DELETE FROM \u5546\u54c1\u58f2\u4e0a
WHERE \u5e74\u5ea6 < ‘2016’;<\/p>\n

\"del_%e5%95%86%e5%93%81%e5%a3%b2%e4%b8%8a\"<\/a><\/p>\n

\u00a0\u51e6\u7406\u306e\u4e0a\u3067\u30012016\u5e74\u5ea6\u306e\u30c7\u30fc\u30bf\u3092\u898b\u308c\u3070\u3088\u3044\u5834\u5408\u306f\u300c\u5546\u54c1\u58f2\u4e0a\u300d\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066SELECT\u3092\u5b9f\u65bd\u3057\u307e\u3059\u304c\u3001\u904e\u53bb\u306e\u30c7\u30fc\u30bf\u3082\u898b\u305f\u3044\u5834\u5408\u306b\u306f\u3001\u5916\u90e8\u8868\u3092\u4f7f\u3046\u3053\u3068\u3067\u691c\u7d22\u3067\u304d\u307e\u3059\u3002<\/p>\n

SELECT \u5546\u54c1CD, \u5e74\u5ea6, \u58f2\u4e0a4\u6708, \u58f2\u4e0a5\u6708, \u58f2\u4e0a6\u6708, \u58f2\u4e0a7\u6708, \u58f2\u4e0a8\u6708, \u58f2\u4e0a9\u6708
\u00a0 FROM \u5546\u54c1\u58f2\u4e0a
\u00a0WHERE \u5546\u54c1CD = ‘A0001’
UNION
SELECT \u5546\u54c1CD, \u5e74\u5ea6, \u58f2\u4e0a4\u6708, \u58f2\u4e0a5\u6708, \u58f2\u4e0a6\u6708, \u58f2\u4e0a7\u6708, \u58f2\u4e0a8\u6708, \u58f2\u4e0a9\u6708
\u00a0 FROM SYO_URIAGE_2015
\u00a0WHERE \u5546\u54c1CD = ‘A0001’
UNION
SELECT \u5546\u54c1CD, \u5e74\u5ea6, \u58f2\u4e0a4\u6708, \u58f2\u4e0a5\u6708, \u58f2\u4e0a6\u6708, \u58f2\u4e0a7\u6708, \u58f2\u4e0a8\u6708, \u58f2\u4e0a9\u6708
\u00a0 FROM SYO_URIAGE_2014
\u00a0WHERE \u5546\u54c1CD = ‘A0001’
ORDER BY \u5e74\u5ea6;<\/p>\n

\"%e5%a4%96%e9%83%a8%e8%a1%a8_union\"<\/a><\/p>\n

\u00a0\u307e\u305f\u3001\u4e0a\u8a18\u3067\u30e6\u30fc\u30b6\u300cBLOG\u300d\u306b\u3088\u3063\u3066\u4f5c\u6210\u3055\u308c\u305f\u5916\u90e8\u30d5\u30a1\u30a4\u30eb\uff08\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\uff09\u3092\u3001\u5225\u306e\u30e6\u30fc\u30b6\u3067\u4f7f\u7528\u3059\u308b\u3088\u3046\u306a\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n

\u4eca\u56de\u3001\u300cBLOG2\u300d\u3068\u3044\u3046\u30e6\u30fc\u30b6\u3092\u4f5c\u6210\u3057\u3001\u300ctemp_dir\u300d\u3092BLOG2\u30e6\u30fc\u30b6\u304b\u3089\u3082\u8aad\u307f\u66f8\u304d\u3067\u304d\u308b\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n

CREATE USER BLOG2
IDENTIFIED BY< password>\u00a0\u00a0\u00a0 — \u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u307e\u3059
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON USERS;<\/p>\n

GRANT READ, WRITE ON DIRECTORY temp_dir TO BLOG2;<\/p>\n

\"grant_read_write_blog2\"<\/a><\/p>\n

\u4f5c\u6210\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u300cBLOG2\u300d\u3067\u30ed\u30b0\u30a4\u30f3\u3057\u3001\u4e0a\u8a18\u3067\u4f5c\u6210\u3057\u305f2015\u5e74\u5ea6\u306e\u5546\u54c1\u58f2\u4e0a\u30c7\u30fc\u30bf\u306e\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\uff08uriage_2015.dmp\uff09\u3092\u5143\u306bBLOG2\u30e6\u30fc\u30b6\u7528\u306e\u5916\u90e8\u8868\u300cSYO_URIAGE2_2015\u300d\u3092\u4f5c\u6210\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n

\u00a0\u00a0CREATE TABLE SYO_URIAGE2_2015
\u00a0 \u00a0(“\u5546\u54c1CD” VARCHAR2(20 BYTE),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u5e74\u5ea6” VARCHAR2(4 BYTE),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u58f2\u4e0a4\u6708” NUMBER(12,0),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u58f2\u4e0a5\u6708” NUMBER(12,0),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u58f2\u4e0a6\u6708” NUMBER(12,0),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u58f2\u4e0a7\u6708” NUMBER(12,0),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u58f2\u4e0a8\u6708” NUMBER(12,0),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u58f2\u4e0a9\u6708” NUMBER(12,0),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u58f2\u4e0a10\u6708” NUMBER(12,0),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u58f2\u4e0a11\u6708” NUMBER(12,0),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u58f2\u4e0a12\u6708” NUMBER(12,0),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u58f2\u4e0a1\u6708” NUMBER(12,0),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u58f2\u4e0a2\u6708” NUMBER(12,0),
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 “\u58f2\u4e0a3\u6708” NUMBER(12,0)
\u00a0 \u00a0)
\u00a0 \u00a0ORGANIZATION EXTERNAL
\u00a0 \u00a0 ( TYPE ORACLE_DATAPUMP
\u00a0 \u00a0 \u00a0 DEFAULT DIRECTORY TEMP_DIR
\u00a0 \u00a0 \u00a0 LOCATION
\u00a0 \u00a0 \u00a0 \u00a0( ‘uriage_2015.dmp’
\u00a0 \u00a0 \u00a0 \u00a0)
\u00a0 \u00a0 );<\/p>\n

\u00a0\"%e5%a4%96%e9%83%a8%e8%a1%a8%e4%bd%9c%e6%88%902\"<\/a><\/p>\n

\u4f5c\u6210\u3057\u305f\u5916\u90e8\u8868\u3092\u691c\u7d22\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n

SELECT \u5546\u54c1CD, \u5e74\u5ea6, \u58f2\u4e0a4\u6708, \u58f2\u4e0a5\u6708, \u58f2\u4e0a6\u6708, \u58f2\u4e0a7\u6708, \u58f2\u4e0a8\u6708, \u58f2\u4e0a9\u6708
\u00a0FROM SYO_URIAGE2_2015
ORDER BY \u5546\u54c1CD;<\/p>\n

\"select_%e5%a4%96%e9%83%a8%e8%a1%a82\"<\/a><\/p>\n

\u00a0\u30c7\u30fc\u30bf\u306e\u691c\u7d22\u304c\u3067\u304d\u307e\u3057\u305f\u3002
\u4e0a\u8a18\u306e\u3088\u3046\u306b\u3001\u4e00\u5ea6\u4f5c\u6210\u3057\u305f\u5916\u90e8\u30d5\u30a1\u30a4\u30eb\uff08\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\uff09\u306f\u3001\u5225\u306e\u30e6\u30fc\u30b6\u3084\u5225\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u74b0\u5883\u306b\u79fb\u52d5\u3057\u3066\u305d\u3053\u3067\u4f7f\u7528\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u306a\u3093\u3067\u3059\u306d\u3002
\u3055\u3089\u306b\u3001PREPROCESSOR\u53e5\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u5916\u90e8\u30d5\u30a1\u30a4\u30eb\u3092\u5727\u7e2e\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u306b\u5bfe\u3057\u3066\u89e3\u51cd\u3057\u306a\u304c\u3089\u4f7f\u7528\u3059\u308b\u3068\u3044\u3046\u3053\u3068\u3082\u53ef\u80fd\u306a\u3088\u3046\u3067\u3059\u3002<\/p>\n

\uff08\u203b\uff09\u6ce8\u610f\u70b9\u3068\u3057\u3066\u3001DATAPUMP(expdp)\u3067\u4f5c\u6210\u3057\u305fdmp\u30d5\u30a1\u30a4\u30eb\u306f\u5916\u90e8\u8868\u306e\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u306f\u4f7f\u7528\u3067\u304d\u306a\u3044\u3088\u3046\u3067\u3059\u3002<\/p>\n

\u00a0\u4eca\u65e5\u306f\u4ee5\u4e0a\u307e\u3067<\/p>\n","protected":false},"excerpt":{"rendered":"

IT\u30b3\u30fc\u30c7\u30a3\u30cd\u30fc\u30bf\u306e\u30b7\u30e5\u30a6\u3067\u3059\u3002 \u5199\u771f\u306f\u3001\u524d\u56de\u3082\u8f09\u305b\u307e\u3057\u305f\u304c\u3001\u5bcc\u5c71\u306e\u4e94\u7b87\u5c71\u3068\u3044\u3046\u4e16\u754c\u907a\u7523\u5408\u638c\u9020\u308a\u96c6\u843d\u306b\u884c\u3063\u305f\u3068\u304d\u306e\u5199\u771f\u3067\u3059\u3002 \u3055\u3066\u3001\u3068\u3046\u3068\u3046\u30d6\u30e9\u30b8\u30eb\u30fb\u30ea\u30aa\u30c7\u30b8\u30e3\u30cd\u30a4\u30ed\u3067\u884c\u308f\u308c\u3066\u3044\u305f\u30d1\u30e9\u30ea\u30f3\u30d4\u30c3\u30af\u3082\u7d42\u308f\u308a\u307e\u3057\u305f\u3002\u30aa\u30ea\u30f3\u30d4\u30c3 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[21,27],"tags":[],"class_list":["post-1410","post","type-post","status-publish","format-standard","hentry","category-select","category-27"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1410"}],"version-history":[{"count":15,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1410\/revisions"}],"predecessor-version":[{"id":1926,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1410\/revisions\/1926"}],"wp:attachment":[{"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}