Home » RDBMS Server » Server Utilities » ORA-03237 during import
ORA-03237 during import [message #273384] Wed, 10 October 2007 04:32 Go to next message
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 Go to previous message
joy_division
Messages: 4644
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

Previous Topic: About Sql*Loader
Next Topic: SQLLDR
Goto Forum:
  


Current Time: Fri Dec 09 13:39:04 CST 2016

Total time taken to generate the page: 0.11660 seconds