Archives of the TeradataForum
Message Posted: Wed, 09 Jan 2002 @ 17:52:11 GMT
<-- Anonymously Posted: Wednesday, January 09, 2002 10:57 -->
If you have access to Teradata Manager's PMON utility, you can move space from any database with enough unused perm directly to any recipient database, and PMON will handle the SQL details.
To increase database perm space via raw SQL the user has to have Drop Database privileges on the database whose perm it intends to increase, and the immediate owner of that database has to have enough unused perm to give. Perm space is subtracted from the owner's unused perm and added to the recipient. If the owner does not have enough space, it's owner must give it the space to give.
Database B does not have 10 GB unused perm to give, so Database A must give 9 GB to Database B, who then gives 10 GB to database C.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|