Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Issue while importing schema in HANA

Hello Everyone,

I have an error while performing an export/ import from two different systems in HANA.

The EXPORT works fine. I have exported the schema to a shared path and then transferred it to a path accessible in the target system.

From the target location , when I try to IMPORT the schema, I get the following error:

column store error: logical index creation error:  [2007] Index does not exist; Hierarchy source query: invalid table or view reference

Now I am using the below IMPORT query:

IMPORT "*"."*" AS BINARY FROM '<exported_schema_location in the target system > 'WITH REPLACE RENAME SCHEMA "<old_schema>" TO "<new schema>" THREADS 16

Kindly help me

Regards,
Vinay

Former Member
Not what you were looking for? View more on this topic or Ask a question