How to create tables in oracle database using enterprise manager

The last post was on how to create tables in oracle database using sql plus platform. Today we’ll create a table using another platform which enterprise Manger.

Creating a table using enterprise manager seems to be a lot easier than writing the sql codes. Another advantage of using enterprise manager is that after creating tables you can still get the sql codes if you wish to learn it.

First log in to your database using enterprise manager. Remember that enterprise manager is a web based platform use to manager oracle database administration.

From the home page of the enterprise manager select schema as you can see encircled in red

Then select “Tables”

Click on create by the right hand side.

Normally your table should be a heap organized table, so tick the circle and select continue

Here type in the name of the table. I chose to create a table named books as you can see from the pictures. The schema should remain the same unless you have the privilege to create a table in other schema other than the one you logged in with.

You can change the tablespace if you wish to

You can go ahead and type in the table attributes and create. No can form of sql code is required that why I mentioned earlier that it is a lot easier to do on enterprise manager. Some people though prefer using sql plus including me.

You can view the sql codes of the table. To do that click on the ‘show sql’ on the top right hand side of the image.

One can actually use enterprise manager to learn sql codes on how to perform some certain tasks in oracle database administration. As an Administrator you need to be versatile, efficient in delivering excellent services to your clients or employers as the case may be.

Return and click ok to save the table you have created. You can view the attributes by selecting the name of the name and then view.

Also I can view it from sql plus as shown from the image below. Log in and describe the table name.