I am Raju C padaria from INDIA. I have been using ORACLE 8.0.4 on AIX 4.3 with Windows NT 4.0 Client. Following is my oracle table space layout allocated to different users initially.

Now I need to reorganise one of the tablespaces (prdtst). The size of 'prdtst' tablespace is 100 MB. I need to reduce 100 MB from 'prod' tablespace & add it to 'prdtst' tablespace. How can I make it ?
Kindly guide me in this regard as I am new DBA.

Tablespace Size (Mb) Free (Mb) % Free
-------------------- --------------- ----------- ------
FIN 200 107 54
HRD 300 56 19
MRKT 100 45 45
MTRL 100 25 25
PRDTST 50 25 51
PROD 500 285 57
QA 150 119 79
------------------------------------------------------------------------
Thank U well in advance.

Raju C Padaria (Padariar@fag.co.in)

FAG Bearings INDIA Limited