Re: How to move objects from one datafile to another?

On Mar 1, 10:56 am, "Matthias Hoys" <a..._at_spam.com> wrote:
> "hpuxrac" <johnbhur..._at_sbcglobal.net> wrote in message
>
> news:1172772628.835686.222730_at_p10g2000cwp.googlegroups.com...
>
>
>
>
>
> > On Mar 1, 12:48 pm, "Eugene" <epi..._at_gmail.com> wrote:
> >> On Mar 1, 9:43 am, Brian Peasland <d..._at_nospam.peasland.net> wrote:
>
> >> > Eugene wrote:
> >> > > Hi all,
> >> > > I am running Oracle 8.1.6.3 on WinNT (I know...) and having I/O
> >> > > contention. I identified 2 datafiles that I'd like to split. I need
> >> > > to
> >> > > be able to move some tables out of one datafile into another
> >> > > tablespace on another drive.
> >> > > How do I do that?
>
> >> > > Thanks,
> >> > > Eugene
>
> >> > Create a new tablespace with the new datafile. Since this is 8i, the
> >> > ALTER TABLE MOVE command is not an option. So export the tables in
> >> > question. Then drop the tables. Precreate the tables in the appropriate
> >> > tablespace. Then import with IGNORE=Y. The data will be imported into
> >> > the tablespace you precreated the table in.
>
> >> > That's the simple version!
>
> >> > HTH,
> >> > Brian
>
> >> > --
> >> > ===================================================================
>
> >> > Brian Peasland
> >> > d...@nospam.peasland.nethttp://www.peasland.net
>
> >> > Remove the "nospam." from the email address to email me.
>
> >> > "I can give it to you cheap, quick, and good.
> >> > Now pick two out of the three" - Unknown
>
> >> > --
> >> > Posted via a free Usenet account fromhttp://www.teranews.com
>
> >> Thanks Brian for your reply,
> >> Actually, ALTER TABLE MOVE is available in 8.1.6. I've used it a
> >> couple of times.
> >> How would I do it using this option?
>
> >> Eugene- Hide quoted text -
>
> >> - Show quoted text -
>
> > ALTER TABLE XXXX MOVE TABLESPACE YYYY
>
> Don't forget to rebuild any indexes on the affected tables since this
> operation will invalidate them. Also, if you are using the CBO, you need to
> recalculate the table & index statistics.
>
> Matthias- Hide quoted text -
>
> - Show quoted text -

Thank you all,
Going back to 8i, would you recommend to MOVE tables and indexes in different tablespaces on different drives???

Eugene Received on Thu Mar 01 2007 - 13:01:19 CST