-
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
Cheers
Murali
-
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.
-
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|