首页 » ORACLE, ORACLE [C]系列 » Oracle DUL支持Oracle 20c

Oracle DUL支持Oracle 20c

之前测试过《DUL 支持Oracle 19c》,目前ORACLE 20C官方文档已发布, 按惯例2020年第一季度会发布ON cloud平台版本和工程系统,第二季度会发布可下载非工程系统版本,我先尝尝鲜搞个测试版本使用DUL测试是否继续支持20c,包括blockchain table.

[oracle@anbob19 ~]$ . 20cenv
[oracle@anbob19 ~]$ ora

SQL*Plus: Release 20.0.0.0.0 - Production on Wed Feb 19 21:24:17 2020
Version 20.2.0.0.0
Copyright (c) 1982, 2020, Oracle.  All rights reserved.
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB                        MOUNTED

SQL> alter pluggable database orclpdb open;
Pluggable database altered.

SQL> alter session set container=orclpdb;
Session altered.

SQL> create user anbob identified by anbob;
User created.

SQL> grant create session,create table to anbob;
Grant succeeded.

SQL> alter user anbob quota unlimited on users;
User altered.

SQL> create table anbob.tobj as select * from dba_objects;
Table created.

SQL> create blockchain table bc_tab1(id number,name varchar2(10), price number (                                                                      6,2))
  2  no drop until 31 days idle
  3  no delete locked
  4  hashing using "SHA2_512" version "v1.0";
create blockchain table bc_tab1(id number,name varchar2(10), price number (6,2))
*
ERROR at line 1:
ORA-05716: unsupported hashing algorithm V1.0

SQL> create blockchain table anbob.bc_tab1(id number,name varchar2(10), price number (                                                                      6,2))
  2  no drop until 31 days idle
  3  no delete locked
  4  hashing using "SHA2_512" version "v1";

Table created.

SQL> insert into anbob.bc_tab1 values(1,'anbob',100.88);
1 row created.

SQL> insert into anbob.bc_tab1 values(2,'weejar',100.88);
1 row created.

SQL> commit;
Commit complete.

SQL> update anbob.bc_tab1 set id=id+1;
update anbob.bc_tab1 set id=id+1
             *
ERROR at line 1:
ORA-05715: operation not allowed on the blockchain table

SQL> alter system flush buffer_cache;
System altered.

— DUL

[oracle@anbob19 tools]$ ./dul

Data UnLoader: 12.0.0.0.3 - Internal Only - on Wed Feb 19 21:41:45 2020
with 64-bit io functions and the decompression option

Copyright (c) 1994 2019 Bernard van Duijnen All rights reserved.

 Strictly Oracle Internal Use Only


Within one week you will need a more recent DUL version for this os
DUL: Warning: Recreating file "dul.log"
DUL: Warning: ulimit process stack size is only 33554432
Found db_id = 4226385268
Found db_name = ANBOB20C
DUL> show datafiles;
ts# rf# start   blocks offs open  err file name
  0   1     0    35841    0    1    0 /u01/app/oracle/oradata/ANBOB20C/orclpdb/system01.dbf                                                                 
  1   4     0    46081    0    1    0 /u01/app/oracle/oradata/ANBOB20C/orclpdb/sysaux01.dbf                                                                      
  2   9     0    12801    0    1    0 /u01/app/oracle/oradata/ANBOB20C/orclpdb/undotbs01.dbf                                                                      
  5  12     0     1921    0    1    0 /u01/app/oracle/oradata/ANBOB20C/orclpdb/users01.dbf
                                                                      
DUL> bootstrap;

DUL> desc anbob.tobj
  2  ;
Table ANBOB.TOBJ
obj#= 74578, dataobj#= 74578, ts#= 5, file#= 12, block#=130
      tab#= 0, segcols= 27, clucols= 0
Column information:
icol# 01 segcol# 01        OWNER len  128 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 02 segcol# 02  OBJECT_NAME len  128 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 03 segcol# 03 SUBOBJECT_NAME len  128 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 04 segcol# 04    OBJECT_ID len   22 type  2 NUMBER(0)
icol# 05 segcol# 05 DATA_OBJECT_ID len   22 type  2 NUMBER(0)
icol# 06 segcol# 06  OBJECT_TYPE len   23 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 07 segcol# 07      CREATED len    7 type 12 DATE
icol# 08 segcol# 08 LAST_DDL_TIME len    7 type 12 DATE
icol# 09 segcol# 09    TIMESTAMP len   19 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 10 segcol# 10       STATUS len    7 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 11 segcol# 11    TEMPORARY len    1 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 12 segcol# 12    GENERATED len    1 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 13 segcol# 13    SECONDARY len    1 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 14 segcol# 14    NAMESPACE len   22 type  2 NUMBER(0)
icol# 15 segcol# 15 EDITION_NAME len  128 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 16 segcol# 16      SHARING len   18 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 17 segcol# 17  EDITIONABLE len    1 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 18 segcol# 18 ORACLE_MAINTAINED len    1 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 19 segcol# 19  APPLICATION len    1 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 20 segcol# 20 DEFAULT_COLLATION len  100 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 21 segcol# 21   DUPLICATED len    1 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 22 segcol# 22      SHARDED len    1 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 23 segcol# 23 IMPORTED_OBJECT len    1 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 24 segcol# 24 CREATED_APPID len   22 type  2 NUMBER(0)
icol# 25 segcol# 25 CREATED_VSNID len   22 type  2 NUMBER(0)
icol# 26 segcol# 26 MODIFIED_APPID len   22 type  2 NUMBER(0)
icol# 27 segcol# 27 MODIFIED_VSNID len   22 type  2 NUMBER(0)

DUL> desc anbob.bc_tab1;

Table ANBOB.BC_TAB1
obj#= 74580, dataobj#= 74580, ts#= 5, file#= 12, block#=1794
      tab#= 0, segcols= 13, clucols= 0
Column information:
icol# 01 segcol# 01           ID len   22 type  2 NUMBER(0)
icol# 02 segcol# 02         NAME len   10 type  1 VARCHAR2 cs 873(AL32UTF8)
icol# 03 segcol# 03        PRICE len   22 type  2 NUMBER(6,2)
icol# 04 segcol# 04 ORABCTAB_INST_ID$ len   22 type  2 NUMBER(0)
icol# 05 segcol# 05 ORABCTAB_CHAIN_ID$ len   22 type  2 NUMBER(0)
icol# 06 segcol# 06 ORABCTAB_SEQ_NUM$ len   22 type  2 NUMBER(0)
icol# 07 segcol# 07 ORABCTAB_CREATION_TIME$ len   13 type 181 TIMESTAMP(9) WITH TIME ZONE
icol# 08 segcol# 08 ORABCTAB_USER_NUMBER$ len   22 type  2 NUMBER(0)
icol# 09 segcol# 09 ORABCTAB_HASH$ len 2000 type 23 RAW
icol# 10 segcol# 10 ORABCTAB_SIGNATURE$ len 2000 type 23 RAW
icol# 11 segcol# 11 ORABCTAB_SIGNATURE_ALG$ len   22 type  2 NUMBER(0)
icol# 12 segcol# 12 ORABCTAB_SIGNATURE_CERT$ len   16 type 23 RAW
icol# 13 segcol# 13 ORABCTAB_SPARE$ len 2000 type 23 RAW

DUL> unload table anbob.tobj;
. unloading table                      TOBJ   73977 rows unloaded
DUL> unload table anbob.bc_tab1;
. unloading table                   BC_TAB1       2 rows unloaded

[oracle@anbob19 tools]$ cat ANBOB_BC_TAB1.dat
|1| |anbob| |100.88| |1| |31| |1| |19-FEB-2020 AD 13:33:45.852176000| |0| |1688D135A82CDDB17B470A9A016A8BF5F8D5C22DDDA8EA64715FEA7DD2EEFD1EB22DCA4E6AD762254F5D46B4AEC6080C38C5E10404EA601C84F92CC2EDAB637E| || || || ||
|2| |weejar| |100.88| |1| |31| |2| |19-FEB-2020 AD 13:33:45.863239000| |0| |623A61C11E71DC681F55CCD5CE89E77044988E536461392F7B43E1581F0392A46A90018E623C7AA237C39A7F51B99E70AD0217F5242283B058C5B1247E529171| || || || ||

dul还是继续支持Oracle 20c的,只是Blockchain Table的隐藏列也都unload 出来,当然恢复剩下的就简单了。

Related Posts:

打赏

,

对不起,这篇文章暂时关闭评论。