Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 24, 2015 at 05:13 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded