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
And the following line appears in the command line:
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:

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?

Asked by Nikolas
(101 rep)
Mar 9, 2021, 01:59 PM
Last activity: Mar 9, 2021, 02:47 PM
Last activity: Mar 9, 2021, 02:47 PM