Skip to Content
author's profile photo
Former Member

How to restore the table

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 09:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 28, 2007 at 01:48 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded