impdp DP_USER/DP_USER directory=datapumps network_link=backup tablespaces=SDE

Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:"SDE"."VERSION" failed to create with error:
ORA-01918: user 'SDE' does not exist

QL> select 'CREATE USER ' || USERNAME || ' IDENTIFIED BY PASSWORD;' FROM DBA_USERS;

'CREATEUSER'||USERNAME||'IDENTIFIEDBYPASSWORD;'
------------------------------------------------------------------
CREATE USER MGMT_VIEW IDENTIFIED BY PASSWORD;
CREATE USER SYS IDENTIFIED BY PASSWORD;
CREATE USER SYSTEM IDENTIFIED BY PASSWORD;
CREATE USER DBSNMP IDENTIFIED BY PASSWORD;
CREATE USER SYSMAN IDENTIFIED BY PASSWORD;
CREATE USER BONGO IDENTIFIED BY PASSWORD;
CREATE USER SH IDENTIFIED BY PASSWORD;
CREATE USER HR IDENTIFIED BY PASSWORD;
CREATE USER DBADMIN IDENTIFIED BY PASSWORD;
CREATE USER OUTLN IDENTIFIED BY PASSWORD;
CREATE USER FLOWS_FILES IDENTIFIED BY PASSWORD;

'CREATEUSER'||USERNAME||'IDENTIFIEDBYPASSWORD;'
------------------------------------------------------------------
CREATE USER MDSYS IDENTIFIED BY PASSWORD;
CREATE USER ORDSYS IDENTIFIED BY PASSWORD;
CREATE USER EXFSYS IDENTIFIED BY PASSWORD;
CREATE USER WMSYS IDENTIFIED BY PASSWORD;
CREATE USER APPQOSSYS IDENTIFIED BY PASSWORD;
CREATE USER APEX_030200 IDENTIFIED BY PASSWORD;
CREATE USER OWBSYS_AUDIT IDENTIFIED BY PASSWORD;
CREATE USER ORDDATA IDENTIFIED BY PASSWORD;
CREATE USER CTXSYS IDENTIFIED BY PASSWORD;
CREATE USER ANONYMOUS IDENTIFIED BY PASSWORD;
CREATE USER XDB IDENTIFIED BY PASSWORD;

'CREATEUSER'||USERNAME||'IDENTIFIEDBYPASSWORD;'
------------------------------------------------------------------
CREATE USER ORDPLUGINS IDENTIFIED BY PASSWORD;
CREATE USER OWBSYS IDENTIFIED BY PASSWORD;
CREATE USER SI_INFORMTN_SCHEMA IDENTIFIED BY PASSWORD;
CREATE USER OLAPSYS IDENTIFIED BY PASSWORD;
CREATE USER SCOTT IDENTIFIED BY PASSWORD;
CREATE USER ORACLE_OCM IDENTIFIED BY PASSWORD;
CREATE USER XS$NULL IDENTIFIED BY PASSWORD;
CREATE USER BI IDENTIFIED BY PASSWORD;
CREATE USER PM IDENTIFIED BY PASSWORD;
CREATE USER MDDATA IDENTIFIED BY PASSWORD;
CREATE USER IX IDENTIFIED BY PASSWORD;

'CREATEUSER'||USERNAME||'IDENTIFIEDBYPASSWORD;'
------------------------------------------------------------------
CREATE USER DIP IDENTIFIED BY PASSWORD;
CREATE USER OE IDENTIFIED BY PASSWORD;
CREATE USER APEX_PUBLIC_USER IDENTIFIED BY PASSWORD;
CREATE USER SPATIAL_CSW_ADMIN_USR IDENTIFIED BY PASSWORD;
CREATE USER SPATIAL_WFS_ADMIN_USR IDENTIFIED BY PASSWORD;

DROP USER SDE CASCADE;

CREATE USER SDE
  IDENTIFIED BY <>
  DEFAULT TABLESPACE SDE
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;
  -- 15 System Privileges for SDE 
  GRANT CREATE SESSION TO SDE;
  GRANT ADMINISTER DATABASE TRIGGER TO SDE;
  GRANT CREATE TYPE TO SDE;
  GRANT CREATE PROCEDURE TO SDE;
  GRANT DROP PUBLIC SYNONYM TO SDE;
  GRANT CREATE SEQUENCE TO SDE;
  GRANT CREATE PUBLIC SYNONYM TO SDE;
  GRANT CREATE TABLE TO SDE;
  GRANT CREATE OPERATOR TO SDE;
  GRANT CREATE INDEXTYPE TO SDE;
  GRANT CREATE VIEW TO SDE;
  GRANT CREATE LIBRARY TO SDE;
  GRANT CREATE TRIGGER TO SDE;
  GRANT SELECT ANY TABLE TO SDE;
  GRANT UNLIMITED TABLESPACE TO SDE;
  -- 2 Object Privileges for SDE 
    GRANT DELETE, INSERT, SELECT, UPDATE ON SDE_MDR.SERVER_CONFIG TO SDE;
    GRANT DELETE, INSERT, SELECT, UPDATE ON SDE_WEBMAP.SERVER_CONFIG TO SDE;

impdp DP_USER/DP_USER directory=datapumps network_link=backup full=y INCLUDE=TABLESPACE:\"LIKE \'SDE\'\" INCLUDE=USER:\"LIKE \'SDE\'\" remap_datafile=\'D:\ORACLE\ORADATA\NETECHORATEST\SDE.DBF':\'C:\app\tmcallister\oradata\tmcall11gr2\SDE.DBF\'

directory=datapumps
network_link=backup
full=y
INCLUDE=TABLESPACE:"IN ('SDE','SDE_WEBMAP_GEODB')"
INCLUDE=SCHEMA:"IN ('SDE','WEBMAP_XBROKER')"
remap_schema=USERS:SDE_WEBMAP_GEODB
remap_datafile=D:\ORACLE\ORADATA\NETECHORATEST\SDE.DBF:C:\app\tmcallister\oradata\tmcall11gr2\SDE.DBF
remap_datafile=D:\ORACLE\ORADATA\NETECHORATEST\SDE_WEBMAP_GEODB:C:\app\tmcallister\oradata\tmcall11gr2\SDE_WEBMAP_GEODB.DBF