change multifile-TS to bigfile-TS

Hi,

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?

Any ideas?

Thanks!

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 :D

Quote:

---

Originally Posted by jennifer2007

Hi, is there any advantage/disadvantage between the two TS types?
smaller multifile TS seem handy and manageable to copy/backup :D

---

do you even understand what a bigfile tablespace is?

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:cool:

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

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 :)