change multifile-TS to bigfile-TS
is it possible to change a multifile-TS (20 files a 2 GB) to a single-file TS ('bigfile') WITHOUT EXPORT/IMPORT in Oracle10 or Oracle9?
alter table move tablespace xxxx and then rebuild the indexes
Hi, is there any advantage/disadvantage between the two TS types?
smaller multifile TS seem handy and manageable to copy/backup
do you even understand what a bigfile tablespace is?
Originally Posted by jennifer2007
yes dear...its i think a 1-file TS so if u got 1 big TS for the entire db
like 1 Tb is scary to backup to other media than a 100X10Gb smallfiles
which u can do paraller copy
Last edited by jennifer2007; 03-31-2007 at 03:39 AM.
so you dont understand then
Bigfile tablespaces reduce sga usage by an average 475 bytes per file.
With Bigfile tablespaces manageability becomes easier...No need to extend any datafiles to increase space...just add disk
But bigfile tablespaces should be used only in conjuction with a logical volume manager because of io load balancing issues
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Good point Simply_DBA. Jenny is right a file 1T in size, it's scary. So, you use it only with LVM or storage array or ASM, where you do not have a control of where your files are anyway
...all roads lead to ASM anyway
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width