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"
1. CREATE DATABASE TDAdmin20131211041448 FROM "DBC" AS perm = 322122547200
2. GIVE TDAdmin20131211041448 TO "dba_dat"
3. DROP DATABASE TDAdmin20131211041448
No comments:
Post a Comment