Re: Importing into another tablespace

In article <7r3dki$hlu$1_at_leonie.object-factory.com>,   "Dirk Olmes" <dirk_at_object-factory.com> wrote:
> Hi,
>
> I'm trying to import some data exported with the exp utility from user
A
> (Oracle 7) into another database (Oracle 8).
>
> What I would like to do is to import the data into another tablespace
while
> importing on the Oracle8 database (I want to make a copy of the
deployment
> database).
>
> I have read all the documentation about exp and imp and still haven't
found
> a way to convince imp to import to another tablespace than the one the
data
> was exported from.
>
> Can anyobdy give me a hint how this should work?
>
> TIA,
>
> -dirk
>
>

Before doing the import, create the table in another tablespace. Now, do the import with the IGNORE=YES option.

• Jack

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 07 1999 - 16:09:46 CDT