Skip to Content

HANA EXPORT and IMPORT question

HI All,

If you give me some information about import that will be awesome ,

I am exporting a schema called DW and it has couple of views having definition pointing to other schema like below

create view DW.TEST select a,b,c from ss.log,bw.param etc

i am using the below syntax to export

EXPORT "DW"."*" AS BINARY INTO '/sapmnt/DW' WITH REPLACE;

and now i am importing that into new schema called DW_NEW using the below question

IMPORT "DW"."*"AS BINARY from '/sapmnt/DW' with REPLACE RENAME SCHEMA "DW" TO "DW_NEW";

now 2 questions

1) This import syntax is dropping tables ss.log and bw.param which is used in the view , why is it so and how to avoid it ??

2) next my import failes with strange error like


ImportExport.cpp(07179) : DROP TABLE "SECURITY"."*******" failed by unexpected exception: ERROR [SQL-258] insufficient privilege: Not authorized at /sapmnt/ld7272/a/HDB/jenkins_prod/workspace/HANA__FA_CO_LIN64GCC48HAPPY_rel_fa~hana1sp12/s/ptime/query/checker/query_check.cc:3731 exception 1: no.71000258 (ptime/query/checker/query_check.cc:3731)

why it is trying to a drop a table in security schema ??

Any thoughts will be really really appreciated , thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers