Re: imp-exp tools

In article <8v7824$cn0$1_at_nnrp1.deja.com>,   faheemrao_at_my-deja.com wrote:
> 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.

Hello Faheem, in fact and after having test your suggestion I saw that all the objects wich I wanted to be created in the "touser" default tablespace are, in fact, create in the "fromuser" tablespace instead. So to grant the Resource role to my users, Is not only "dangerous" but it doesn't solve my problem at all.

Thank's a lot for your suggestion (even if I won't apply it).

Carl

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 20 2000 - 13:50:57 CST