Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: import, please help.

Re: import, please help.

From: user <jross8NOjrSPAM_at_netscape.net.invalid>
Date: 2000/03/26
Message-ID: <093bee45.a0c7cdea@usw-ex0105-035.remarq.com>#1/1

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.
>
>
>
>

Received on Sun Mar 26 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US