Sajid,
imp always try to reimport into the original tablespace or, if the
owner is not allowed to do it, into the owner's default tablespace.
Revoke and DBA or UNLIMITED TABLESPACE privilege that the TOUSER may
have, set the default tablespace to the tablespace you want, and
reimport. Beware of indexes, though, since the same rule applies to
them. Look at the paper about exp/imp in the 'First Steps' section on
our site, it's pretty detailed.
--
HTH,
Stephane Faroult
email: sfaroult_at_oriolecorp.com
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax: +44 (0) 7050-696-449
Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
>
> I am trying to import a table from a full export.. importing into a diff'n
> schema than where the table originted from. using fromuser and touser.
>
> the touser had his tablespace set to a diff'n tablespace than the
> fromuser.. yet it still seems to try and import into the original tspace
>
> I'm getting the folowing error -
>
> ORA-01658: unable to create INITIAL extent for segment in tablespace
> UNETDB
> Import terminated successfully with warnings.
Received on Fri May 26 2000 - 08:56:21 CDT
