Question on bigfiles

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!

Other related posts: