My Oracle Support Banner

How To Increase QSPACE Device Size? (Doc ID 2809508.1)

Last updated on OCTOBER 08, 2024

Applies to:

Oracle Tuxedo - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Goal

How to increase QSPACE device size?

Usually, qaddext can increase QSPACE size, but if universal device size is insufficient, qaddext fails as follows.

qaddext QSPACE
Size of extent in disk pages: 15000
Q_CAT:1431: ERROR: Add extent - failed to create table QSPACE.01, size 15000 for new extent on config /qspace
Q_CAT:1176: ERROR: Failed to add extent

In this situaion, how to increase device size instead of recreate larger device?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.