import tables to a different tablespace?

From: guy <guy_at_xxx.xxx>
Date: Tue, 15 Apr 2003 22:23:26 GMT
Message-ID: <yD%ma.42290$iy5.1217719@twister2.libero.it>

Hello,

I have taken an oracle dump (oracle 9i R1) and now want to import it into a new db instance (oracle 9i R2) on a different system. I did the export at user level.

On the new system, I created a new user with unlimited quota on a new tablespace.
Then issued the imp command with the options fromuser=xxx touser=yyy

Oracle started importing the data but I got a bunch of errors while it was trying to create some tables: "tablespace not existing" errors or something similar...

Since it's a testing db, I don't want to recreate all the original tablespaces...

How can I force the imp command to simply import all the stuff into the default tablespace for the yyy user?

Thanks. Received on Tue Apr 15 2003 - 17:23:26 CDT