Re: imp-exp tools

In article <8v4915$8i3$1_at_nnrp1.deja.com>,   carl_bruneau_at_my-deja.com wrote:
>

I have red the Both suggestion to problem , they may be correct. But to my understanding that it is not neccassry that you have to have the tablespace with the same name , from which the export(dmp) file has been generated, you can import that dmp file to any user regardless of its defaul tablespace name.
I think you have not granted the quota to the user in which you want to import the dmp file , so make sure that you must have grant the quota to the user to any tablespace you need.

You can also grant role "resource" to the to_user.

try

sql> grant resource to to_user;

then try the import.exe file , I think you might not get any error.

Faheem

Hello Everyone,
>
> In our business - software developper - we have to deal with data from
> all of our clients. Consequently we decided long ago to work with many
> tablespaces on the same server and many users by tablespace. So every
> tablespace logically represent a set of client.
>
> Recently, we upgrade our Oracle server from version 8.0.3 to version
> 8.1.6.
>
> Since then, we have a problem using the imp-exp tools.
>
> Before the upgrade, we were able to copy all the objects from a users
> schema residing on one tablespace to another user residing on another
> tablespace on the same server. Here is an exemple:
>
> exp.exe system/manager owner=user_a file=x.dmp log=y.log direct=y
> consistent=y
>
> imp.exe system/manager fromuser=user_a touser=user_b file=x.dmp
> log=z.log commit=y
>
> We always did that with exp-imp tools using the fromuser and touser
> parametrers and it always worked.
>
> Since the upgrade, we ancounter the imp-00015 error when we are doing
> that kind of move. Oracle says to us that the default behavior of
 those
> tools was to try to copy the data to the same tablespace as it was
> extract with exp and that those tools are not intended for this kind
 of
> move. They almost didn't believe us that we were able to do that on
 our
> old server (but, of course, they didn't want to try to reproduce it).
>
> So, I would like to know if you have to deal with this kind of
 situation
> and how you proceed to do that?
>
> Any suggestions?
>
> Thank's a lot,
>
> Carl
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 18 2000 - 18:49:09 CST