ktfbbsearch-7 error [message #70470] |
Tue, 18 June 2002 04:17 |
Bulent
Messages: 1 Registered: June 2002
|
Junior Member |
|
|
Hi,
Does anybody know why ktfbbsearch-7 error occurs when processing with big databases?
we have a database with about 25 million of records. When we want to process these records,the system gives this error... Help...
|
|
|
Re: ktfbbsearch-7 error [message #70476 is a reply to message #70470] |
Tue, 18 June 2002 13:54 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
I beleive,
The error occurs when trying to create a locally managed
tablespace (default for 9i) with a large extent size.
try changing extent management method to dictionary.
And also becuase of highly fragemented files ( for old , large databases).
Oracle is unable to find contiguous disk space to create
the extent due to fragmentation.
The workaround is to create tablespace with locally management,
but specifying 'UNIFORM <>' instead of using the
default 'AUTOALLOCATE'.
|
|
|