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
Received on Thu Mar 01 2007 - 12:10:28 CST
