Skip to Content
0
Former Member
Sep 22, 2011 at 12:10 PM

No database table exists for table ZTAB1 after ORA-01438

129 Views

Dear friends,

We have a problem in our test system.

One developer performed a transport which tried to change column from length 11 to 10 and after the transport, table is missing from database. We observed ABAP dumps DBIF_RSQL_SQL_ERROR with ORA-01438 which suggested us that there was some problem with field lenght change. After discussin, we have find out the culprate filed.

But, with me now problem is Partially active table which Does not exist in the database.

So now, what i should do to fix this problem.. Shuld i again increase filed length manually in test system and then try to perform SE14>Continue adjustment or what ?

In SE14 : Analyze Adjustment provide this information :

******************************************************************************************************************

Seq of steps

1 Initialization

2 Dropping of indexes, renaming of original table

3 No action

4 Activation of transparent table

5 Conversion of data to new table, deletion of renamed table

6 Creation of sec. indexes

Adjustment terminated in step 5

******************************************************************************************************************

******************************************************************************************************************

Initial table Table type Status

ZTAB1 Transparent Renamed

Renamed original table

QCMZTAB1 transparent Existent

Tgt.table

ZTAB1 Transparent Renamed

******************************************************************************************************************

thanks

ashish