Print Thread
Blockchain and inmutable tables
#63922 05/12/22 06:52 AM
Joined: Sep 2019
Posts: 34
Spain
E
El Offline OP
Member
OP Offline
Member
E
Joined: Sep 2019
Posts: 34
Spain
Hello:

In Version "15.0.0.2050 (64 bit)" when we have an immutable table and the DDL is generated, it is not put into the script.

Example:

SQL Query
create immutable table it_t1 (
  id            number,
  fruit         varchar2(20),
  quantity      number,
  created_date  date,
  constraint it_t1_pk primary key (id)
)
no drop until 0 days idle
no delete until 16 days after insert;

PL/SQL Developer script:

SQL Query
-- Create table
create table IT_T1
(
  id           NUMBER not null,
  fruit        VARCHAR2(20),
  quantity     NUMBER,
  created_date DATE
)
tablespace DATOS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table IT_T1
  add constraint IT_T1_PK primary key (ID)
  using index 
  tablespace DATOS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


-------------------------------
Elias F.M.
Re: Blockchain and inmutable tables
El #63923 05/12/22 08:46 AM
Joined: Aug 1999
Posts: 22,174
Member
Offline
Member
Joined: Aug 1999
Posts: 22,174
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.035s Queries: 16 (0.017s) Memory: 2.5000 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-03-29 10:34:29 UTC
Valid HTML 5 and Valid CSS