Question on bigfiles

From: Ana Choto <>
Date: Mon, 26 Oct 2009 11:31:07 -0400
Message-ID: <>

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 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!

-- Received on Mon Oct 26 2009 - 10:31:07 CDT

Original text of this message