Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Move schema and tablespace
Quota 0 on the tablespace that import would ordinarily want to import into.
Together with an alter user fred default tablespace X.
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...Received on Tue Feb 26 2002 - 17:37:00 CST
> 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
> >
>
>