# TOAD 16.3 Killed after alter table

**URL:** <https://forums.toadworld.com/t/toad-16-3-killed-after-alter-table/57032>\
**Category:** Toad for Oracle - Beta\
**Created:** [February 21, 2023, 3:43pm UTC](https://forums.toadworld.com/t/toad-16-3-killed-after-alter-table/57032 "2023-02-21T15:43:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![thierry.mara](https://avatars.discourse-cdn.com/v4/letter/t/34f0e0/32.png) [@thierry.mara](https://forums.toadworld.com/u/thierry.mara)\
**Post date:** [February 21, 2023, 3:43pm UTC](https://forums.toadworld.com/t/toad-16-3-killed-after-alter-table/57032/1 "2023-02-21T15:43:20Z")

</div>

Toad for Oracle Base (64-bit) 16.3.195.2040 : (idem in 16.2)

With the schema browser, I want to alter a table : (with 230 columns) :

clic on table, Alter =\> Toad killed !  
(Loading constraint to GUI...150 of 230, out of system ressource)

With a table with less columns it’s OK.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 21, 2023, 3:55pm UTC](https://forums.toadworld.com/t/toad-16-3-killed-after-alter-table/57032/2 "2023-02-21T15:55:55Z")

</div>

So, you don't just have 230 columns, you have 230 constraints also?

---

<div class="post-metadata">

**Author:** ![thierry.mara](https://avatars.discourse-cdn.com/v4/letter/t/34f0e0/32.png) [@thierry.mara](https://forums.toadworld.com/u/thierry.mara)\
**Post date:** [February 21, 2023, 4:05pm UTC](https://forums.toadworld.com/t/toad-16-3-killed-after-alter-table/57032/3 "2023-02-21T16:05:18Z")

</div>

I create a new table with 230 columns without constraint, on SYSTEM schema, it's the same, TOAD killed after Alter.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 21, 2023, 4:10pm UTC](https://forums.toadworld.com/t/toad-16-3-killed-after-alter-table/57032/4 "2023-02-21T16:10:52Z")

</div>

I can reproduce it if there are a lot of constraints (NOT NULL counts as a constraint).

I can load a table with 1000 columns without any problems if there are no constraints.

Thanks for reporting it. I'll investigate.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 21, 2023, 6:24pm UTC](https://forums.toadworld.com/t/toad-16-3-killed-after-alter-table/57032/5 "2023-02-21T18:24:43Z")

</div>

This will be fixed in the next beta.