27 Jul 18 · victor ·       Add to Favorites  

Move space from one database to another in Teradata

Use the below SQL to move space from one database to another


CREATE DATABASE SPACEMOVE FROM SOURCE_DB_NAME AS PERM = 200000000000;
GIVE SPACEMOVE TO TARGET_DB_NAME;
DROP DATABASE SPACEMOVE;

victor

posted on 27 Jul 18

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Copied