topic Re: do i lost data in roll back table conversion? in Application Development and Automation Discussions

do i lost data in roll back table conversion?

Former Member — Sun, 24 Apr 2016 15:39:00 GMT

hi my friends.

i have a serious problem in adjusting a z table in se14.

i change the type of a field from chr to num .

but i got this error : "adjustment terminated in step 5"

i search and find this link :

how to roll back table conversion? - Technology Troubleshooting Guide - SCN Wiki

now i have a question : if i do rool back table , do i lost all of the data ?

i have big and really important data in my table.

please help me.

thanks.

Re: do i lost data in roll back table conversion?

Sandra_Rossi — Sun, 24 Apr 2016 17:51:02 GMT

The principle of this wiki page is "how to restore the table in its original state (definition and content) if a database conversion fails". As you may deduce from this page, the old table content is in table QCM<your Z table> (at Oracle level, not in DDIC), so if you're unsure of what happens, do backup this QCM table.

Re: do i lost data in roll back table conversion?

Former Member — Mon, 25 Apr 2016 07:55:35 GMT

i do this.

and i dont lose data of table, thanks for your replay.

Re: do i lost data in roll back table conversion?

Former Member — Tue, 26 Apr 2016 10:53:58 GMT

Hi Mansoureh,

You Can adjust the table using SE14.

First you have to unlock the current table and then Drop the table.

then copy the current table in new table.

you will not loose any data.

But before applying on this table kindly create a test table first and adjust it using the same above mentioned method.

Regards

Sunil Dhakad

<Contact information removed>

Message was edited by: Gareth Ryan Please don't share private contact details in public threads - add them to your personal profile instead.

Re: do i lost data in roll back table conversion?

Former Member — Tue, 26 Apr 2016 11:18:58 GMT

i do the same thing.

thanks for your help.