Archives of the TeradataForum
Message Posted: Thu, 04 Feb 2010 @ 20:00:21 GMT
I believe you are on the right track.
The idea should be good enough for you to make the next move - yeah write a code.
Questions that you should ask yourself
- What parameters do i need to move space - Yes FromDatabase, ToDatabase, Space, Probably an OUT Parameter
- Should I pass Space as Bytes, MB, GB, TB - programmers consideration - You should handle it
- How do I actually move space - If you have used Teradata Administrator to move space, it would be extremely easy to guess (Create a temp database with required database under the owner from which you would like to move space and then issue a GIVE command to the change the ownership to the database that needs the database)
-Finally to reclaim the space to the target database, just nuke the temp database
If somebody has already given the code, then you could use this as first grader write up from me!
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023