Re: Import fails into a different tablespace

Thanks Peter

Unfortunatly I can't make user TST to use the tablespace TST do to I have other tablespaces in which is also importing into, this is for a datawareshouse database 500GB,I have about 10 different tablespaces in this schema but at the moment I only have trouble with 2 of them, since I have separeted them, is there any other sugestions that I can do

Thanks
Maria

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
Received on Tue Dec 10 2002 - 08:05:35 CST