Move Space in Teradata using command

CREATE DATABASE TMP_DB FROM "Database_A" AS perm = 1e+09;       -- 1 GB

GIVE TMP_DB TO "Database_B";

DROP DATABASE TMP_DB;


Here Database_A is the database from where space will move and Database_B is the database where space to move.

Comments