DiskSpace Query

Database
Enthusiast

DiskSpace Query

How do you query logs of how much space was allocated from Source Database to Target Database? 

And whether that succeded or not

4 REPLIES 4
Enthusiast

Re: DiskSpace Query

Anyone please?

Teradata Employee

Re: DiskSpace Query

No interpretation of what you are asking occurs to me, unless you are talking about the DDL Create or Modify command operating on a database.  Can you give an example of SQL or some script that allocates space from Source Database to Target Database?

Enthusiast

Re: DiskSpace Query

In Teradata Admin, if I select a database and click move space from source to target database, what is the equivalent query statement I can execute in SQL Assistant?

Highlighted
Teradata Employee

Re: DiskSpace Query

Look at the generated SQL history. TD Admin issues a sequence of requests:

CREATE DATABASE someName FROM source AS PERM=bytesToMove;

GIVE someName TO target;

DROP DATABASE someName;