IMP-00017 error [message #314356] |
Wed, 16 April 2008 07:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sameek1211
Messages: 30 Registered: October 2007 Location: India
|
Member |
|
|
I have full export of oracle 9i and i am importing this into Oracle 10gR2. I am facing this problem
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE UNDO TABLESPACE "UNDOTBS" BLOCKSIZE 16384 DATAFILE '/opt/oracle/ora"
"data/prepoc/UNDO.DBF' SIZE 52428800 EXTENT MANAGEMENT LOCAL "
could any body please help me
thanx in advance
|
|
|
|
Re: IMP-00017 error [message #314363 is a reply to message #314356] |
Wed, 16 April 2008 08:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
ORA-29339: tablespace block size %s does not match configured block sizes
*Cause: The block size of the tablespace to be plugged in or
created does not match the block sizes configured in the
database.
*Action:Configure the appropriate cache for the block size of this
tablespace using one of the various (db_2k_cache_size,
db_4k_cache_size, db_8k_cache_size, db_16k_cache_size,
db_32K_cache_size) parameters.
Regards
Michel
|
|
|