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!