{"id":3988,"date":"2018-07-01T13:13:15","date_gmt":"2018-07-01T04:13:15","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3988"},"modified":"2018-07-01T13:15:34","modified_gmt":"2018-07-01T04:15:34","slug":"oracle-12c-ilm-%ed%85%8c%ec%8a%a4%ed%8a%b8","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3988","title":{"rendered":"Oracle 12c ILM \ud14c\uc2a4\ud2b8"},"content":{"rendered":"

In-Database Row Archiving<\/h2>\n

\uc774\ubc88 \uc2e4\uc2b5\uc740 \ud14c\uc774\ube14 \ub0b4 \ub85c\uc6b0\ub97c \ubcf4\uc774\uc9c0 \uc54a\uac8c \ucc98\ub9ac\ud568\uc73c\ub85c\uc368 \uc544\uce74\uc774\ube59\uc744 \ud558\ub294 In-Database Row Archiving \uc744 \uc2e4\uc2b5\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. [PDB1]\uc5d0\uc11c \uc9c4\ud589\ud569\ub2c8\ub2e4.<\/p>\n

\uba3c\uc800 [PDB1]\uc5d0 SYS \uc720\uc800\ub85c \uc811\uc18d\ud558\uc5ec \uc2e4\uc2b5 \uc720\uc800\uc778 HR \uacc4\uc815\uc758 \uc554\ud638\uc640 \uc0c1\ud0dc\ub97c \ubcc0\uacbd\ud55c \ud6c4, CTAS \uad6c\ubb38\uc73c\ub85c \ud14c\uc2a4\ud2b8\uc6a9 \ud14c\uc774\ube14 EMP_ARCH\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
[oracle@New-Features-12c ~]$ sqlplus sys\/oracle_4U@pdb1 as sysdba<\/span>
\n<\/span><\/p>\n

SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 30 08:47:29 2015
\n<\/span><\/p>\n

Copyright (c) 1982, 2014, Oracle. All rights reserved.
\n<\/span><\/p>\n

Connected to:
\n<\/span><\/p>\n

Oracle Database 12c EE Extreme Perf Release 12.1.0.2.0 – 64bit Production
\n<\/span><\/p>\n

With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
\n<\/span><\/p>\n

and Real Application Testing options
\n<\/span><\/p>\n

SQL> alter user hr identified by hr account unlock;<\/span>
\n<\/span><\/p>\n

User altered.
\n<\/span><\/p>\n

SQL> connect hr\/hr@pdb1<\/span>
\n<\/span><\/p>\n

Connected.
\n<\/span><\/p>\n

SQL> create table emp_arch as select employee_id,first_name from employees where rownum <=4;<\/span>
\n<\/span><\/p>\n

Table created.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

EMP_ARCH \ud14c\uc774\ube14\uc758 Row Archiving \uc744 enable \uc2dc\ud0b5\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> alter table emp_arch row archival;<\/span>
\n<\/span><\/p>\n

Table altered.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\uc774\uc81c \ud14c\uc774\ube14 \uad6c\uc870\ub97c \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. Row Archiving\uc744 enable \ud588\uc744 \ub54c \ub098\ud0c0\ub098\ub294 \ud788\ub4e0 \uce7c\ub7fc\uc778 ora_archive_state \uce7c\ub7fc\uc740 Describe \uba85\ub839\uc5d0\uc11c\ub294 \ub098\ud0c0\ub098\uc9c0 \uc54a\uace0 \ucffc\ub9ac\uc5d0\uc11c \ud574\ub2f9 \uce7c\ub7fc\uc744 \uba85\uc2dc\ud588\uc744\ub54c\ub9cc \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/p>\n

ora_archive_state \uac12\uc774 0\uc778 \uac83\uc740 Row Archiving \ub300\uc0c1\uc774 \uc544\ub2c8\ub77c\ub294 \ub73b\uc774\uba70, \ucffc\ub9ac \uc218\ud589 \uc2dc \ubcf4\uc5ec\uc9c0\ub294 \ub85c\uc6b0\uc785\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> set lines 70<\/span>
\n<\/span><\/p>\n

SQL> col ora_archive_state for a20<\/span>
\n<\/span><\/p>\n

SQL> desc emp_arch<\/span>
\n<\/span><\/p>\n

Name Null? Type
\n<\/span><\/p>\n

———————————– ——– ————————
\n<\/span><\/p>\n

EMPLOYEE_ID NUMBER(6)
\n<\/span><\/p>\n

FIRST_NAME VARCHAR2(20)
\n<\/span><\/p>\n

SQL> select employee_id,first_name,ora_archive_state from emp_arch;<\/span>
\n<\/span><\/p>\n

EMPLOYEE_ID FIRST_NAME ORA_ARCHIVE_STATE<\/span>
\n<\/span><\/p>\n

———– ——————– ——————–
\n<\/span><\/p>\n

100 Steven 0
\n<\/span><\/p>\n

101 Neena 0
\n<\/span><\/p>\n

102 Lex 0
\n<\/span><\/p>\n

103 Alexander 0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\uc870\ud68c \uc2dc ora_archive_state \uc744 \uba85\uc2dc\ud558\uc9c0 \uc54a\uc73c\uba74 \ub098\ud0c0\ub098\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> select * from emp_arch;<\/span>
\n<\/span><\/p>\n

EMPLOYEE_ID FIRST_NAME
\n<\/span><\/p>\n

———– ——————–
\n<\/span><\/p>\n

100 Steven
\n<\/span><\/p>\n

101 Neena
\n<\/span><\/p>\n

102 Lex
\n<\/span><\/p>\n

103 Alexander<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

dbms_ilm.archivestatename \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud574\uc11c employee_id \uac00 102, 103 \uc778 \ub85c\uc6b0\uc5d0 \ub300\ud574 ora_archive_state \uc0c1\ud0dc\ub97c 1\ub85c \uc5c5\ub370\uc774\ud2b8\ud558\uace0 EMP_ARCH \ud14c\uc774\ube14\uc744 \uc870\ud68c\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

employee_id \uac00 102, 103 \uc778 \ub85c\uc6b0\ub294 \ubcf4\uc774\uc9c0 \uc54a\uac8c \ub41c \uac83\uc744 \uc54c \uc218\uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> update emp_arch set ora_archive_state=dbms_ilm.archivestatename(1) where employee_id in (102,103);<\/span>
\n<\/span><\/p>\n

2 rows updated.
\n<\/span><\/p>\n

SQL> commit;<\/span>
\n<\/span><\/p>\n

Commit complete.
\n<\/span><\/p>\n

SQL> select employee_id,first_name,ora_archive_state from emp_arch;<\/span>
\n<\/span><\/p>\n

EMPLOYEE_ID FIRST_NAME ORA_ARCHIVE_STATE
\n<\/span><\/p>\n

———– ——————– ——————–
\n<\/span><\/p>\n

100 Steven 0
\n<\/span><\/p>\n

101 Neena 0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\uc544\uce74\uc774\ube59\ub41c \ub85c\uc6b0\ub97c \ubcfc \uc218 \uc788\uac8c \ud558\ub824\uba74 \uc544\ub798\uc640 \uac19\uc774 visibility \uc18d\uc131\uc744 all\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> alter session set row archival visibility = all;<\/span>
\n<\/span><\/p>\n

Session altered.
\n<\/span><\/p>\n

SQL> select employee_id,first_name,ora_archive_state from emp_arch;
\n<\/span><\/span><\/p>\n

EMPLOYEE_ID FIRST_NAME ORA_ARCHIVE_STATE
\n<\/span><\/p>\n

———– ——————– ——————–
\n<\/span><\/p>\n

100 Steven 0
\n<\/span><\/p>\n

101 Neena 0
\n<\/span><\/p>\n


\n102 Lex 1<\/span>
\n<\/span><\/p>\n


\n103 Alexander 1<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Active \uc0c1\ud0dc(\uc544\uce74\uc774\ube59 \ub418\uc9c0 \uc54a\uc740) \ub85c\uc6b0\ub9cc \ub098\ud0c0\ub098\uac8c \ud558\ub824\uba74 visibility \uc18d\uc131\uc744 active\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> alter session set row archival visibility = active;<\/span>
\n<\/span><\/p>\n

Session altered.
\n<\/span><\/p>\n

SQL> select employee_id,first_name,ora_archive_state from emp_arch;
\n<\/span><\/span><\/p>\n

EMPLOYEE_ID FIRST_NAME ORA_ARCHIVE_STATE
\n<\/span><\/p>\n

———– ——————– ——————–
\n<\/span><\/p>\n

100 Steven 0
\n<\/span><\/p>\n

101 Neena 0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Row Archiving \ub41c \ud14c\uc774\ube14\uc744 CTAS \uad6c\ubb38 \ub4f1\uc73c\ub85c \ubcf5\uc0ac\ud588\uc744 \ub54c \uc6d0 \ud14c\uc774\ube14\uc758 \uc544\uce74\uc774\ube59 \uc0c1\ud0dc \uc815\ubcf4\ub294 \ubcf5\uc0ac\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. EMP_ARCH \ud14c\uc774\ube14\uc758 \ubcf5\uc0ac\ubcf8\uc744 \uba3c\uc800 \ub9cc\ub4ed\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> create table emp_arch_copy as select employee_id, first_name from emp_arch;<\/span>
\n<\/span><\/p>\n

Table created.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\ubcf5\uc0ac\ud55c EMP_ARCH_COPY \ud14c\uc774\ube14\uc740 Row Archiving\uc744 enable \uc2dc\ud0a4\uc9c0 \uc54a\uc558\uae30 \ub54c\ubb38\uc5d0 \ud788\ub4e0 \uce7c\ub7fc ora_archive_state \ub97c \uac00\uc9c0\uace0 \uc788\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c ora_archive_state \uce7c\ub7fc\uc774 \uc5c6\ub2e4\ub294 \uc5d0\ub7ec\ub97c \ub9ac\ud134\ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> select employee_id,first_name,ora_archive_state from emp_arch_copy;<\/span>
\n<\/span><\/p>\n

select employee_id,first_name,ora_archive_state from emp_arch_copy
\n<\/span><\/p>\n

*
\n<\/span><\/p>\n

ERROR at line 1:
\n<\/span><\/p>\n

ORA-00904: “ORA_ARCHIVE_STATE”: invalid identifier<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

EMP_ARCH_COPY \ud14c\uc774\ube14\uc744 \ud788\ub4e0 \uce7c\ub7fc\uc740 \uc81c\uc678\ud558\uace0 \uc870\ud68c\ud558\uba74 \uc815\uc0c1 \ucd9c\ub825\ub429\ub2c8\ub2e4.<\/p>\n

\uc6d0\ubcf8 \ud14c\uc774\ube14\uc5d0\uc11c Row Archiving\uc774 enable \ub418\uc5b4 \uc788\uc5c8\ub354\ub77c\ub3c4 \uc774\ub97c \ubcf5\uc0ac\ud558\uac8c \ub418\uba74 \uc804\uccb4 \ub85c\uc6b0\uac00 \ubcf5\uc0ac\ub429\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> select employee_id,first_name from emp_arch_copy;<\/span>
\n<\/span><\/p>\n

EMPLOYEE_ID FIRST_NAME
\n<\/span><\/p>\n

———– ——————–
\n<\/span><\/p>\n

100 Steven
\n<\/span><\/p>\n

101 Neena
\n<\/span><\/p>\n

102 Lex
\n<\/span><\/p>\n

103 Alexander<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

row archival visibility \uc18d\uc131\uc744 ALL\ub85c \ubcc0\uacbd\ud55c \ud6c4, EMP_ARCH_COPY \ud14c\uc774\ube14\uc758 Row Archiving \uc744 enable \uc2dc\ud0a4\uba74 \uc774\uc81c ora_archive_state \uce7c\ub7fc\ub3c4 \uc870\ud68c\ud560 \uc218 \uc788\uac8c \ub429\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> alter session set row archival visibility = all;
\n<\/span><\/span><\/p>\n

Session altered.
\n<\/span><\/p>\n

SQL> alter table emp_arch_copy row archival;<\/span>
\n<\/span><\/p>\n

Table altered.
\n<\/span><\/p>\n

SQL> select employee_id, first_name, ora_archive_state from emp_arch_copy;<\/span>
\n<\/span><\/p>\n

EMPLOYEE_ID FIRST_NAME ORA_ARCHIVE_STATE
\n<\/span><\/p>\n

———– ——————– ——————–
\n<\/span><\/p>\n

100 Steven 0
\n<\/span><\/p>\n

101 Neena 0
\n<\/span><\/p>\n

102 Lex 0
\n<\/span><\/p>\n

103 Alexander 0<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\ub2e4\uc2dc EMP_ARCH_COPY \ud14c\uc774\ube14\uc5d0\uc11c employee_id \uac00 102, 103 \uc778 \ub85c\uc6b0\uc5d0 \ub300\ud574 ora_archive_state \uc0c1\ud0dc\ub97c 1\ub85c \uc5c5\ub370\uc774\ud2b8\ud558\uace0\ub098\uc11c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. 2\uac1c\uc758 \ub85c\uc6b0\ub294 active (visible), 2\uac1c\ub294 inactive \uc0c1\ud0dc\uc778 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9c8\ucc2c\uac00\uc9c0\ub85c EMP_ARCH \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub3c4 \ub2e4\uc74c \uc2e4\uc2b5 \ub2e8\uacc4\ub97c \uc704\ud574 \ud655\uc778\ud574 \ubcf4\uba74 EMP_ARCH_COPY \ud14c\uc774\ube14\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c 2\uac1c\uc758 \ub85c\uc6b0\ub294 active (visible), 2\uac1c\ub294 inactive \uc0c1\ud0dc\uc784\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> update emp_arch_copy set ora_archive_state=dbms_ilm.archivestatename(1) where employee_id in (102,103);<\/span>
\n<\/span><\/p>\n

2 rows updated.
\n<\/span><\/p>\n

SQL> commit;
\n<\/span><\/span><\/p>\n

Commit complete.
\n<\/span><\/p>\n

SQL> select employee_id,first_name,ora_archive_state from emp_arch_copy;<\/span>
\n<\/span><\/p>\n

EMPLOYEE_ID FIRST_NAME ORA_ARCHIVE_STATE
\n<\/span><\/p>\n

———– ——————– ——————–
\n<\/span><\/p>\n

100 Steven 0
\n<\/span><\/p>\n

101 Neena 0
\n<\/span><\/p>\n

102 Lex 1
\n<\/span><\/p>\n

103 Alexander 1
\n<\/span><\/p>\n

SQL> select employee_id,first_name,ora_archive_state from emp_arch;
\n<\/span><\/span><\/p>\n

EMPLOYEE_ID FIRST_NAME ORA_ARCHIVE_STATE
\n<\/span><\/p>\n

———– ——————– ——————–
\n<\/span><\/p>\n

100 Steven 0
\n<\/span><\/p>\n

101 Neena 0
\n<\/span><\/p>\n

102 Lex 1
\n<\/span><\/p>\n

103 Alexander 1<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

active\uc640 inactive \ub85c\uc6b0\uac00 \ud63c\uc7ac\ub418\uc5b4 \uc788\ub294 EMP_ARCH \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c EMP_ARCH_ARCH\ub85c \ubcf5\uc0ac\ud588\uc744 \ub54c \uc5b4\ub5bb\uac8c \ub418\ub294 \uc9c0 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774\ub54c \uae30\uc874 \ub370\uc774\ud130\uc640\uc758 \uad6c\ubd84\uc744 \uc704\ud574 “_New”\ub97c \ubd99\uc5ec insert \ud569\ub2c8\ub2e4.<\/p>\n

\uc55e\uc11c CTAS \uad6c\ubb38\uc73c\ub85c \ud14c\uc774\ube14 \ubcf5\uc0ac \uc2dc, \uc6d0 \ud14c\uc774\ube14\uc758 \uc544\uce74\uc774\ube59 \uc0c1\ud0dc \uc815\ubcf4\ub294 \ubcf5\uc0ac\ub418\uc9c0 \uc54a\uc558\ub358 \uac83\ucc98\ub7fc insert \u2026 select \uad6c\ubb38\uc5d0\uc11c\ub3c4 \uc544\uce74\uc774\ube59 \uc0c1\ud0dc \uc815\ubcf4\ub294 \ubcf5\uc0ac\ub418\uc9c0 \uc54a\uace0 \ubaa8\ub450 0, \uc989 active \uc0c1\ud0dc\ub85c \ub0a8\uc544 \uc788\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\n\n\n<\/colgroup>\n\n\n
SQL> insert into emp_arch_copy select employee_id, first_name||’_New’ from emp_arch;<\/span>
\n<\/span><\/p>\n

4 rows created.
\n<\/span><\/p>\n

SQL> commit;<\/span>
\n<\/span><\/p>\n

Commit complete.
\n<\/span><\/p>\n

SQL> select employee_id,first_name,ora_archive_state from emp_arch_copy;<\/span>
\n<\/span><\/p>\n

EMPLOYEE_ID FIRST_NAME ORA_ARCHIVE_STATE
\n<\/span><\/p>\n

———– ——————– ——————–
\n<\/span><\/p>\n

100 Steven 0
\n<\/span><\/p>\n

101 Neena 0
\n<\/span><\/p>\n

102 Lex 1
\n<\/span><\/p>\n

103 Alexander 1
\n<\/span><\/p>\n


\n100 Steven_New 0<\/span>
\n<\/span><\/p>\n


\n101 Neena_New 0<\/span>
\n<\/span><\/p>\n


\n102 Lex_New 0<\/span>
\n<\/span><\/p>\n


\n103 Alexander_New 0<\/span>
\n<\/span><\/p>\n

8 rows selected.
\n<\/span><\/p>\n

SQL> exit<\/span>
\n<\/span><\/p>\n

Disconnected from Oracle Database 12c EE Extreme Perf Release 12.1.0.2.0 – 64bit Production
\n<\/span><\/p>\n

With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
\n<\/span><\/p>\n

and Real Application Testing options<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

In-Database Row Archiving \uc774\ubc88 \uc2e4\uc2b5\uc740 \ud14c\uc774\ube14 \ub0b4 \ub85c\uc6b0\ub97c \ubcf4\uc774\uc9c0 \uc54a\uac8c \ucc98\ub9ac\ud568\uc73c\ub85c\uc368 \uc544\uce74\uc774\ube59\uc744 \ud558\ub294 In-Database Row Archiving \uc744 \uc2e4\uc2b5\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. [PDB1]\uc5d0\uc11c \uc9c4\ud589\ud569\ub2c8\ub2e4. \uba3c\uc800 [PDB1]\uc5d0 SYS \uc720\uc800\ub85c \uc811\uc18d\ud558\uc5ec \uc2e4\uc2b5 \uc720\uc800\uc778 HR \uacc4\uc815\uc758 \uc554\ud638\uc640 \uc0c1\ud0dc\ub97c \ubcc0\uacbd\ud55c \ud6c4, CTAS \uad6c\ubb38\uc73c\ub85c \ud14c\uc2a4\ud2b8\uc6a9 \ud14c\uc774\ube14 EMP_ARCH\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4. [oracle@New-Features-12c ~]$ sqlplus sys\/oracle_4U@pdb1 as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 30 08:47:29 […]<\/p>\n","protected":false},"author":1,"featured_media":2501,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[20],"tags":[1102,74,1103],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/oracle-12c.jpg?fit=594%2C426","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3988"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3988"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3988\/revisions"}],"predecessor-version":[{"id":3990,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3988\/revisions\/3990"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2501"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3988"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}