Mohamad AbdElwah
Member
Dears,
First I would like to thank you for this excellent tool you created, and all the contentious developments and enhancements you are doing on it.
I found 2 issues till now hope you can help me on them.
1- Testing window issue: when using test window and if I reconnect with another user I found error (Access violation at address 0055E8B3 in module (plsqldev.exe). Read of address 0000003).
2- Text importer tool:- Recently I found a problem while trying to use the text importer tool.
I was trying to upload 1GB text file the I downloaded fromhttp://download.geonames.org/export/dump/ file name (allcountries.zip), I created a table in my database as below.
I mapped all the column in the text file to my table except column #4 in the text because it is too big.
After that I made the importer commit every 10000 record.
And when I started the import process everything go fine till I reach 1970000 record in my table, the importer just freeze and freeze all my pl/sql window, I left it for many hours with no use, the only thing I could do it to end this task from windows. Task manager.
After that I started it again and make it start importing from 1970001 but it is freeze again in 1974000 and I do not know what to do.
PL/SQL version 10.0.4
Database version 10.2.0.5.0 also 10.2.0.3.0 with the same problem.
OS windows server 2003 standard edition.
-- Create table
create table ALL_COUNTRIES
(
geonameid NUMBER(20),
name VARCHAR2(200),
asciiname VARCHAR2(200),
latitude NUMBER(10),
longitude NUMBER(10),
(FEATURE CLASS) VARCHAR2(1),
(FEATURE CODE) VARCHAR2(10),
(COUNTRY CODE) VARCHAR2(2),
cc2 VARCHAR2(60),
(ADMIN1 CODE) VARCHAR2(20),
(ADMIN2 CODE) VARCHAR2(80),
(ADMIN3 CODE) VARCHAR2(20),
(ADMIN4 CODE) VARCHAR2(20),
population NUMBER(20),
elevation NUMBER(20),
dem NUMBER(10),
timezone VARCHAR2(40),
modification_date DATE
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
Waiting you replay.
First I would like to thank you for this excellent tool you created, and all the contentious developments and enhancements you are doing on it.
I found 2 issues till now hope you can help me on them.
1- Testing window issue: when using test window and if I reconnect with another user I found error (Access violation at address 0055E8B3 in module (plsqldev.exe). Read of address 0000003).
2- Text importer tool:- Recently I found a problem while trying to use the text importer tool.
I was trying to upload 1GB text file the I downloaded fromhttp://download.geonames.org/export/dump/ file name (allcountries.zip), I created a table in my database as below.
I mapped all the column in the text file to my table except column #4 in the text because it is too big.
After that I made the importer commit every 10000 record.
And when I started the import process everything go fine till I reach 1970000 record in my table, the importer just freeze and freeze all my pl/sql window, I left it for many hours with no use, the only thing I could do it to end this task from windows. Task manager.
After that I started it again and make it start importing from 1970001 but it is freeze again in 1974000 and I do not know what to do.
PL/SQL version 10.0.4
Database version 10.2.0.5.0 also 10.2.0.3.0 with the same problem.
OS windows server 2003 standard edition.
-- Create table
create table ALL_COUNTRIES
(
geonameid NUMBER(20),
name VARCHAR2(200),
asciiname VARCHAR2(200),
latitude NUMBER(10),
longitude NUMBER(10),
(FEATURE CLASS) VARCHAR2(1),
(FEATURE CODE) VARCHAR2(10),
(COUNTRY CODE) VARCHAR2(2),
cc2 VARCHAR2(60),
(ADMIN1 CODE) VARCHAR2(20),
(ADMIN2 CODE) VARCHAR2(80),
(ADMIN3 CODE) VARCHAR2(20),
(ADMIN4 CODE) VARCHAR2(20),
population NUMBER(20),
elevation NUMBER(20),
dem NUMBER(10),
timezone VARCHAR2(40),
modification_date DATE
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
Waiting you replay.
Last edited:
