Re: Database Partition

Posted in 1998

Arun Shastry — Wed, 23 Sep 1998 12:56:44 -0400 — source: Informix-list mailing list archive (1991-1998)

Ravi Verma wrote: > I have the following questions regarding Database Partitioning. > > 1. Is it possible to take one or more partition off line while the table itself is online? Yes. You need to set the DATASKIP on. However, if there are other tables or partitions of other tables in that dbspace, they will be marked as down too. > > > 2. Is it possible to add or drop partitions? Yes. Take a look at ALTER FRAGMENT in the manuals. > > > Regards. > > Ravi Verma