How to add space to database

Database
Enthusiast

How to add space to database

HI, 

I have database structure as below 

                  A - BASE DATABASE

                  |

           ------------

         |               |  

        B               C

  ------------      --------------

|               |    |                 |

B1          B2  C1               C2

now my Load job is running on C1 database and I am gatting an error for space while fast load job, so how can i add space .

Please help me on this. 

Thanks in advance.

Tags (1)
4 REPLIES
Enthusiast

Re: How to add space to database

What I think you can do is add space on User/Database A. You can logon as dbc.

MODIFY DATABASE A AS PERM = 1e9;

then pass the perm space to C,

MODIFY DATABASE C AS PERM = 1e9;

then pass the perm space to C1,

MODIFY DATABASE C1 AS PERM = 1e9;

HTH

Cheers,

Eco

Teradata Employee

Re: How to add space to database

Another option can be as follows:

- Assign CREATE DATABASE rights to database C1

- Move space from DBC to C1

HTH!

s_1
Enthusiast

Re: How to add space to database

Hi Adeel,

Can you give me exact sintax plz.

how to add a space as perticular user?

Re: How to add space to database

Use following steps to assign the space

CREATE DATABASE SPACEMOVE  FROM B AS PERM = 100000000000;

GIVE SPACEMOVE TO C1;    

DROP DATABASE SPACEMOVE ;