Table doesnt exist in database error 00959

[Former Member]

hi

when i try to transport a request it failed , shows the error table z3ocap doesnt exist. when i try to open the table in se11

it shows all the fields but doesnt show the content . it gives the same error table z3ocap doesnt exist. its with status partial active. i searched in oracle level ...it shows table or view doesnt exist...it was there previously and i tried to create the table in database using database utilities...in se11 . after the job is finished the status is still partial active...

this table exist in my dev and production system.

please help me to solve this issue...as it more related to database..

i am also getting oracle error 00959..PSAPEXCELPOSD doesnt exist. i checked the table spaces it has only PSAPEXCELPOSDD not PSAPEXCELPOSD.

how can i change the table status from partial active to active?

[Former Member]

Hi,

isn't there a log for the activation, is there? If not, you might check sm21 for some error messages regarding your activation. Let us know.

regards

Siggi

[Former Member]

hello;

thanks for response.....

In sm21 i am getting this error

Database error 959 for EXE.

Database error &6 for &9

After the attempt to call a database operation, the database system has returned the error code specified in the message, which indicates that the operation concerned could not be executed successfully.

regards

seethy

[Former Member]

Hi,

I found a note https://websmp202.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=495256&_NLANG...

related to that issue. It is a pretty old one but it describes what to do to get more information about it. I recommend to do that with a basis person.

regards

Siggi

[Former Member]

Thanks a lot for your help..

I solved this issue by exporting this same table from development system.

regards

seethy