Manually import PY910 full package spec database to E1LOCAL

1. Application:

   J.D. Edwards E910

   
   

   Issue:

   Something wrong with the JDE client installation, the pathcode spec database was left out and not attached to the E1Local. Re-install the full package doesn't solve the issue.
   
   

   Resolution:

   Manually import the E910 PY910 full package spec database
   
   
   

   In CMD:
   
   

   sqlplus / as sysdba
   
   create user SPEC_PY910FA identified by SPEC_PY910FA;
   
   GRANT CREATE SESSION, ALTER SESSION, CREATE TABLE, CREATE VIEW TO SPEC_PY910FA;
   
   create or replace directory ATTACHDB as 'C:\E910\PY910\spec';
   
   GRANT READ, WRITE ON DIRECTORY ATTACHDB TO system;
   
   
   exit
   
   impdp \"/ as sysdba\" DIRECTORY=ATTACHDB DUMPFILE=SPEC_PY910FA.dmp TRANSPORT_DATAFILES=C:\E910\PY910\spec\SPEC_PY910FA.DBF REMAP_SCHEMA=SPEC__PY910FA:SPEC_PY910FA REMAP_TABLESPACE=SPEC__PY910FA:SPEC_PY910FA logfile=Import_SPEC_PY910FA_100614.log
   
   result:-
   Import: Release 11.2.0.1.0 - Production on Wed Jun 11 00:18:12 2014
   Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
   Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
   

   Master table "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded

   Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_01":  "/******** AS SYSDBA" DIRECTORY=A

   TTACHDB DUMPFILE=SPEC_PY910FA.dmp TRANSPORT_DATAFILES=E:\E910\PY910\spec\SPEC_PY

   910FA.DBF REMAP_SCHEMA=SPEC__PY910FA:SPEC_PY910FA REMAP_TABLESPACE=SPEC__PY910FA

   :SPEC_PY910FA logfile=Import_SPEC_PY910FA_100614.log

   Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK

   Processing object type TRANSPORTABLE_EXPORT/TABLE

   Processing object type TRANSPORTABLE_EXPORT/GRANT/OWNER_GRANT/OBJECT_GRANT

   Processing object type TRANSPORTABLE_EXPORT/INDEX

   Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT

   Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS

   Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK

   Job "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 00:18:22

   ---------------------------------------------------------------------------
   
   

   sqlplus / as sysdba
   
   

   alter user SPEC_PY910FA default tablespace SPEC_PY910FA quota unlimited on SPEC_PY910FA;
   
   

   alter TABLESPACE SPEC_PY910FA READ WRITE;
   
   

   exit
   
   References:
   http://www.oracle-base.com/articles/misc/transportable-tablespaces.php
   http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php#ExternalTables.