467,877 Members | 1,135 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Reorg fails when associated tablespace size reaches 1Gb

db27.2 (fp13) on AIX 5.2.

The following error is generated when attempting a reorg or, more
precisely, when the file associated with the reorg tablespace reaches
1Gb.

SQL2216N SQL error "-968" occurred while reorganizing a database
table.

I can happily export to a file > 1Gb as the same userid (who created
the reorg tablespace and attempted the reorg) and on the same
filesystem (which is large-file-enabled).

The userid I'm using is that of the instance owner.

Is there a 1Gb temporary tablespace file-size limit?
Nov 12 '05 #1
  • viewed: 4375
Share:
1 Reply
Ian
Bruce Pullen wrote:
db27.2 (fp13) on AIX 5.2.

The following error is generated when attempting a reorg or, more
precisely, when the file associated with the reorg tablespace reaches
1Gb.

SQL2216N SQL error "-968" occurred while reorganizing a database
table.

I can happily export to a file > 1Gb as the same userid (who created
the reorg tablespace and attempted the reorg) and on the same
filesystem (which is large-file-enabled).

The userid I'm using is that of the instance owner.

Is there a 1Gb temporary tablespace file-size limit?


I assume that the temp tablespace is not DMS.

Check the ulimit settings for the instance owner. If they've been set
recently to remove the default fsize limit (i.e. changed since the
instance was started, but prior to you logging in as the instance
owner), you may need to restart the instance for it to pick up the
change.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

27 posts views Thread by Raquel | last post: by
3 posts views Thread by datapro01 | last post: by
1 post views Thread by Roger | last post: by
9 posts views Thread by mike_dba | last post: by
9 posts views Thread by Mikael | last post: by
reply views Thread by bwmiller16 | last post: by
3 posts views Thread by jane | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.