"hpuxrac" <johnbhurley_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
Received on Thu Mar 01 2007 - 12:56:27 CST
