Re: imp.exe crash on windows xp (Oracle ver. 9.2.0.8)

Hi All,
I resolved my problem.
The cause was the value of the chunk size in the table ODMM_CONTENTSTORE which contains the BLOB data type.

Here the steps:

1. I imported with INDEXFILE parameter to generate the script can be used to modify the LOB's tablespace clause.
2. I Edit the generated script changing the value of CHUNK size (for each BLOB column) in the CREATE TABLE ODMM_CONTENTSTORE statement. The new value must be a multiple of the db_block_size parameter of the target database. In my database the value of db_block_size is 6144 so i set the chunk size to 24576 (6144*4)
3. I save and run the script
4. I Import the data only in the created structure imp system/manager full=y ignore=y
5. Finally all it'ok.

I would thank everyone for the attention and i sorry for my english.

Good job to all
Vincenzo Received on Thu Nov 16 2006 - 05:31:17 CST