This content has been marked as final. Show 8 replies
Dean, thank you very much for your quick reply.
The objects are identical. I have not reached imp yet. The export gives me an error. Using 9i exp.exe which I copied from 9i directory to 11g BIN gives 'no listener' error. But the same syntax with original 11g exp.exe runs successfully. Is there anything you can think of that I can get the export to work?
Thank you again!
Thank you for helping me moving forward! After configured the connection in 9i client to 11g, the exp.exe did start and connect to 11g, but it hangs with a window error:
EXP.EXE has encountered a problem and needs to close. We are sorry for the inconvenience.
Can you suggest how to troubleshoot this error? This is new to me. I appreciate your help!
I do not have any experience with Windows, so will not be able to help much. Can you post the complete exp command and exp log file ? How long after export starts do you get this message ?
Pl see if MOS Doc 1154365.1 (How to trace and produce tkprof output for a traditional export (exp)/import (imp) performance issue on Windows platform) can help
This is the windows screen shot with the command
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
E:\>C:\oracle\ora92\bin\exp user/password@RESRCH STATISTICS=none FILE=SmilExport.dmp TABLES=(FILTERS) log=SmilExp.log
Export: Release 220.127.116.11.0 - Production on Fri Dec 2 10:07:50 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
A few seconds the windows error message pop up.