Re: import, please help.

imp error messages usually don't lie. If imp reports the file to exist, the file exists.
The only other reason why include destroy=y would file, is the file in the create tablespace statement doesn't have the same size as the file on disk. In that case the only solution is to remove manually the files on disk. As to the 1658 error message: apparently you have exported with compress=y. You should never do that. compress=y simply calculates all currently allocated space for an object and makes sure the the initial extent for the target object is as big as the allocated space. The newly calculated initial extent may not fit in your tablespace.
The only other option with respect to this error is the target tablespace doesn't exist due to the create tablespace errors and the object ends up in the default tablespace for the user, which is now apparently too small. I'm not sure why you need a practical example. I provided several of them in the last few weeks, and of course they are in the manual. You seem to have a specific situation about which you provide little background. A normal export will import like a breeze, the only problem being incorrect filenames, which will force you to precreate the tablespaces.

Regards,
Sybrand Bakker, Oracle DBA

Tom Karlsson <xenon_at_aegir.vision.auc.dk> wrote in message news:Pine.GSO.4.10.10003222157240.26538-100000_at_aegir.vision.auc.dk...
> Hey all,
>
> I'm currently trying to do a full import to a newly installed Oracle 8.0.5
> on linux (the dump file is exported from oracle 8.0.5 for linux aswell).
>
> I've followed the standard install steps, but when trying to import I get
> some of the following errors :
>
> 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
>
> (a lot of those)
>
> 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:
> "CREATE TABLE "A......//......
> "E 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE
> "USERS""
> 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:
>
> (a lot of stuff is missing in the imported database)
>
> I've tried using DESTROY=Y, but that doesn't seem to make a difference.
> I've seen some past mails about import, but they're too general and
> doesn't go into detail (or give a practical example) on how to do a full
> import. Anyone who can tell me how to make a proper full import?.
>
> Any help is greatly appreciated.
>
> Thanks.
>
>
> Friendly regards
>
> Tom
>
Received on Wed Mar 22 2000 - 00:00:00 CST