When trying to add a datafile to a tablespace , got the error – ORA-32771: cannot add file to bigfile tablespace.
SQL> ALTER TABLESPACE BIG_TBSP1 add datafile ‘+DATA/df01.dbf’ size 130G;
ALTER TABLESPACE BIG_TBSP1 add datafile ‘+DATA/df01.dbf’ size 130G;
*
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace
SOLUTION:
A bigfile tablespace can contain only one datafile and no other datafile can be added to that.
SQL> select BIGFILE from dba_tablespaces where tablespace_name=’BIG_TBSP1’;
BIGFILE
———————– —
YES
How to increase space in Bigfile Tablespace?
BIGFILE tablespace stores its data in a single datafile with a much larger capacity.
We can resize the size of the datafile in BIGFILE tablespace using ALTER DATABASE Command
ALTER DATABASE DATAFILE ‘/+DATA/df0101.dbf’ RESIZE 180G;
Since BIGFILE Tablespace has only one datafile, there is no need to identify the datafile and increase its size.
We can use ALTER TABLESPACE command to resize at the tablespace level.
ALTER TABLESPACE BIG_TBSP1 RESIZE 180G;
SQL> ALTER TABLESPACE BIG_TBSP1 add datafile ‘+DATA/df01.dbf’ size 130G;
ALTER TABLESPACE BIG_TBSP1 add datafile ‘+DATA/df01.dbf’ size 130G;
*
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace
SOLUTION:
A bigfile tablespace can contain only one datafile and no other datafile can be added to that.
SQL> select BIGFILE from dba_tablespaces where tablespace_name=’BIG_TBSP1’;
BIGFILE
———————– —
YES
How to increase space in Bigfile Tablespace?
BIGFILE tablespace stores its data in a single datafile with a much larger capacity.
We can resize the size of the datafile in BIGFILE tablespace using ALTER DATABASE Command
ALTER DATABASE DATAFILE ‘/+DATA/df0101.dbf’ RESIZE 180G;
Since BIGFILE Tablespace has only one datafile, there is no need to identify the datafile and increase its size.
We can use ALTER TABLESPACE command to resize at the tablespace level.
ALTER TABLESPACE BIG_TBSP1 RESIZE 180G;
yes
Great post made here. One thing I’d like to say is that most professional job areas consider the Bachelors Degree as the entry level requirement for an online degree. Whilst Associate College diplomas are a great way to begin, completing your Bachelors opens many entrance doors to various employment goodies, there are numerous on-line Bachelor Course Programs available from institutions like The University of Phoenix, Intercontinental University Online and Kaplan. Another thing is that many brick and mortar institutions offer Online editions of their diplomas but usually for a substantially higher payment than the companies that specialize in online college diploma programs.
The articles you write help me a lot and I like the topic
Hello, I enjoy reading all of your article.
I wanted to write a little comment to support you.
Check out my website: nordvpn coupons inspiresensation – https://t.co,
I loved as much as you’ll receive carried out right here.
The sketch is attractive, your authored subject matter stylish.
nonetheless, you command get bought an nervousness over that you wish be delivering
the following. unwell unquestionably come more formerly again since
exactly the same nearly very often inside case you shield
this increase.
My website: nordvpn coupons inspiresensation
I’ve been browsing online more than three hours nowadays, yet
I never discovered any attention-grabbing article like yours.
It is pretty value sufficient for me. Personally, if
all site owners and bloggers made excellent content as you probably did,
the internet will likely be a lot more helpful than ever before.
Also visit my web-site :: nordvpn coupons inspiresensation (t.co)
I am extremely impressed with your writing skills as well as with the layout on your blog.
Is this a paid theme or did you customize it yourself?
Either way keep up the excellent quality writing, it is
rare to see a nice blog like this one these days.
Also visit my web site: Nordvpn Coupons Inspiresensation
Nordvpn Discount
350fairfax
What i do not understood is actually how you are not
actually much more neatly-liked than you may be right
now. You are so intelligent. You understand therefore considerably in relation to
this subject, made me in my opinion consider it from a lot of varied
angles. Its like men and women are not involved unless it is something to accomplish with Girl gaga!
Your own stuffs nice. All the time deal with it up!