Politechnika Śląska - strona 297

Modifying a Tablespace - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 462

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 - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 371

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 - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 322

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 - wykład

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 245

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 - opracowanie

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 448

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 - opracowanie

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 504

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

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 287

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

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 406

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...

Standard Edition One

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 427

Standard Edition One—This installation type is suitable for workgroup, department, or web applications. It provides core relational database management services for single-server environments or highly distributed branch environments. Oracle Standard Edition One includes all the facilities neces...

Standard Edition

  • Politechnika Śląska
  • Oracle Databases
Pobrań: 0
Wyświetleń: 413

Standard Edition—This installation type is suitable for workgroup or department-level applications, and for small to medium-sized enterprises. It provides core relational database management services and options and includes an integrated set of management tools, replication, Web features, and f...