27 July 2018        Add to Favorites   Report

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;


Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied