Re: Import fails into a different tablespace

Maria,

Yes, use Sybrands suggestion and pre-create the objects. If you use the parameters SHOW=YES and LOG=<filename> you will capture all the SQL-statements that are in the dump file. Edit the statements, alter the used tablespace by the wanted tablespace etc.

good luck,
Peter

"Maria" <evoradba_at_yahoo.ca> schreef in bericht news:351fd9d6.0212100605.3aed6255_at_posting.google.com...
> 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:31:51 CST