Skip to Content
avatar image
Former Member

Issue when moving Tables from Schema to another Schema

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers