Re: 2 questions

1. Check the create table statement in the SQL reference for syntax.
2. You can put some partitions in R/O tablespaces. Often you'll put all of them in RO tablespaces except for the 'active' one.

hth,

Yosi

Tarek Zeineddine wrote:

> 1- how do i make a table a partitioned table... i read the whole chapter
> on
> Managing tables but they do not give an exmaple. They talk about special
>
> commands to manage partitions, but they do not list them!
>
> 2- Since each partition can occupy a diffrent tablespace, could i at one
> point
> make one of those tablespaces readonly while leaving the others
> unchanged?
>
> Thank you in advance
>
> Tarek
Received on Wed Dec 08 1999 - 14:00:32 CST