Wednesday, December 11, 2013

move space in teradata

In teradata permanent space can be moved from one database to another, below is commands in sequence to perform this task.

1. CREATE DATABASE TDAdmin20131211041448 FROM "DBC" AS perm = 322122547200
2. GIVE TDAdmin20131211041448 TO "dba_dat"
3. DROP DATABASE TDAdmin20131211041448

No comments:

Post a Comment