3 Replies Latest reply on Oct 26, 2016 8:34 AM by Thierry Poels

[4.2EA] Table edit not always working

Thierry Poels Oct 20, 2016 7:40 AM

Hi,

Editing tables seems to fail very often.

Issues encountered :
- when adding columns and naming them, they sometimes get renamed back to "COLUMNx"
- when adding/editing columns added column comments sometimes get lost

best regards,

Thierry Poels

[ SQL Developer Version 4.2.0.16.260 Build 16.260.1303 on Windows 7 ]

1. Re: [4.2EA] Table edit not always working

thatJeffSmith-Oracle Oct 20, 2016 8:07 PM (in response to Thierry Poels)

how are you adding the column?

right click > edit table

adding column

i added two columns...clicked around, changed data types, added comments, etc - couldn't get the column names to reset as you describe.
Like Show 0 Likes(0)

Actions
2. Re: [4.2EA] Table edit not always working

Thierry Poels Oct 21, 2016 10:39 AM (in response to thatJeffSmith-Oracle)

Quick test :

I created a new table TABLE1 with
COL_A varchar2(20) comment aaa
COL_B varchar2(20) comment bbb

then edit TABLE1 (right click - edit table)
add COL_C varchar2(20) comment ccc

[OK]
==> COLUMN1 varchar2(20) without commend added

again edit TABLE1
add COL_D number(10) comment ddd

[OK]
==> COLUMN2 number(10) without commend added
(lost column name and comment but datatype was preserved)

FYI : just had a similar issue when creating a table.
Like Show 0 Likes(0)

Actions
3. Re: [4.2EA] Table edit not always working

Thierry Poels Oct 26, 2016 8:34 AM (in response to Thierry Poels)

( sorry for the low quality video )
Like Show 0 Likes(0)

Actions

Go to original post