Situation:
There is a ~34GB database running on Oracle 11g on Oracle Linux.
I am trying to migrate several schemas from this old server into a brand new, shiny, never-before-used installation of Oracle XE 18c running on a Windows 2016 server.
I have tried the migration as expdp/impdp through SQL Developer; I'm logged into both source and target databases as SYSTEM, I have tried export and import as specifically the DDL for the full database, and separately as specific schemas. I attempted to set up remaps of the crucial Schemas and tablespaces. However it simply doesn't work; no errors are generated during export, but despite documentation claiming that import of a full database using an account with CREATE USER etc. privileges, every attempt at import fails on largely everything. Examples of errors:
(names removed, replaced with "...")
ORA-39083: Object type TYPE:"SYSMAN"."..." failed to create with error:
ORA-01435: user does not exist
ORA-39083: Object type USER:"..." failed to create with error:
ORA-65096: invalid common user or role name
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role ... does not exist
and
(path removed, replaced with "...")
CREATE TABLESPACE "TS1A" DATAFILE '...' SIZE 3145728000
LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE
DEFAULT NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
ORA-39083: Object type TABLESPACE:"TS1B" failed to create with error:
ORA-01119: error in creating database file '...'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
-- this is despite attempting the Remap options.
Advice, please?