Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Importing without original schema owner


If I export with the following statement:

export <SCHEMA_A>."*" as BINARY into '<DIRECTORY>' with replace threads 16;

I then copy the export files to another SAP HANA instance where I don't have a <SCHEMA_A>, how would I import it ? Is the <SCHEMA_A> prefix required ? Does it get created automatically like when a rename schema option is executed ?

import <SCHEMA_A>."*" as BINARY from '<DIRECTORY>' with replace threads 16;

Is having the original schema mandatory ? What if the original schema was dropped but the export files still exist ?

Thank you in advance,


Former Member
Not what you were looking for? View more on this topic or Ask a question