Skip to Content
0
Former Member
Mar 19, 2009 at 04:51 PM

Error apdapting database using database utility(transaction se11)

191 Views

Hello;

We have a several z* tables of an aplicattion running for a year in a production enviroment. We have to change 4 data elements used in these tables.

These elements were QUAN 4 decimals 0 and we have to pass to QUAN 4 decimals 2. I have change the data element in the devolopment enviroment by adjusting these tables with database utility(transaction se11) without problems. The values were transformed adding 2 decimals.

I try to do the same in the quality eviroment(production copy) and appears an error adapting these fields. The tables have a lot of registers (more than 100.000 ) the error DBIF_RSQL_SQL_ERROR; the table appears in the dicctionary but it is not created in the ORACLE.

Do you know how can I finish this step?. It is possible these transformation QUAN 4 decimals 0 to QUAN 4 decimals 2?? In development I have not problem.

Thanks in advanced.