Try taking the tablespace offline. Then is should import into the user's
default tablespace.
Ruth
----- Original Message -----
From: Sajid Iqbal <sajid_at_u-net.net>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Friday, May 26, 2000 10:05 AM
Subject: RE: Import (URGENT)
>
> I have checked this.. but regardless of what I do it still tries to import
> into the same tablespace and fails with the same error on the same
> tablespace ?????
>
> --
> 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 |
>
>
> On Fri, 26 May 2000, Andre Stenvers wrote:
>
> > Not only the default TS-setting is important.
> > The user-to may not have any quota on the destination tablespace.
> > Query table 'dba_ts_quotas' to find out if this is so.
> >
> > HTH
> > AGS
> > > -----Oorspronkelijk bericht-----
> > > Van: Sajid Iqbal [SMTP:sajid_at_u-net.net]
> > > Verzonden: vrijdag 26 mei 2000 14:19
> > > Aan: ORACLE-L_at_fatcity.com; oracle_at_telelists.com; oracledba_at_lazydba.com
> > > Onderwerp: Import (URGENT)
> > >
> > >
> > > 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 |
> > >
> > >
> > >
> > > --------
> > > If you're bored, then visit the list's website: http://www.lazydba.com
> > > (updated daily)
> > > to unsubscribe, send a blank email to
oracledba-unsubscribe_at_quickdoc.co.uk
> > > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
(updated daily)
> > to unsubscribe, send a blank email to
oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.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
Received on Fri May 26 2000 - 09:05:04 CDT
