Importing Tables using PLSQL fails - Ora 003114 Not Connected to Oracle

[Scott Drummond]

I backed up a number of tables using the PLSQL tool to export tables (select many tables at once, and exported them all into one PDE file). I dropped the schema and imported another schema I have. I want to restore those tables as data in there has critical configuration items.

I am using this version of PLSQL connecting to Oracle 11g

Any help is appreciated. Thanks.

PL/SQL Developer
Version 7.1.5.1397
01.49817 - Unlimited user license
Windows Vista (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4,194,304 kB (4,194,304 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,900,648 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\Administrator\default.ini

Plug-Ins

Aliases
cshris
CSHSPEECH
xe

Homes
ora11 (C:\Oracle\PRODUCT\11.2.0)
OraClt32 (C:\Oracle\product\Clt11_32)
XE (c:\oraclexe\app\oracle\product\10.2.0\server)

DLLs
C:\Oracle\product\Clt11_32\bin\oci.dll

TNS File
C:\Oracle\product\Clt11_32\Network\Admin\tnsnames.ora

Using
Home: OraClt32
DLL: C:\Oracle\product\Clt11_32\bin\oci.dll
OCI: version 9.2
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0

Character Sets
Character size: 3 byte(s)
CharSetID: 871
NCharSetID: 871
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.UTF8
NLS_CHARACTERSET: UTF8
NLS_NCHAR_CHARACTERSET: UTF8

 

[Scott Drummond]

When I import the tables, it seems to go through the paces and then suddenly displays the Ora 03114 message (not connected to oracle) then the application freezes (have to task kill)

I am on Windows server 2008 R2 64 bit.

thanks,

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).