tablespace resize

Hi,

Hi can somebody help me in resizing the tablespace here? Most of the tablespace is used. Database is oracle 8.1.5 Please tell if there is a really short way to do it OR if there are steps, please send some links

Thanks in advance.

Code:

---

================================================================================
TABLESPACE UTILIZATION REPORT - xxx@yyy  March 26, 2004
================================================================================
                                                                               
                              Total    Used    Free    Pct  Largest       
TABLESPACE                    (Mb)    (Mb)    (Mb)    Free  (Mb)  Fragments
--------------------------------------------------------------------------------
dabce                      6260.1  6218.1    42.0      .7    10.0      42

---

ok, lil bit of concepts here, you dont resize a tablespace you resize a datafiles

so in sqlpl*plus or svrmgrl

Code:

---

select file_name, bytes/1024/1024 from dba_data_files where tablespace_name = 'DABCE';

---

This will give you the current size in Mb

to resize do this

Code:

---

alter database datafile 'full_path_to_datafile' reisze XXXM;

---

where XXX is the new size

so for example this could be

Code:

---

alter database datafile '/u01/oradata/DB/dabce.dbf' resize 8000M;

---

This must be done with someone who was the alter database privelege, e.g. sys or system or someone with dba role.

alternatively,you can add a new datafile to the tablespace

Please remember resizing does not add up to the existing ones.
Say u r having the size for the existing datafile as 100M then resizing the datafile by 800M will not make the size of datafile 900M.
It will be 800M.

KAushik

HI,

Can you tell me what this means?

select file_name, bytes/1024/1024 from dba_data_files where tablespace_name = 'DABCE';


What is file_name and what is dba_data_files? Can you tell how to find their exact names.

alter database datafile 'full_path_to_datafile' reisze XXXM;

Also, how to find the full path to datafiles?

Thanks

Can somebody explain ASAP please?

Hi,

I tried issuing desc dba_data_files and it says table or view doesn't exist. I also tried sys.dba_data_files.

Hi Also,,

Where do I give that command? Will it work when I log in as su oracle?

Or should it be given at a sqlplus env? And how do I get the dba/sys privilege? Please note that I am performing an exercise.

U better RTM

Hi,

What's RTM? I am just looking for some answers. I don't think I should give up doing this task at this time. Thanks

Sorry I misunderstoof you. I just found that RTM is Read The Manual. You are right but unfortunately, I am supposed to do this pretty soon and I don't have time to RTM

You asked the question almost 3 days ago. In these 3 days time you could have simply read the Database Administrators Guide available on http://tahiti.oracle.com.