Oracle 9i Database Administration in 10 Minutes
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
In this Create Tablespace window you can give your tablespace a name and you can have as many data files as you like. You can also make the tablespace ONLINE/OFFLINE. If you create the tablespace with OFFLINE option then the tablespace will not be available to users you will grant access unless you make it ONLINE. Under the storage tab make sure it’s selected as “Locally Managed” otherwise you would have to take care of Extents management. It’s a nice feature available in Oracle 9i and 10g.
Figure 71: Manage data files using Oracle Enterprise
Manager (OEM).
________________________________________
Chapter 8: Oracle Enterprise Manger -A SQL-Less DB Mgmt Software
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: