Archives of the TeradataForum

Message Posted: Wed, 09 Jan 2002 @ 17:52:11 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- 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.

Ex.
Database A - 100 GB unused perm - Owns Database B
Database B - 1 GB unused perm - Owns Database C
Database C needs 10 GB added to it.

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>