27 Jul 18 · victor · #teradata ·   Bookmark   ×

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