TABLE DROPPED IN EXPORT/IMPORT SCHEMA

[former_member805602]

A strange thing happened to me.

Performing a DB schema export/import with file binary in Hana

on two different environments it happened that I found tables of a schema that was not exported WERE DROPPETD!

The two schemas are not dependent on each other. so my question is how is this possible?

Has this ever happened to you?

Thank you

[yogananda]

It is possible that the tables were dropped due to a mistake during the export/import process. It is also possible that there was an issue with the database or system that caused the tables to be dropped.

To prevent this from happening in the future, you can try using a backup and recovery solution like SAP HANA backup and recovery . You can also try using the SAP HANA cockpit to monitor your database and system for any issues .

I hope this helps. Let me know if you have any other questions.

[yogananda]

simone.rep

I am sorry to hear about this strange thing that happened to you while performing a DB schema export/import with file binary in Hana. This situation could happen if the export/import procedure was not done properly, or if there is an underlying issue with the databases on either environment that caused the tables to be dropped. To ensure this does not happen again, I would suggest double-checking the procedure as well as making sure the databases on both environments are healthy and up-to-date. If the problem persists, I would recommend consulting a professional to get further assistance in resolving the issue.

[former_member805602]

Hi
Thank you for reply. But It seems absurd to me that tables of a non-exported schema have been deleted.
I don't understand this behavior

[yogananda]

simone.rep

Try to reproduce it , record and share it HANA Database Support via ticket.. we can see if there is any bug by reproducing it internal.