Re: Move tables?

From: TurkBear <noone_at_nowhere.com>
Date: Tue, 17 Jul 2001 11:34:58 -0500
Message-ID: <14q8lt8vmjh12btd6notg80loobtgfdco1@4ax.com>

You can't AFAIK, and why would you want to? Oracle manages the tablespace storage quite well on its own, that is one of its main jobs..
even though the table's data appears to be only in one datafile, there could be parts of it elsewhere the next time you add or delete any records...

"Little Prince" <milan1810_at_geocities.com> wrote:

>I uses Oracle 8.0.6. I have a tablespace USERS which consistes of 3
>datafiles (fno 4, 5 and 6). I found that most of the tables are stored in
>datafile with fno 6. How can I move some tables to the other 2 datafiles?
>
>Regards,
>Andrew
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Tue Jul 17 2001 - 11:34:58 CDT