Re: IMPORT error, initial extents cannot be created (HELP!!!)

"Bonjour" from Paris

Your table need an initial extent of 2Go (INITIAL 2044334080) but your largest
extend size is 1,5 Go (mpc_data.dbf) because an extent cannot be on different files : an extent is a collection of simultaneous bytes.

Two cases : allocate larger file

I assume in fact that the pbm becomes from the export command. By defaut the export command gathers all the extent of a segment in one extent ... that's why your initial extent is so large. There is an option in the export command in order to not gather the extents of an segment.

"Au revoir" from Paris

Christophe Brault

JK Yao a écrit :

> dear all,
>
> Oracle8.1.6
> OS: Solaris5.7
> Import Utility
>
> full=y rows=n constraints=n indexes=n
>
> When I imported the object, there is a error showing that I am not be
> able to create a table. What caouse this? The tablespace is big
> enough. Any though? Following is the error mesg and my script of
> creation of the tablespace.
>
> Thanks in advance,
> JK
> ~~~~~~~~~~~~~~~
>
> ****** error codes *********
> IMP-00017: following statement failed with ORACLE error 1658:
> "CREATE TABLE "PART_COST_BUCKET_HISTORY_TAB" ("PART_NO" VARCHAR2(25)
> NOT NUL" ...) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
> STORAGE(INITIAL 2044334080 NEXT 2097152 MINEXTENTS 1 MAXEXTENTS
> 2147483645 PCTINCREASE"
> " 0 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "MPC_DATA""
> IMP-00003: ORACLE error 1658 encountered
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> MPC_DATA
>
> ****************
>
> ************* tablespace setting *************
> CREATE TABLESPACE mpc_data DATAFILE
> '/data2/P8/mpc_data.dbf' size 1500M,
> '/data2/P8/mpc_data1.dbf' size 1450M,
> '/data2/P8/mpc_data2.dbf' size 500M
> DEFAULT STORAGE
> ( INITIAL 2M NEXT 2M MINEXTENTS 1
> MAXEXTENTS 249 PCTINCREASE 0)
> ONLINE;
> ****************
Received on Tue Aug 21 2001 - 08:07:28 CDT