Re: Import (URGENT)

If you want to import the table into the touser's default tablespace try this.
1) remove quota on the original tablespace from the touser 2) import the table - since the touser has no quota on the original tablespace the table should be created in the touser's default tablespace
3) set quota on the original tablespace for the touser if the touser needs it for other purposes

Am I missing anything?
Nancy

Sajid Iqbal wrote:
>
> 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.
>
> TIA
>
> --
> U-NET Ltd a VIA NET.WORKS Inc company
> Sajid Iqbal | Mail : sajid_at_u-net.net
> Database DBA/Developer | Ext : 4485
> U-NET Ltd | ICQ : 43903417
> Warrington, Cheshire, UK |
>
> --
> Author: Sajid Iqbal
> INET: sajid_at_u-net.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri May 26 2000 - 08:11:21 CDT