Managing Schema Objects This chapter discusses the creation and management of schema objects. It contains the following sections: ■ About Schema Objects ■ About Schema Object Management Privileges ■ About SQL Developer ■ Managing Tables ■ Managing Indexes ■ Managing Views ■ Managing Program...
Managing the Oracle Instance This chapter provides background information about the Oracle instance and instructions for managing the instance. This chapter contains the following sections: ■ Overview of the Oracle Instance and Instance Management ■ Shutting Down and Starting Up the Oracle Inst...
Modifying a Tablespace You can use EM Express to modify a tablespace. For example, you can extend it by increasing data file sizes or adding another data file, set it to automatically extend, change its space usage alert thresholds, or change its status to
Modifying Table Attributes You can use SQL Developer to add and delete table columns and to manage table constraints. This section contains the following topics: ■ Example: Adding Table Columns ...
Other Table Creation Considerations This section describes some additional considerations for creating tables. It contains the following topics: ■ User-Defined Types and Large Objects (LOBs) ■ Partitioned Tables and Indexes ■ Physical Storage Attributes See Also: ■
Performing Common Database Storage Tasks As data is added to your database, the tablespace requirements for your database change. As a database administrator (DBA), you can use EM Express to perform the following tasks to effectively manage the tablespaces and database storage: ■ Creating a Tabl...
Preface Oracle Database 2 Day DBA is a database administration quick start guide that teaches you how to perform day-to-day database administrative tasks. The goal of this book is to help you understand the concepts behind Oracle Databas...
Processes—In this field, specify the maximum number of processes that can simultaneously connect to the database. Enter a number or accept the default value of 300. The default value for this parameter is appropriate for many environments. The value you select should allow for ...
Shutting Down and Starting Up the Oracle Instance This section provides instructions about two methods you can use to start or shut down the Oracle instance: ■ Shutting Down and Starting Up Using SQL*Plus ■ Shutting Down and Starting Up Using the Windows Services Program ...
Single-Column and Concatenated You can create an index on just one column, which is called a single-column index, or on multiple columns, which is called a concatenated index. Concatenated indexes are useful when all the index columns are likely to be included in the WHERE clause of frequently e...
