All Forums Database
28 Feb 2012
Database Space Concerns

I am trying to create a new table in one of the databases and the free space for that database is ~300 GB. But I get an error message as "No more room in databasename". The new table is just ~15 GB in size.

Can any1 help me with the same..thanks..

Teradata NooB.
ulrich 816 posts Joined 09/09
28 Feb 2012

Did you specify the primary index? If not the first column is used by default.

Most likely that there is a skew issue.

If not check that the existsing tables in this database doesn't have huge skew.

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

ulrich 816 posts Joined 09/09
28 Feb 2012

http://forums.teradata.com/forum/tools/code-2644-no-more-room-in-database might also give some hints.

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.