Re: Tablespace problems ...

From: Adrian Shepherd <Adrian.Shepherd_at_BTINTERNET.COM>
Date: Sun, 7 Jun 1998 12:20:38 +0100
Message-ID: <6ldtp1$rrc$1@uranium.btinternet.com>

I am pretty sure in Oracle8 that you can partition a table and put each partition in a different tablespace...

If following point three, check out what indexes need to be recreated on the new table.

Luke Davies wrote in message ...
>In article <357B222D.63A6_at_comp.polyu.edu.hk>, c6635500_at_comp.polyu.edu.hk
>(Jimmy) wrote:
>
>> Hello all,
>>
>> 1) Can the data of table 'TA' can be stored in two different
>> tablespaces?
>>
>> 2) If tablespace 'TSA' contains two data files, 'DF1' and 'DF2',
>how to
>> know the contents of 'DF1' and 'DF2'? (i.e. to know the table name
>> stored in 'DF1' and 'DF2')
>>
>> 3) Is it possible that to move a table 'TA' from one tablespace
>'TS1'
>> to another 'TS2'? How to do that?
>>
>>
>> Thanks,
>> Jimmy
>>
>1) No
>2) Either use Enterprise Manager ( easy way )
> Or check out the file ID portion of the first row's rowid ( slightly
>harder )
>3) Create table TA_TEMP as select from TA with new tablespace, drop ta,
>then rename TA_TEMP -> TA.
>
>Luke
Received on Sun Jun 07 1998 - 06:20:38 CDT