Skip to main content

Using SQL Developer to create and view Tablespaces


Below are the steps Create and View Table Spaces settings using SQL Developer.

Required SQL developer version is version 3.0

To Create TableSpace :

Click on Menu View/DBA - DBA navigator window will appear.
In the DBA window add a new connection to the DB, and click connect.
Then under storage option right click on Tablespaces and choose New Tablespace to create new one.
Fill the Details as shown below:



To View the created table spaces:
Under Storage, Select Data Files:

It will display the below:







Comments


  1. Selenium Training in Chennai Searching for Best Selenium Training in Chennai ?.BITA Academy is the Best Selenium Training Institute in Chennai.. Our Selenium testing course is taught by Experts.Become a Selenium Certified Professional.

    ReplyDelete
  2. thanks for your details it's very use for my works

    web design company in

    velachery

    ReplyDelete

Post a Comment

Popular posts from this blog

Steps to Analyze AWR Report in Oracle

Steps to Analyze AWR Report in Oracle
AWR -Automaticworkload repository is a collection of persistentsystem performancestatisticsowned by SYS. It resides in SYSAUXtablespace. Bydefault snapshot are generated once every 60 min and maintained for 7 days. Each snapshot has a unique ID know as "snap_id". Snapshot detail can be found in "dba_hist_snapshot" view.
If we have Database performance issue and not the Database machine, then AWR Report is the place to look at. AWR is not used for real-time performance monitoring like the v$ tables. It is used for historical analysis of performance. AWR complements, but doesnot replace real-time monitoring.
Once AWR Report is generated in Oracle, the next task is to analyze it. By going through the AWR Report we can easily solve issues like slow database, high wait events, slow query and many more issues. Even though the report is lengthy, Analyzing or Reading relevant part of AWR Report can help to troubleshoot issues in easy and …