Oracle 9i Database Administration in 10 Minutes

- Asim Abbasi (Author)

CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning

Chapter 8: Oracle Enterprise Manger -A SQL-Less DB Mgmt Software

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

 

We can create new tablespace by right clicking any one of the tablespace mentioned in the list and then selecting the option “Create …” in the popped up window as shown in the slide above. Once we click the “Create …” option then the Create Tablespace window will pop up as shown in the next slide.

 

Figure 69: Create the new tablespace using this window.
________________________________________



 

Figure 70: Storage tab will gives you the option to select locally managed or Dictionary managed extents. You can also select to make the tablespace extend automatically in case it runs out of space by selecting “Automatic Allocation”.
________________________________________

 

Chapter 8: Oracle Enterprise Manger -A SQL-Less DB Mgmt Software

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning

Share with others: