Oracle wants a 2G initial extent (as shown in your import snippet). Your
largest possible extent is 1.5G (as per your create tablespace command
at the bottom). If there is something else in that tablespace, export it also,
drop the tablespace, delete the OS files (via os commands) and recreate
the tablespace as a single 3.5G file (versus 3 smaller files). Than import
all your tablespace objects.
"JK Yao" <jkyf0131_at_hotmail.com> 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;
> ****************
>
Received on Tue Aug 21 2001 - 08:10:12 CDT
