Bug: pde does not import all rows

Lampy

Member²
=====================================
Export log:
=====================================
Export started on 5. 4. 2018 09:29:31

Exporting table MyOwner.MyTable...
15373883 records exported

1 Table(s) exported
15373883 Record(s) exported

Export finished on 5. 4. 2018 09:42:10

=====================================
Import log:
=====================================
Import started on 5. 4. 2018 10:09:16
-- Disable triggers
alter table MyOwner.MyTable disable all triggers

Table altered

-- Delete table
delete from MyOwner.MyTable

0 rowss deleted

commit

Commit complete

Import table MyOwner.MyTable
3723026 Records loaded, 0 errors

-- Enable triggers
alter table MyOwner.MyTable enable all triggers

Table altered

Import finished on 5. 4. 2018 11:22:36

=====================================
=====================================
15373883 Record(s) exported
3723026 Records loaded, 0 errors
**
PL/SQL Developer Version 11.0.6.1776
Windows 10 (64-bit) Build 16299
**
Export options:
- Compress file: Yes
- Include storage: No
- Include privileges: No
**
Import options:
- Drop tables: No
- Create tables: No
- Truncate tables: No (table was truncated beforehand)
- Delete records: Yes
- Disable triggers: Yes
- Disable FK: Yes
=====================================
=====================================
 
Its big ... 622.595.703 bytes
I cannot send it to you as it contains sensitive personal data.

==========================================
Describe table:
==========================================
stevilka, number(11), , ,
leto_i, number(4), y, ,
mesec_i, number(2), y, ,
stevilka_i, number(5), y, ,
zap_stev, number(10), , ,
p_tip, varchar2(10), , ,
referent, varchar2(30), , user,
datum_vnos, date, , ,
vrstica, varchar2(4000), y, ,
napaka, varchar2(2000), y, ,
del_stevilka, number(11), y, ,
datum, date, y, ,
leto_o, number(4), y, ,
mesec_o, number(2), y, ,
ime_dat, varchar2(50), y, ,
pre_stevilka, number(11), y, ,
stevilka_izvoza, number(11), y, ,
del1_stevilka, number(11), y, ,
lokacija, varchar2(35), y, ,
povezava_zunanji_sistem, varchar2(70), y,
==========================================

 
I've tried the import with v12 ... same problem:
====================================
Import started on 6. 4. 2018 12:53:24
-- Disable triggers
alter table MyOwner.MyTable disable all triggers

Table altered

-- Delete table
delete from MyOwner.MyTable

0 rowss deleted

commit

Commit complete

Import table MyOwner.MyTable
3723026 Records loaded, 0 errors

-- Enable triggers
alter table MyOwner.MyTable enable all triggers

Table altered

Import finished on 6. 4. 2018 13:41:30
====================================
 
No soup for me ...
Exported with x64 v12: 15373883 Record(s) exported
Imported with x64 v12: 3723026 Records loaded, 0 errors

pde filesize: 622.432.256 bytes
 
Back
Top