Re: Move schema and tablespace

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Thu, 28 Feb 2002 07:38:07 +1100
Message-ID: <a5jg3n$7pm$1@lust.ihug.co.nz>

True enough (but since RESOURCE is strictly there for backward compatibility, I'd rather assumed no-one was daft enough to use it these days!)

I'd forgotten about the possibility of the user being a DBA, though.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message
news:a5ipp401hq1_at_drn.newsguy.com...


> In article <a5h67s$5nr$1_at_lust.ihug.co.nz>, "Howard says...

> >

> >Quota 0 on the tablespace that import would ordinarily want to import

into.


> >Together with an alter user fred default tablespace X.

> >

>

> coupled with

>

> revoke unlimited tablespace from fred;

>

> if fred had been granted either RESOURCE or DBA (both of which also grant

the


> SYSTEM priv unlimited tablespace to fred directly).  If you don't do this,

quota


> 0 is ignored (overridden by unlimited tablespace)

>

>

> >Regards

> >HJR

> >--

> >----------------------------------------------

> >Resources for Oracle: http://www.hjrdba.com

> >===============================

> >

> >

> >"Scott Mattes" <ScottMattes_at_yahoo.com> wrote in message

> >news:6SUe8.1965$zU2.74820_at_news1.news.adelphia.net...

> >> But since he wants a different tablespace how does he redirect it at

> >import?

> >>

> >>

> >> "damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message

> >> news:3C7BF9B6.CB18C9C7_at_ci.seattle.wa.us...

> >> > Export ... then import.

> >> >

> >> > Daniel Morgan

> >> >

> >> >

> >> >

> >> > Philip Morrow wrote:

> >> >

> >> > > Basically the same question as the previous post but now I also

need


> >to

> >> put

> >> > > the tables and indexs in a different schema and tablespace keeping

all


> >> the

> >> > > constraints and relationships intact.

> >> > >

> >> > > Thanks again

> >> > >

> >> > > Phil

> >> >

> >>

> >>

> >

> >

>

> --

> Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/

> Expert one on one Oracle, programming techniques and solutions for Oracle.

> http://www.amazon.com/exec/obidos/ASIN/1861004826/

> Opinions are mine and do not necessarily reflect those of Oracle Corp

>

Received on Wed Feb 27 2002 - 14:38:07 CST