Sample Header Ad - 728x90

Oracle XE 11.2.0 data pump expdb works on but impdb doesn't on Windows 10

0 votes
0 answers
695 views
New to Oracle DB administration here. I have a fresh localhost installation of Oracle XE 11.2.0 (x64 installation from here ) on my computer using Windows 10 64-bit. I am able to connect to the DB using both DataGrip using SYS as SYSDBA user and I am able to connect using sqlplus command-line tool. I typed an admin password on installation but somehow I am able to connect using sys password sqlplus sys/sys as sysdba (as I said, I am an Oracle DB rookie). I have to import an exported EXP.DMP file from a colleague using the following command:
impdp.exe 'sys/sys as sysdba' FULL=Y DUMPFILE=exp.dmp REUSE_DATAFILES=Y TABLE_EXISTS_ACTION=REPLACE
Windows starts to complain: enter image description here And the following line appears in the command line:
c:\oraclexe\app\oracle\product\11.2.0\server\bin>impdp.exe 'sys/sys as sysdba' FULL=Y DUMPFILE=exp2.dmp REUSE_DATAFILES=Y TABLE_EXISTS_ACTION=REPLACE
Access is denied.

c:\oraclexe\app\oracle\product\11.2.0\server\bin>
**Important note:** I have tried to **export** instead to exp2.dmp in order to try another command and it works with no issue:
c:\oraclexe\app\oracle\product\11.2.0\server\bin>expdp.exe 'sys/sys as sysdba' FULL=Y DUMPFILE=exp2.dmp directory=DATA_PUMP_DIR logfile=exp.log

Export: Release 11.2.0.2.0 - Production on Tue Mar 9 14:41:51 2021

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
Starting "SYS"."SYS_EXPORT_FULL_01":  "sys/******** AS SYSDBA" FULL=Y DUMPFILE=exp2.dmp directory=DATA_PUMP_DIR logfile=exp.log
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 161.2 MB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
... omitted ...
Processing object type DATABASE_EXPORT/AUDIT
. . exported "APEX_040000"."WWV_FLOW_PAGE_PLUGS"         27.16 MB   38892 rows
... omitted ...
. . exported "SYSTEM"."SQLPLUS_PRODUCT_PROFILE"              0 KB       0 rows
Master table "SYS"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
  C:\ORACLEXE\APP\ORACLE\ADMIN\XE\DPDUMP\EXP2.DMP
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at 14:42:55


c:\oraclexe\app\oracle\product\11.2.0\server\bin>
___________ How to make the import successful? **Edit:** I have noticed something very odd in the C:\oraclexe\app\oracle\product\11.2.0\server\bin folder. I have installed the database engine using setup.exe and everything went smoothly. What's going on? Can I download the file anywhere for 11.2.0 XE without the un/installing again which would take another hour? enter image description here
Asked by Nikolas (101 rep)
Mar 9, 2021, 01:59 PM
Last activity: Mar 9, 2021, 02:47 PM