if this is not appropriate forum, please move it. this is my own Dev VM (win 7) to handle some old tasks related to Forms10g.
--===
please help importing .dmp file, my steps are as below:
SQL> CREATE DIRECTORY MYDIR AS 'C:\temp\Forms10g';
Directory created.
SQL> ED
Wrote file afiedt.buf
1* CREATE USER PAYROLL IDENTIFIED BY PAYROLL
SQL> /
User created.
SQL> GRANT DBA TO PAYROLL;
Grant succeeded.
SQL> GRANT READ, WRITE ON DIRECTORY MYDIR TO PAYROLL;
Grant succeeded.
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
SQL>
C:\temp\Forms10g>impdp payroll/payroll schemas=PAYROLL directory=MYDIR dumpfile=PRL_25082022.dmp logfile=impdpPAYROLL.log
Import: Release 10.1.0.4.2 - Production on Friday, 26 August, 2022 17:09
Copyright (c) 2003, Oracle. All rights reserved.
UDI-00008: operation generated ORACLE error 12560
ORA-12560: TNS:protocol adapter error
C:\temp\Forms10g>
regards
EDIT: When used connect string @XE it showing following error:
UDI-00008: operation generated ORACLE error 12154
ORA-12154: TNS:could not resolve the connect identifier specified