Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I have 1TB tablespace that have one bigfile , The disk size now full and added extra disk to my server but there is no way to expand Drive that bigfile in it , so need to add another bigfile ,if create new tablespace I got error : ORA-32771: Cannot Add File To Bigfile Tablespace
I have Disk 1 : with 1TB size and one drive named C: now Added Disk 2 : with 500GB with Latter D:
so I need to expand my database tablespace into two drive or some way that can do it for me.
A bigfile tablespace can only contain one datafile, so you cannot expand a bigfile tablespace across two physical disks unless you are using a virtual filesystem or Oracle ASM that makes the added space appear as part of the same disk to the database. Typically this kind of configuration must be planned in advance, before the database is created.
Your only option to use the second physical disk is to create a second, independent tablespace.
The disk size now full
That said, if your C: drive is 100% full, you may have other problems. Typically, Windows performance starts to deteriorate when the C: drive becomes too full (like over 80%), and your bigfile tablespace is designed to fill an entire disk. Placing it on the same drive with your operating system is probably not a good idea. Bigfile tablespaces should generally only be used on disks or filesystems that don't contain any other files.
