version is 8.1.6 EE on Tru64
Użytkownik "Howard J. Rogers" <dba_at_hjrdba.com> napisał w wiadomości
news:3c15027f$0$5900$afc38c87_at_news.optusnet.com.au...
> Version?
>
> It helps to know the Oracle version you are using, because so much changes
> between them, and this is a classic example.
>
> There is an 'alter table X move tablespace Y' command available in 8i.
> Otherwise, you are looking at export-drop-import with a smattering of
quota
> changes for each user. Or at CTAS (create table as select) statements.
>
> Regards
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Sławomir Marcinkowski" <s.marcinkowski_at_Bankier.pl> wrote in message
> news:9v1vsm$kd8$1_at_news.tpi.pl...
> > I have created some users, that have the same tablespace, but now I need
> to
> > move one of them to his own tablespace. I've created tablespace for him,
> bu
> > I don't know, how to safely move all his data to his new default
> tablespace.
> > Can someone explain me, ho to do it?
> >
> > Sławek Marcinkowski
> >
> >
>
>
Received on Wed Dec 12 2001 - 05:48:26 CST
