Re: Import (URGENT)

From: Danut Bancea <danut_at_telepages.ca>
Date: Fri, 26 May 2000 10:55:42 -0400
Message-Id: <10509.106881@fatcity.com>

Hi,

First create the tables in the new schema and tablespace, and after that start the import using ignore=y.

Danut,

Danut Bancea
Senior Oracle DBA

Tele-Pages Inc.
Phone : (416) 296-9011 Ext. 2271
Fax : (905) 477-7062
E-mail : danut_at_telepages.ca

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 9:31 AM Subject: 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 - 09:55:42 CDT