change multifile-TS to bigfile-TS

[krempe]

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!

[davey23uk]

alter table move tablespace xxxx and then rebuild the indexes

[jennifer2007]

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

[davey23uk]

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?

[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

[davey23uk]

so you dont understand then

[simply_dba]

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

[Bore]

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

[PAVB]

...all roads lead to ASM anyway