topic Re: Problem with restore a data in one table. in Application Development and Automation Discussions

Problem with restore a data in one table.

Former Member — Wed, 17 Jan 2007 14:47:51 GMT

Hi people!

In the client 100 of QA I delete the table FAGLFLEXT in the se14 transaction.

Someone know what can I do to restore the data?

Thanks!

Re: Problem with restore a data in one table.

Former Member — Wed, 17 Jan 2007 14:50:20 GMT

Hi,

At a field level, go to data element if the chek-box for data element is checked, the i think you can retrive it from CDHDR and CDPOS tables.

Regards,

Santosh

Re: Problem with restore a data in one table.

RichHeilman — Wed, 17 Jan 2007 14:50:21 GMT

ooops........... The data is gone. The only way I know, is to restore the table on the underlying database from your backup.

Regards,

Rich Heilman

Re: Problem with restore a data in one table.

Former Member — Wed, 17 Jan 2007 15:12:02 GMT

How can I go to the data level or make the restore?

Re: Problem with restore a data in one table.

RichHeilman — Wed, 17 Jan 2007 15:23:01 GMT

Well, you would have to know a little bit about what the "Behind the Scenes" of your SAP System. For example, what is the underlying database and the system in which it runs on and how do you manipulate it. In my case, I come from an DB2 / AS/400 background, so I know exactly how to restore a table from tape on my system, of course, it varies from system to system. It would be totally different if you are running Oracle on a UNIX box.

Right about now is the time which you want to get your basis people involved in helping you to restore the data in the table.

Regards,

Rich Heilman

Re: Problem with restore a data in one table.

Former Member — Thu, 01 Nov 2007 21:52:32 GMT

Hi,

A user deleted entries out of a Z table. This table is in the PSAPBTABD tablespace. The size of this tablespace is 22GB. We have an online backup of this tablespace and the log files. (from Oracle) Is there a way to restore a single table out of the tablespace or do we have to restore the entire DB (which is 1TB, which is too big).

Thanks.