cancel
Showing results for 
Search instead for 
Did you mean: 

Schema import error

10-02-2020 6:42 PM
mario_galeano Participant
571 views 2 comments
0 Likes
SAP Managed Tags
Subscribe

When trying to restore a backup that was made with the export script, it shows the following error:

the schema to which the error is mentioning is a schema that was made as a test, which was no longer being used and was eliminated

scripts used:

EXPORT "SAP_JYB"."*" AS BINARY INTO
'/usr/sap/NDB/HDB00/backup/data/0210'
WITH REPLACE THREADS 10
NO DEPENDENCIES;




IMPORT "SAP_JYB"."*" AS BINARY from '/usr/sap/NDB/HDB00/backup/data/0210' WITH IGNORE EXISTING THREADS 10 RENAME SCHEMA "SAP_JYB" TO "PRUEBA_JYB";
0 Likes

Accepted Solutions (0)

Answers (1)

Answers (1)

msundararaja_perumal
Active Contributor
0 Likes

mario.galeano,

I believe sap note-1981315 - HANA import fails with error "not found in the import directory" will help you to address the issue.

Please follow the instructions carefully while executing scripts.

Thanks.

mario_galeano
Participant
0 Likes

Hello msundararaja.perumal

I already found the problem, I removed this part of the script and I import it without inconvenience:

NO DEPENDENCIES;

What is that part of the script for?

Thanks,

Mario