Archives of the TeradataForum

Message Posted: Tue, 17 Aug 2004 @ 14:43:53 GMT

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

Vijay

There are a few ways to go about this. An easy to use interface called Teradata Administrator will enable you to move space from one database to another. If you have the demo database you might have Teradata Administrator. Once you have successfully moved the space you can press the F12 key and get the SQL history so you can follow the syntax and the process.

Currently your DBC database has no room on your demo database. (I know you already figured that out.) Here is how it works.

DBC is the top of the system. Database(s) and Users are created underneath DBC. In order for you to get space back to DBC you will either have to drop a database directly underneath DBC or you can give space to DBC.

To determine what databases DBC owns:

     SELECT TRIM(OwnerName),TRIM(DataBaseName),DBKind
        FROM dbc.Databases
        WHERE OwnerName = 'DBC'
        ORDER BY 1,2;

In order to move space from one database to another you have to create a tempdb under the database with the space and then GIVE that tempdb to the database where you want the space moved and then drop the tempdb. This will move the space to the parent database which at this time would be DBC.

Example:

     CREATE DATABASE TEMP_DDI_TEMP FROM "EDWADM" AS perm = 1000000;

     GIVE TEMP_DDI_TEMP TO "DBC";

     DROP DATABASE TEMP_DDI_TEMP;

The above SQL will move 1 mb of space from EDWADM to DBC.

I hope this helps...

Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master

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