Skip to Content

Renaming an SAP HANA Schema

Oct 25, 2017 at 06:55 PM


avatar image
Former Member


Is there a way to find invalid objects belonging to users that have been dropped. For example, we had a few BI developers develop their own views using their login names. Once they moved on, the security team dropped their logins. Unfortunately, these objects are still referenced/linked to the _SYS_BIC schema. During an export/import w/ schema rename of the original base schema, we encounter errors related to these objects.

Is there a way to identify these objects before we start the export/import process ?

SAP HANA 1.22.04
SUSE Linux 11 SP3

Thank you in advance...



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sergio Guerrero Oct 25, 2017 at 10:06 PM

check if deleting the deleting the user, removes their schema and therefore all the objects tied to them.

10 |10000 characters needed characters left characters exceeded
Lars Breddemann
Oct 30, 2017 at 04:20 AM

That's expected and documented behaviour. When dropping tables, dependent objects like views or synonyms don't automatically get dropped.

Instead, the dependent objects get invalidated. This provides the option to check for invalidated objects after the base objects have been dropped. (E.g. system table VIEWS has a IS_VALID field).

With this information, you can create a list of invalid objects and make sure that all of them are corrected or deleted before you transport your development.

10 |10000 characters needed characters left characters exceeded