Oracle - enlarge array definition

Question

I have defined custom type in Oracle db 12c.

create or replace type integer_varray as varray (4000) of int;

Now I realized that I need more than 4 000 records over there so I would like to extend this definition to 5 000 without loosing all data that are already in these arrays.

Is it possible? How?

EDIT: usage is like

create table capacities
(
  id       int generated by default as identity (START WITH 1000000) not null
  ... other fields
  capacity integer_varray                                            not null
);

Kaushik Nayak · Accepted Answer · 2019-01-10 09:47:21Z

4

Yes, you can using ALTER TYPE .. MODIFY LIMIT with CASCADE option

ALTER TYPE integer_varray  MODIFY LIMIT 5000 CASCADE;

Demo

answered Jan 10, 2019 at 9:47

Kaushik Nayak

32k6 gold badges36 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle - enlarge array definition

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related