cancel
Showing results for 
Search instead for 
Did you mean: 

Issue when moving Tables from Schema to another Schema

Former Member
0 Kudos

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

https://www.youtube.com/watch?v=uxZvNE9xdB4

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

Accepted Solutions (0)

Answers (0)