Skip to Content

Issue when moving Tables from Schema to another Schema

Dec 20, 2016 at 10:15 AM


avatar image
Former Member

I have a schema (standard_schema) which is having all the tables, as per the requirement i want to move the required tables to another Schema (demo_schema).

I executed the below code as per the below link

IMPORT "standard_schema"."*" FROM '/usr/sap/HBD/HBD02/work/STANDARD_SCHEMA' WITH RENAME SCHEMA STANDARD_SCHEMA TO demo_schema;

but i am getting the below error,

can any one please advise on the below error and how can get the schema path

Could not execute 'IMPORT "standard_schema"."*" FROM '/usr/sap/HBD/HBD02/work/standard_schema' WITH RENAME SCHEMA ...' SAP DBTech JDBC: [12]: cannot open file: Cannot open the path /usr/sap/HBD/HBD02/work/standard_schema

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers