Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Error 2644
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023