oracle20c最新版本,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:
打赏
微信扫一扫，打赏作者吧～
