Re: Moving tables between tablespaces???

No I did not do that. I have fixed this by creating another user and importing the objects to "him".

Reg
Jerra

"Adrian J. Shepherd" wrote:

> A bit pedantic, but did you drop the user before the import, if the objects
> already exist they wont be created in another tablespace...
>
> "Jerra" <jerra_at_aland.net> wrote in message
> news:38D33BFB.D790B571_at_aland.net...
> > No the user did not have that role.
> > This situation is quite funny, the documentation clearly points out the
> > different steps to perform an operation like this and still it does not
 work.
> > I'll just have to read more on this matter.
> >
> > Thanks anyway for the reply!
> >
> > /Jerra
> >
> > Sybrand Bakker wrote:
> >
> > > Question:
> > > Does user2 have the resource role?
> > > If that's true, user2 has the unlimited tablespace privilege, and quota
 do
> > > not apply.
> > >
> > > Hth,
> > >
> > > Sybrand Bakker, Oracle DBA
> > >
> > > Jerra <jerra_at_aland.net> wrote in message
> > > news:8atc8v$1uq$1_at_gandalf.alcom.aland.fi...
> > > > I wanted to move user2 from tablespace1 to tablespace2. Used the
 following
> > > > steps:
> > > >
> > > > -exported the user2 objects exp user2/user2 owner=user2
> > > > -alter user2 qouta 0 on tablespace1 (as system manager)
> > > > -alter user2 default tablespace tablespace2(as system manager)
> > > > -alter user2 quota unlimited on tablespace2(as system manager)
> > > > -imp user2/user2 fromuser=user2
> > > >
> > > >
> > > > What happened?? -> The bloody tables came back to tablespace1?!?
> > > >
> > > >
> > > > What's the correct procedure for this??
> > > >
> > > >
> > > > Running Oracle8 Enterprise Edition Release 8.0.5.1.0 UNIX
> > > >
> > > >
> > > > Thank you very plenty!!
> > > >
> > > >
> > > > Jerra
> > > >
> > > >
> >
Received on Sat Mar 18 2000 - 00:00:00 CST