Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Move schema and tablespace

Re: Move schema and tablespace

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 27 Feb 2002 10:37:00 +1100
Message-ID: <a5h67s$5nr$1@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 Tue Feb 26 2002 - 17:37:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US