Re: Importing into another tablespace

Hi Dirk,

• Make sure the destination tablespace is the default tablespace of the user
• Make sure the user doesn't have resource or unlimited tablespace privilege
• alter user <username> quota unlimited on <destination tablespace>
• imp etc indexes=n (this tric doesn't work for indexes)
• imp username/password file= etc indexfile=<filename>
• edit filename from previous step to change the tablespace and the save the file as .sql
• run the script

Hth,
--
Sybrand Bakker, Oracle DBA

Dirk Olmes <dirk_at_object-factory.com> wrote in message news:7r3dki$hlu$1_at_leonie.object-factory.com...
> 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
>
Received on Tue Sep 07 1999 - 14:48:45 CDT