do i lost data in roll back table conversion?

[Former Member]

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.

[Sandra_Rossi]

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.

[Former Member]

i do this.

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

[Former Member]

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.

[Former Member]

i do the same thing.

thanks for your help.