manoj pingale

• Dec 8th, 2005

 

I think there is a command to alter the table space by which u can add containers or devices to ur existing table space........

Raghunathan Asari

• Jul 23rd, 2007

 

User ALTER command to change the PRIQTY and SECQTY of the Tablespace.
Eg.
ALTER TABLESPACE db.ts  PRIQTY 50 SECQTY 50.
Here PRIQTY => primary quantity in 50 KB and
        SECQTY => Secondary quantitly 50 KB.
If the definition of the above parameter is lesser at the TS creation time, then the tablespace size will increase.

srinu86k

 Profile Answers by srinu86k 

• Dec 3rd, 2009

 

By altering its secqty values.