If I remember correctly - this doesn't work on partitioned tables :-)
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:a5h67s$5nr$1_at_lust.ihug.co.nz...
> 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...
> > 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
> > >
> >
> >
>
>
Received on Wed Feb 27 2002 - 12:08:29 CST
