All Forums Database
kartik.sitapara 7 posts Joined 12/10
30 Jun 2012
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.

ocirej23 9 posts Joined 04/11
01 Jul 2012

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

 

Adeel Chaudhry 448 posts Joined 04/08
02 Jul 2012

Another option can be as follows:

 

- Assign CREATE DATABASE rights to database C1

- Move space from DBC to C1

 

HTH!

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.