ORA-03237 during import [message #273384] |
Wed, 10 October 2007 04:32 |
andreliauw
Messages: 1 Registered: October 2007 Location: belgium
|
Junior Member |
|
|
Hi,
I've run an export from 9.2.0.8 32bit on sun solaris 5.9 db EBACC
full=y, compress=n, direct path
Now I'm trying to import these in EBDBA, sun solaris 5.9 oracle 9.2.0.8 64bit
full=y, ignore=n, indexes=n, analyze=n
receive the following errors:
ora-03237
logfile of one of the create tables with these error:
IMP-00003: ORACLE error 3237 encountered
ORA-03237: Initial Extent of specified size cannot be allocated in tablespace (APPLSYSD)
IMP-00017: following statement failed with ORACLE error 3237:
"CREATE TABLE "FND_CRM_HISTORY" ("REQUESTS_EXAMINED" NUMBER NOT NULL ENABLE,"
" "REQUESTS_STANDBY" NUMBER NOT NULL ENABLE, "REQUESTS_RELEASED" NUMBER NOT "
"NULL ENABLE, "REQUESTS_RETURNED" NUMBER NOT NULL ENABLE, "WORK_START" DATE "
"NOT NULL ENABLE, "WORK_END" DATE NOT NULL ENABLE) PCTFREE 5 PCTUSED 90 INI"
"TRANS 10 MAXTRANS 255 STORAGE(INITIAL 16384 NEXT 67133440 MINEXTENTS 1 MAXE"
"XTENTS 2147483645 PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL D"
"EFAULT) TABLESPACE "APPLSYSD" LOGGING NOCOMPRESS"
Tablespace applsysd, just created, is 15Gb and has 14Gb free.
How to solve this ?
I've read something about LOB's ? The solution would be to change the creation of the tablespace from locally managed to dictionary managed ?
regards.
|
|
|
Re: ORA-03237 during import [message #273435 is a reply to message #273384] |
Wed, 10 October 2007 08:20 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
You are out of contiguous space in your tablespace. You cannot create a 16k extent. Add more space or pre-create your objects in different tablespaces.
I don't see what this has to do with BLOBs and it wouldn't be wise to use a legacy option of dictionary managed tablespaces.
03237, 00000, "Initial Extent of specified size cannot be allocated in tablespace (%s)"
// *Cause: Too large a size for an initial extent due to freelist
// group specification
// *Action: Reduce number of freelist groups specified for segment
[Updated on: Wed, 10 October 2007 08:23] Report message to a moderator
|
|
|