cancel
Showing results for 
Search instead for 
Did you mean: 

Issue while importing schema in HANA

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Vinay,

Once you export the database objects to a folder, this folder will have two sub folders(index and export).

while importing also you have to select the location as till this main folder which is one level up to index.

Regards,

Venkat N.