Manually Import E1Local Database on Fat Client

Manually Import E1Local Database on Fat Client

Step 1 - Decrypt the password
C:\e920\system\bin32
ReconfigureDB.exe to set decrypt password

Step 2 - Import JDELOCAL_PY920

CREATE USER JDELOCAL_PY920 IDENTIFIED BY JDELOCAL_PY920;

GRANT CREATE SESSION, ALTER SESSION, CREATE TABLE, CREATE VIEW TO JDELOCAL_PY920;

CREATE OR REPLACE DIRECTORY PKGDIR AS 'C:\E920_1\PY920\data\' ;

impdp TRANSPORT_DATAFILES='C:\E920_1\PY920\data\jdelocal_py920.dbf' DIRECTORY=PKGDIR DUMPFILE='jdelocal_py920.dmp' REMAP_TABLESPACE=JDELOCAL:JDELOCAL_PY920 REMAP_SCHEMA=JDELOCAL:JDELOCAL_PY920 LOGFILE='impjdelocal_py920.log'

ALTER TABLESPACE JDELOCAL_PY920 READ WRITE ;

ALTER USER JDELOCAL_PY920 DEFAULT TABLESPACE JDELOCAL_PY920 QUOTA UNLIMITED ON JDELOCAL_PY920;

Step 3- Import SPEC_PY920


CREATE USER SPEC_PY920FB IDENTIFIED BY SPEC_PY920FB;

GRANT CREATE SESSION, ALTER SESSION, CREATE TABLE, CREATE VIEW TO SPEC_PY920FB ;

CREATE OR REPLACE DIRECTORY PKGDIR AS 'C:\E920_1\PY920\spec\' ;

impdp TRANSPORT_DATAFILES='C:\E920_1\PY920\spec\spec_py920fb.dbf' DIRECTORY=PKGDIR DUMPFILE='spec_py920fb.dmp' REMAP_TABLESPACE=SPEC__PY920FB:SPEC_PY920FB REMAP_SCHEMA=SPEC__PY920FB:SPEC_PY920FB LOGFILE='impspec_py920fb.log'

ALTER TABLESPACE SPEC_PY920FB READ WRITE ;

ALTER USER SPEC_PY920FB DEFAULT TABLESPACE SPEC_PY920FB QUOTA UNLIMITED ON SPEC_PY920FB ;

Step 4 - Encrypt the password
C:\e920\system\bin32
ReconfigureDB.exe to set encrypt password