Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Import (URGENT)

RE: Import (URGENT)

From: Sajid Iqbal <sajid_at_u-net.net>
Date: Fri, 26 May 2000 13:56:38 +0100 (BST)
Message-Id: <10509.106857@fatcity.com>


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
Received on Fri May 26 2000 - 07:56:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US