on 03-14-2018 1:22 PM
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
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.