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: Miguel Urosa <murosa_at_smseuropa.com>
Date: Fri, 26 May 2000 15:08:29 +0200
Message-Id: <10509.106858@fatcity.com>

        You must add a data file to database for that tablespace or coalesce that tablespace if you're working with Oracle v7.3.4 or later.

        HTH
> -----Mensaje original-----
> De: Sajid Iqbal [SMTP:sajid_at_u-net.net]
> Enviado el: viernes 26 de mayo de 2000 15:32
> Para: Multiple recipients of list ORACLE-L
> Asunto: 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 |
>
>
> --
> 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:08:29 CDT

Original text of this message

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