Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Drazenko.

Asked: October 22, 2017 - 1:55 am UTC

Last updated: October 23, 2017 - 8:46 am UTC

Version: 12c

Viewed 1000+ times

You Asked

Hi Tom,

I need to ask you for help, I am new to Oracle and trying to understand some aspects of db administration. I have one of the exercises to create tablespace using EM Express, however I should navigate to storage-> tablespace but under the storage I don't have tablespace as one of the choices in drop down menu. Can you give me some suggestions what should I do in order to have access to tabklespace?
I am logged in as sys as sysdba.

Thank you
Dray


and Connor said...

I think the exercise is wrong or out of date. Under Storage in EM Express there is only:

- Undo Management
- Redo Log Groups
- Archive Logs
- Control Files

EM Express really isn't a tool for managing the database, more just to monitor what is happening within it. I would say the best bet would be to download SQL Developer which has some basic admin features.

If you're feeling adventurous you can download Cloud Control which is the full blown version...

... but I'd start with SQL Developer

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thank you Connor McDonald

Drazenko Katanic, October 29, 2017 - 2:00 pm UTC

Thank you Connor for your directions, I have done some research and found out there are pdb (pluggable database login) and cdb (container database), I have created in sql login for pdb and I was able to locate tablespace and was able to create one. I am not sure if this is correct steps. It is hard to determine since there are so many explanation and that many opinions :)
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.