Re: Move schema and tablespace

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