Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import, please help.
the following error you get -
IMP-00015: following statement failed because the object already
exists:
"CREATE TABLESPACE "RBS" DATAFILE '/u02/oradata/orcl/rbs01.dbf'
SIZE 157286"
"40 DEFAULT STORAGE (INITIAL 131072 NEXT 131072 MINEXTENTS 2
MAXEX
is not a major problem. Just set
"Ignore create errors = y" when importing.
the following problem -
IMP-00003: ORACLE error 1658 encountered
ORA-01658: unable to create INITIAL extent for segment in
tablespace USERS
IMP-00017: following statement failed with ORACLE error 1658:
is because of any of the following conditions 1. the datafiles for USERS tablespace is not big enough 2. the tablespace USERS does not have enough extents allocated.
A quick fix for this is
Set the enable auto extend on for datafile and set the max extent size for the tablespace to unlimited.
thanks
jross8_at_netscape.net
In article <8blfg9$jbn$1_at_slb1.atl.mindspring.net>, "trea"
<trea_johnson_at_usa.net> wrote:
>
>> Question: will a export (without compress)/drop table/import
unfragment
>> the tables?
>>
>> Thanks,
>> Karen
>
>yes. the compress can either be done during the export (with a
compress=y)
>or by default during the import.
>
>
>
>