Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMPORT error, initial extents cannot be created (HELP!!!)
jkyf0131_at_hotmail.com (JK Yao) wrote in message news:<93f65984.0108210018.6e4ed7ea_at_posting.google.com>...
> 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;
> ****************
You need to either export with compress=n or pre-create the object and
then import with ignore=y. This is because the large number in bytes
ofthe initial extent which oracle can't seem to cope. If the ddl was
something like initial 2000M it may work, but ddl in export file has
storage in bytes.
- Hope this helps.
Received on Tue Aug 21 2001 - 08:51:07 CDT