Re: Tablespace problems ...

From: Luke Davies <luked_at_cix.co.uk>
Date: 7 Jun 1998 09:55:50 GMT
Message-ID: <memo.19980607105038.59383C@luked.compulink.co.uk>

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 - 04:55:50 CDT