on 09-15-2014 10:55 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.