Re: Import fails into a different tablespace

evoradba_at_yahoo.ca (Maria) wrote in message news:<351fd9d6.0212091632.7c7547f6_at_posting.google.com>...
> Hi there
>
> I'm having the following problem which is driving me nuts
> I have 2 schemas TST and BACKUP that originally they were sharing the
> same tablespaces, then I have separeted 4 tables into different
> tablespaces one called TEST_BKP_DATA_TBS the other TEST_TST_DATA_TBS,
> then I did a full export of the database schema BACKUP and then a
> import into TST schema which is failing all the time with the error
>
>
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> TEST_BACKUP_DATA_TBS
>
> and realy want is the import to go to TEST_TST_DATA_TBS, and not into
> the other tablespace, I have
>
> imp ${AIQ_SYSTEMUSER}/${AIQ_SYSTEMPASSWORD}@${AIQ_DBSERVER}
> FILE=${AIQ_DUMPFILE}
> FROMUSER=${AIQ_DBUSER} TOUSER=${AIQ_BK_DBUSER_DBO}IGNORE=Y
> BUFFER=5242880 COMMIT=Y INDE
> XES=N CONSTRAINTS=N >${TMPFILE} 2>&1
>
> can someone please tell me how can I avoid this problem, how can I
> import from user's tablespace into another tablespace .....
> Thanks
> Helena

Precreate the affected objects by import ... show=y log=<any filename> edit the affected objects out of this file, change their tablespaces and presto. Other than that if you are on 8i
alter table ... move <new tablespace> will also do the trick.

Sybrand Bakker
Senior Oracle DBA Received on Tue Dec 10 2002 - 02:38:31 CST