I’ve been messing with Oracle Database 12c (12.1.0.1) today. As I’ve been working at setting up a few things to test, I realized I need to create a tablespace or two and I didn’t have a post on how to create tablespaces with Oracle Database 12c.
Before I can do any testing, I have to setup a few tablespaces for the SLOB testing tool. Below is how to simply create tablespaces using Oracle Managed Files (OMF) within Oracle Database 12c.
Traditional/Container Database
This is a top level database. For a traditional style database (non-CDB), created a tablespace is just like in previous versions.
create tablespace SLOB datafile size 1M autoextend on next 1m;
With a Container Database (CDB), first make sure you are in the correct container. This can be done with either SHOW CON_ID or SHOW CON_NAME.
The CDB is always container id of 1. Using the CON_NAME option, the top level container name is called CDB$ROOT.
Now to create a tablespace in the CDB, you need to be logged in as a SYSDBA. Then you can run the same command to create the tablespace as you did for a traditional database.
create tablespace SLOB datafile size 1M autoextend on next 1m;
Pluggable Databases
To create tablespaces in the pluggable databases (PDB), you need to ensure that you are in the correct container you want to create the tablespace for. PDBs have container ids greater than 2. The CON_NAME option is also a good way to ensure that you are in the correct container as well.
Now that you have confirmed that you are in the correct container; now you can create the tablespace.
create tablespace SLOB datafile size 1M autoextend on next 1m;
How to check where the tablespaces are located
Everyone’s first response for checking on where the location of tablespace are located is to look at DBA_TABLESPACES. Within the Database 12c architecture, this view is valid for the container you are in. Oracle has provided a few new views to use with Database 12c. These views are called the CDB views. If you want to see the tablespaces you created above and in what container they are in, the CDB_TABLESPACES view needs to be used.
Set the container back to CDB$ROOT and verify that you are in the correct container.
Now that you are back in the CDB container lets use the CDB_TABLESPACE view to see what containers you created a SLOB tablespace in.
As you can see the SLOB tablespace has been created in the containers 1, 3 and 4. If you want to find the names for the con_ids, these can be found in the CDB_PDBS view. CON_ID for 2, is for the seed PDB which is used for cloning of PDBs.
Oracle Enterprise Manager 12c view
Everything that has been shown has used SQL and SQL*Developer. The same information can be found in Oracle Enterprise Manager 12c (OEM) under the container database. The screen shot below shows the SLOB tablespaces in OEM.
Enjoy!
twitter: @dbasolved
blog: http://dbasolved.com
Please follow and like:
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
Your style is unique in comparison to other people I’ve read stuff from. Many thanks for posting when you have the opportunity, Guess I will just book mark this blog.
I am really impressed with your writing skills and also with the layout on your weblog. Is this a paid theme or did you modify it yourself? Anyway keep up the excellent quality writing, it’s rare to see a nice blog like this one nowadays.
I got this website from my pal who shared with me about this web site and at the moment this time I am visiting this website and reading very informative posts here.
Hey would you mind sharing which blog platform you’re using? I’m planning to start my own blog soon but I’m having a hard time selecting between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I’m looking for something unique. P.S Sorry for being off-topic but I had to ask!
I blog quite often and I genuinely appreciate your information. This article has really peaked my interest. I will book mark your site and keep checking for new information about once per week. I opted in for your Feed too.
I have been surfing online more than 2 hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. In my opinion, if all web owners and bloggers made good content as you did, the web will be a lot more useful than ever before.
Hi, after reading this remarkable paragraph i am also glad to share my experience here with friends.
What’s up it’s me, I am also visiting this web page on a regular basis, this web page is actually nice and the visitors are in fact sharing pleasant thoughts.
I really like it whenever people come together and share ideas. Great website, continue the good work!
Hi there mates, its great paragraph regarding teachingand fully explained, keep it up all the time.
Greetings! I know this is kind of off topic but I was wondering if you knew where I could find a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having trouble finding one? Thanks a lot!
Hello there, just became aware of your blog through Google, and found that it’s really informative. I’m gonna watch out for brussels. I will be grateful if you continue this in future. Numerous people will be benefited from your writing. Cheers!
Ahaa, its fastidious discussion on the topic of this piece of writing at this place at this weblog, I have read all that, so at this time me also commenting here.
Heya! I realize this is somewhat off-topic but I had to ask. Does running a well-established blog like yours take a lot of work? I’m brand new to blogging but I do write in my journal every day. I’d like to start a blog so I can easily share my own experience and views online. Please let me know if you have any kind of ideas or tips for new aspiring blog owners. Appreciate it!
We are a group of volunteers and starting a brand new scheme in our community. Your web site offered us with helpful information to work on. You’ve performed an impressive process and our entire community will likely be grateful to you.
Great blog you have here but I was curious if you knew of any discussion boards that cover the same topics talked about in this article? I’d really like to be a part of community where I can get responses from other knowledgeable people that share the same interest. If you have any recommendations, please let me know. Appreciate it!
Hi, of course this post is genuinely pleasant and I have learned lot of things from it concerning blogging. thanks.
This site was… how do you say it? Relevant!! Finally I’ve found something which helped me. Kudos!
Right now it appears like Expression Engine is the preferred blogging platform out there right now. (from what I’ve read) Is that what you’re using on your blog?
Great post. I’m going through a few of these issues as well..
What’s up to every , since I am in fact keen of reading this weblog’s post to be updated regularly. It includes fastidious material.
If some one wants expert view on the topic of blogging afterward i recommend him/her to pay a visit this website, Keep up the pleasant job.
Good blog you have here.. It’s hard to find excellent writing like yours nowadays. I really appreciate individuals like you! Take care!!
Fantastic goods from you, man. I have take note your stuff previous to and you’re just extremely fantastic. I really like what you’ve obtained right here, certainly like what you are saying and the way in which wherein you are saying it. You are making it enjoyable and you continue to care for to keep it smart. I can not wait to learn far more from you. That is really a tremendous web site.
Greetings, I do believe your blog could possibly be having browser compatibility issues. Whenever I look at your web site in Safari, it looks fine however, if opening in I.E., it’s got some overlapping issues. I merely wanted to give you a quick heads up! Aside from that, wonderful website!
I loved as much as you will receive carried out right here. The sketch is attractive, your authored subject matter stylish. nonetheless, you command get got an nervousness over that you wish be delivering the following. unwell unquestionably come more formerly again as exactly the same nearly very often inside case you shield this hike.
Everything is very open with a really clear description of the issues. It was really informative. Your site is useful. Many thanks for sharing!
Because the admin of this web page is working, no hesitation very rapidly it will be famous, due to its quality contents.
Woah! I’m really loving the template/theme of this website. It’s simple, yet effective. A lot of times it’s hard to get that “perfect balance” between usability and visual appearance. I must say that you’ve done a very good job with this. In addition, the blog loads extremely quick for me on Internet explorer. Exceptional Blog!
It’s wonderful that you are getting ideas from this paragraph as well as from our dialogue made at this time.
Tremendous things here. I am very satisfied to peer your article.
Thank you so much and I am taking a look forward to contact you.
Will you kindly drop me a e-mail?
Review my web page :: eharmony special coupon code 2025
Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You obviously know what youre talking about, why waste your intelligence on just posting videos to your site when you could be giving us something informative to read?
I’ve learn some good stuff here. Definitely value bookmarking for revisiting. I wonder how much effort you put to make the sort of great informative website.
I do not even understand how I ended up here, however I thought this publish was great. I don’t recognise who you are however certainly you’re going to a famous blogger when you are not already. Cheers!
This is very interesting, You’re a very skilled blogger. I have joined your rss feed and look forward to seeking more of your fantastic post. Also, I’ve shared your web site in my social networks!
Thanks for sharing your info. I truly appreciate your efforts and I will be waiting for your further write ups thanks once again.
Hiya very cool site!! Man .. Excellent .. Superb .. I will bookmark your site and take the feeds also? I am satisfied to seek out numerous helpful info right here in the post, we want develop extra strategies on this regard, thank you for sharing. . . . . .
The other day, while I was at work, my sister stole my apple ipad and tested to see if it can survive a 25 foot drop, just so she can be a youtube sensation. My apple ipad is now broken and she has 83 views. I know this is entirely off topic but I had to share it with someone!
Hi! Do you know if they make any plugins to assist with SEO? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good gains. If you know of any please share. Many thanks!
I am sure this article has touched all the internet visitors, its really really fastidious post on building up new website.
Someone essentially help to make severely articles I would state. This is the first time I frequented your web page and to this point? I amazed with the research you made to make this particular post amazing. Great activity!
Your means of explaining all in this piece of writing is actually pleasant, all be capable of without difficulty be aware of it, Thanks a lot.
Hi, just wanted to tell you, I enjoyed this post. It was helpful. Keep on posting!
Wow that was odd. I just wrote an very long comment but after I clicked submit my comment didn’t appear. Grrrr… well I’m not writing all that over again. Anyway, just wanted to say superb blog!
I do not even know the way I finished up here, however I believed this put up was great. I don’t recognize who you’re however certainly you’re going to a famous blogger if you happen to aren’t already. Cheers!
Amazing blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple tweeks would really make my blog shine. Please let me know where you got your design. With thanks
I think that everything published was actually very logical. However, what about this? suppose you added a little content? I mean, I don’t wish to tell you how to run your website, however what if you added a title that makes people desire more? I mean Create a tablespace in #DB12C is a little vanilla. You could peek at Yahoo’s front page and watch how they create post headlines to get viewers interested. You might try adding a video or a related pic or two to get readers excited about what you’ve written. Just my opinion, it might bring your website a little bit more interesting.
You actually make it seem so easy with your presentation but I find this topic to be really something which I think I would never understand. It seems too complex and very broad for me. I’m looking forward for your next post, I’ll try to get the hang of it!
Thanks to my father who told me about this weblog, this website is truly remarkable.
Fine way of explaining, and good post to obtain information on the topic of my presentation topic, which i am going to present in college.
If some one wishes expert view concerning blogging afterward i recommend him/her to visit this webpage, Keep up the nice work.
If some one needs expert view on the topic of blogging afterward i propose him/her to visit this blog, Keep up the fastidious work.
Whoa! This blog looks just like my old one! It’s on a entirely different subject but it has pretty much the same page layout and design. Outstanding choice of colors!
Have you ever thought about writing an e-book or guest authoring on other blogs? I have a blog centered on the same information you discuss and would really like to have you share some stories/information. I know my visitors would value your work. If you are even remotely interested, feel free to send me an email.
Thanks for sharing your thoughts on %meta_keyword%. Regards
Post writing is also a excitement, if you be acquainted with afterward you can write if not it is complicated to write.
Hey are using WordPress for your site platform? I’m new to the blog world but I’m trying to get started and set up my own. Do you require any coding expertise to make your own blog? Any help would be greatly appreciated!
Awesome! Its truly amazing article, I have got much clear idea regarding from this piece of writing.
It’s difficult to find well-informed people for this subject, however, you sound like you know what you’re talking about! Thanks
Wow, this piece of writing is good, my sister is analyzing these kinds of things, so I am going to convey her.
When some one searches for his necessary thing, thus he/she wishes to be available that in detail, so that thing is maintained over here.
you are in point of fact a excellent webmaster. The website loading speed is amazing. It seems that you are doing any distinctive trick. Moreover, The contents are masterwork. you’ve performed a excellent job in this topic!
I think the admin of this website is truly working hard for his site, for the reason that here every material is quality based material.
constantly i used to read smaller content which as well clear their motive, and that is also happening with this article which I am reading at this place.
Very good post. I’m experiencing many of these issues as well..
If you are going for most excellent contents like I do, only go to see this website every day because it provides quality contents, thanks
Hello there I am so grateful I found your blog page, I really found you by accident, while I was researching on Digg for something else, Nonetheless I am here now and would just like to say kudos for a remarkable post and a all round exciting blog (I also love the theme/design), I don’t have time to browse it all at the minute but I have bookmarked it and also added in your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the excellent work.
Hi there! Do you know if they make any plugins to assist with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good results. If you know of any please share. Many thanks!
I am in fact delighted to read this weblog posts which consists of lots of helpful data, thanks for providing these data.
Hello! I’ve been reading your site for a while now and finally got the courage to go ahead and give you a shout out from Humble Tx! Just wanted to mention keep up the fantastic work!
Do you mind if I quote a couple of your articles as long as I provide credit and sources back to your blog? My website is in the very same niche as yours and my visitors would really benefit from some of the information you provide here. Please let me know if this ok with you. Appreciate it!
Hi there are using WordPress for your blog platform? I’m new to the blog world but I’m trying to get started and set up my own. Do you need any html coding knowledge to make your own blog? Any help would be really appreciated!
My brother recommended I might like this website. He was totally right. This post truly made my day. You cann’t imagine just how much time I had spent for this information! Thanks!
I do accept as true with all of the ideas you’ve offered on your post. They are very convincing and can certainly work. Nonetheless, the posts are too quick for beginners. May you please lengthen them a little from subsequent time? Thank you for the post.
I always emailed this webpage post page to all my associates, for the reason that if like to read it afterward my contacts will too.
Your means of telling everything in this article is actually good, every one can effortlessly understand it, Thanks a lot.
Hello there, You’ve done an incredible job. I will definitely digg it and personally suggest to my friends. I’m confident they will be benefited from this web site.
WOW just what I was searching for. Came here by searching for james bond 007 telugu dubbed movies online watch
Great weblog right here! Additionally your web site lots up very fast! What web host are you the use of? Can I am getting your associate link on your host? I desire my web site loaded up as quickly as yours lol
Hi there! I know this is kinda off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having trouble finding one? Thanks a lot!
Greetings I am so happy I found your blog page, I really found you by mistake, while I was browsing on Google for something else, Nonetheless I am here now and would just like to say many thanks for a fantastic post and a all round interesting blog (I also love the theme/design), I don’t have time to read through it all at the minute but I have bookmarked it and also added in your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the awesome work.
Wow that was strange. I just wrote an very long comment but after I clicked submit my comment didn’t appear. Grrrr… well I’m not writing all that over again. Regardless, just wanted to say great blog!
Wonderful post! We are linking to this particularly great post on our website. Keep up the great writing.
Hello There. I found your blog using msn. This is a very well written article. I will be sure to bookmark it and come back to read more of your useful information. Thanks for the post. I’ll definitely comeback.
I’m not sure exactly why but this site is loading incredibly slow for me. Is anyone else having this issue or is it a problem on my end? I’ll check back later and see if the problem still exists.
I like what you guys tend to be up too. This kind of clever work and reporting! Keep up the good works guys I’ve incorporated you guys to blogroll.
This piece of writing is genuinely a fastidious one it helps new web visitors, who are wishing for blogging.
Excellent web site you have got here.. It’s hard to find quality writing like yours these days. I really appreciate individuals like you! Take care!!
Asking questions are actually good thing if you are not understanding anything fully, however this piece of writing gives nice understanding even.
Do you have any video of that? I’d want to find out more details.
This is the perfect webpage for anybody who really wants to find out about this topic. You realize so much its almost hard to argue with you (not that I personally would want to…HaHa). You definitely put a fresh spin on a topic that’s been written about for decades. Excellent stuff, just wonderful!
Howdy! I simply want to give you a huge thumbs up for the great info you
have here on this post. I will be returning to your
website for more soon.
Feel free to visit my web page – vpn