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.