Home » RDBMS Server » Server Utilities » IMP-00017 error
IMP-00017 error [message #314356] Wed, 16 April 2008 07:54 Go to next message
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 #314357 is a reply to message #314356] Wed, 16 April 2008 07:56 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
what/which part of the error message do you NOT understand?
Re: IMP-00017 error [message #314363 is a reply to message #314356] Wed, 16 April 2008 08:06 Go to previous message
Michel Cadot
Messages: 64139
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
Previous Topic: EXP dump file and WinRAR/Winzip
Next Topic: How to Check For Successful Exp/Imp
Goto Forum:
  


Current Time: Fri Dec 09 02:22:21 CST 2016

Total time taken to generate the page: 0.12192 seconds