Re: Tablespace

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

>

>