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 10 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 773 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.

s@ir@m 35 posts Joined 05/13
23 Oct 2013

Hi Adeel,
 
Can you give me exact sintax plz.
how to add a space as perticular user?
 
 
 

Sachin Ichake 3 posts Joined 06/13
23 Oct 2013

Use following steps to assign the space

CREATE DATABASE SPACEMOVE  FROM B AS PERM = 100000000000;

GIVE SPACEMOVE TO C1;    

DROP DATABASE SPACEMOVE ;

 

Sachin Ichake

You must sign in to leave a comment.