Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!opentransit.net!proxad.net!proxad.net!freenix!fr.clara.net!heighliner.fr.clara.net!newsfeed.tpinternet.pl!news.tpi.pl!not-for-mail
From: "Sławomir Marcinkowski" <s.marcinkowski@Bankier.pl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Tablespace
Date: Wed, 12 Dec 2001 12:59:15 +0100
Organization: tp.internet - http://www.tpi.pl/
Lines: 40
Message-ID: <9v7gqj$94p$1@news.tpi.pl>
References: <9v1vsm$kd8$1@news.tpi.pl> <3c15027f$0$5900$afc38c87@news.optusnet.com.au>
NNTP-Posting-Host: zz2.bankier.pl
X-Trace: news.tpi.pl 1008158357 9369 217.11.138.2 (12 Dec 2001 11:59:17 GMT)
X-Complaints-To: usenet@tpi.pl
NNTP-Posting-Date: Wed, 12 Dec 2001 11:59:17 +0000 (UTC)
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MSMail-Priority: Normal
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Xref: easynews comp.databases.oracle.server:127938
X-Received-Date: Wed, 12 Dec 2001 04:59:13 MST (news.easynews.com)

thnx, it's orking :)
Slawek Marcinkowski

Użytkownik "Howard J. Rogers" <dba@hjrdba.com> napisał w wiadomości
news:3c15027f$0$5900$afc38c87@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@Bankier.pl> wrote in message
> news:9v1vsm$kd8$1@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
> >
> >
>
>