Import Tables drops Oracle Connection

[ToddR]

Hi,

I did a PL/SQL Developer table export on a large/wide table and when I try to do the PL/SQL Developer table import, I get an ORA-03114 error - Not connected to Oracle. From the log it appears to happen right after the table is created. The source DB is Oracle 9 and the target DB is Oracle 11.

Any help appreciated - 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).

 

[Peter Kotvitsky]

Hi,

I encountered the same problem on my production database. Here's an excerpt from debug.txt (cannot send full file, as it contains confidential info, so i included only parts of it that have oracle errors):
---------------------------------------------------
...
00:00:07.023 TOracleQuery $06029B90 Start Query.Execute
SQL = select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
00:00:07.234 TOracleQuery $06029B90 End
Result = ORA-00942: table or view does not exist
Duration = 0,172
...
00:03:11.431 TOracleQuery ImportForm.Query Start Query.Execute
SQL = insert into APP_OBJECTS
(app_project, app_obj_type, app_obj_name, app_obj_caption, app_obj_description, app_obj_source_1, app_obj_source_2, app_obj_first_in, app_obj_first_out, creation_date, creation_user, modification_date, modification_user)
values
v0, :v1, :v2, :v3, :v4, empty_clob(), null, :v7, :v8, :v9, :v10, :v11, :v12)
returning app_obj_source_1, app_obj_source_2 into :v5, :v6
:V0 = mmm
:V1 = kkk
:V2 = zzz
:V3 = yyy
:V4 = yyy
:V5S = empty_clob()
:V5 = (CLOB)
:V6S = null
:V6 = (CLOB)
:V7 = Null
:V8 = Null
:V9 = 02-02-2100 10:00:00
:V10 = XXX
:V11 = 02-02-2100 10:00:00
:V12 = XXX
00:03:11.521 TOracleQuery ImportForm.Query End (1 record processed)
Duration = 0.078
00:03:11.546 TLOBLocator Start LOB.Write(6276)
00:03:11.653 TLOBLocator End
Result = Access violation at address 5B24B2CC in module 'OraClient12.Dll'. Write of address 00000000
Duration = 0.094
00:03:11.663 TOracleQuery ImportForm.Query Start Query.Execute
SQL =
00:03:11.776 TOracleQuery ImportForm.Query End
Result = ORA-01013: user requested cancel of current operation
Duration = 0.109
00:03:11.796 TOracleQuery ImportForm.Query Start Query.Execute
SQL =
00:03:11.891 TOracleQuery ImportForm.Query End
Result = ORA-24909: call in progress. Current operation cancelled
Duration = 0.078
00:03:11.911 TOracleQuery ImportForm.Query Start Query.Execute
SQL =
00:03:11.933 TOracleQuery ImportForm.Query End
Result = ORA-03114: not connected to ORACLE
Duration = 0

---------------------------------------------------
All next queries end with this error. It seems like the error is related to LOB processing.

I'm running Oracle 12.1.0.2 database. Connection is established through Oracle 12c client.

PL/SQL Developer 11.0.6.1776.

 

[Marco Kalter]

Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[Peter Kotvitsky]

Sure, np. But what do you mean by email reply? What's the dest. address?

 

[mike]

I'll answer so you have it sooner.

support@allroundautomations.com

 

[Peter Kotvitsky]

Thanks!

Sent. (sender: kotpeter9999@mail.ru)