Skip to Content
0
Former Member
Sep 15, 2014 at 09:55 PM

Issue while importing schema in HANA

166 Views

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