An assumption I certainly wouldn't make! I guess all of us are probably
still guilty of being lazy and using the connect, resource and DBA roles.
Even Oracle products still use them. Maybe they'll go away in the next
release! ;)
--
HTH. Additions and corrections welcome.
Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:a5jg3n$7pm$1_at_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 Thu Feb 28 2002 - 12:30:12 CST
