How to restore the table

[Former Member]

Dear All,

Executed the following query in the ABAP Editor.

EXEC SQL.

ALTER TABLE SAPONE.MARA

MOVE TABLESPACE PSAPONE

ENDEXEC.

Now the Table got corrupted and it is leading to dump while trying to view the table records. Here i'm moving the MARA from the same tablespace to PSAPONE.

Pl. tell me to restore the table by step by step.. as I'm only ABAP guy.

thanks & Regards

Mahesh

[former_member204746]

MARA is a huge table. it might take time to accomplish this task.

how long have you waited? and why are you playing with dangerous SQL commands?

[Former Member]

Hi Mahesh,

Hope you have run this in Development region.

Get hold of the DBA and check database logs to verify if any curruption of the table was logged. Get him to verify the object from his end and check the version of you database and if flashback was active.

If the table is currupt and DBA is not able to use flashback (it depends on UNDO tablespace size and version of your database) you will have to perform database restore and do a point in time recovery before the command was executed.

Regards,

Nisch