470,613 Members | 2,384 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,613 developers. It's quick & easy.

HELP! Create Database problem

Hi,

On a multi-partition instance, can you create a database on a single
parition? How???

The db architects want to use one instance for four databases where
only one is big enough for a multi-partition. The other three are
small. I'd like to create them only on one partition but can't find any
documention on how to do this.

Thanks,
Celestine Pressley

Oct 9 '06 #1
2 1492
You need to use a single-partition nodegroup. It's in the doc.

Larry Edelstein

cp********@yahoo.com wrote:
Hi,

On a multi-partition instance, can you create a database on a single
parition? How???

The db architects want to use one instance for four databases where
only one is big enough for a multi-partition. The other three are
small. I'd like to create them only on one partition but can't find any
documention on how to do this.

Thanks,
Celestine Pressley
Oct 9 '06 #2
Ian
cp********@yahoo.com wrote:
Hi,

On a multi-partition instance, can you create a database on a single
parition? How???

The db architects want to use one instance for four databases where
only one is big enough for a multi-partition. The other three are
small. I'd like to create them only on one partition but can't find any
documention on how to do this.

Thanks,
Celestine Pressley
You can't create a single-partition database in a multi-partition
instance.

You could, as Larry suggested, create a single-partition nodegroup
in these databases and drop the default USERSPACE1 tablespace and
recreate it in the single-partition nodegroup.
However, you're probably better off creating a second non-partitioned
instance for these other databases. It will make life easier.


Oct 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Tom | last post: by
4 posts views Thread by Sarir Khamsi | last post: by
2 posts views Thread by Sudheer Kareem | last post: by
6 posts views Thread by wukexin | last post: by
6 posts views Thread by d.warnermurray | last post: by
reply views Thread by tbatwork828 | last post: by
5 posts views Thread by Steve | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.