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!
With havin so much content do you ever run into any problems of plagorism or copyright violation? My blog has a lot of unique content I’ve either authored myself or outsourced but it appears a lot of it is popping it up all over the web without my agreement. Do you know any methods to help protect against content from being stolen? I’d genuinely appreciate it.
Thank you for your articles. They are very helpful to me. May I ask you a question? http://www.ifashionstyles.com
Thank you for your help and this post. It’s been great. http://www.kayswell.com
you are actually a good webmaster. The website loading pace is incredible. It kind of feels that you are doing any distinctive trick. Furthermore, The contents are masterpiece. you have done a magnificent activity on this matter!
I am also writing to make you be aware of of the incredible discovery my friend’s princess encountered using your blog. She even learned such a lot of pieces, with the inclusion of how it is like to have a very effective giving heart to have many others just thoroughly grasp chosen tricky topics. You actually did more than my expectations. Thank you for coming up with those essential, dependable, educational and also fun guidance on that topic to Jane.
Your articles are extremely helpful to me. Please provide more information! http://www.kayswell.com
Hi, i believe that i noticed you visited my website so i
got here to go back the prefer?.I am trying to find things to improve my web site!I suppose its adequate to make use of a few
of your ideas!!
Here is my site: eharmony special coupon code 2025
Please tell me more about your excellent articles http://www.kayswell.com
After looking into a number of the articles on your
blog, I honestly appreciate your technique of blogging. I book-marked it to my bookmark
webpage list and will be checking back soon. Take a look at my web site too and tell me your opinion.
Have a look at my web-site; vpn
I really like reading through a post that can make men and women think. Also, thank you for allowing me to comment!
I truly appreciate your technique of writing a blog. I added it to my bookmark site list and will
We’re a group of volunteers and starting a new scheme in our community.
Your site offered us with valuable information to work on. You have done a formidable job
and our whole community will be thankful to you.
gamefly https://tinyurl.com/28555853
I just like the helpful information you provide in your articles
For the reason that the admin of this site is working, no uncertainty very quickly it will be renowned, due to its quality contents.
Good post! We will be linking to this particularly great post on our site. Keep up the great writing
This is really interesting, You are a very skilled blogger.
I’ve joined your rss feed and look forward to seeking more of your magnificent
post. Also, I’ve shared your website in my social networks!
https://tinyurl.com/24dyn2m6 what is vpn connection
You nailed it.
Appreciating the time and energy you put into your website and in depth information you provide.
It’s nice to come across a blog every once in a
while that isn’t the same out of date rehashed information. Wonderful read!
I’ve saved your site and I’m including your RSS feeds to my Google account.
I couldn’t resist commenting. Perfectly written!
You nailed it.
This content is incredibly informative.
This should be featured everywhere.