| IMP-00017 error [message #314356] |
Wed, 16 April 2008 07:54  |
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  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
