Re:Question on bigfiles

many pros/cons can be O.S. related, which is your version for Oracle and O.S.? What is the backup type you use?

As a first caveat, backup may be an issue, some tape drives (not too updated, indeed) may not handle > 2Gb files.

Alessandro

>
>I'm trying to decide whether to use bigfiles for some of our datawarehouse
>tablespaces. What are the advantages/disadvantages of using bigfiles
>instead of several, say 2GB datafiles?
>
>Thank you
>
>Ana
>
>---------------------------------------------------------
>Ana E. Choto
>Senior Oracle Database Administrator
>American University
>Office of Information Technology
>Phone (202) 885-2275
>Fax (202) 885-2224
>
>** AU IT will never ask for your password via e-mail.
>Don't share your password with anyone!

--
http://www.freelists.org/webpage/oracle-l