You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for OR


1 to 60 of 24556 results. Previous page Prev  Next next page
Results per page:  20 | 40 |  60 


Reference, 10g Release 1 (10.1)

3 Oracle Text CONTAINS Query Operators

OR (|)Use the OR operator to search for documents that contain at least one occurrence of any of the … query terms. Syntax Syntax Description term1 | term2 term1 or term2 Returns documents that contain term1 … or term2. Returns the maximum score of its operands. At least one term must exist; higher score … taken. Examples For example,

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

OCIObjectRefresh()Purpose Refreshes a persistent object from the most current database snapshot.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

CommentsThis function refreshes all pinned persistent objects and all unpinned persistent objects are freed from the object cache. See Also: For more information about refreshing, see the description of OCIObjectRefresh(), and the section "Refreshing an Object Copy". Caution: When objects are refreshed, the secondary-level memory of those objects could potentially move to a different place in memory. As a

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

err (IN/OUT)The OCI error handle. If there is an error, it is recorded in err and this function returns OCI_ERROR. Obtain diagnostic information by calling OCIErrorGet().

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Related FunctionsOCIObjectRefresh()

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Parametersenv (IN/OUT) The OCI environment handle initialized in object mode. See the description of OCIEnvCreate() and OCIInitialize() for more information.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

ref (OUT) [optional]If there is an error in refreshing the objects, ( *ref ) will point to the object that is causing the error. If ref is NULL, then the object will not be returned. If *ref is NULL, then a reference will be allocated and set to point to the object. If *ref is not NULL, then the reference of the object is copied into the given space. If the error is not caused by any of the object, the given ref is initialized

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Syntaxsword OCICacheRefresh ( OCIEnv *env, OCIError *err, CONST OCISvcCtx *svc, OCIRefreshOpt option, dvoid *context, OCIRef *(*get)(dvoid *context), OCIRef **ref );

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

object (IN)A pointer to the persistent object. The object must be pinned before this call.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

svc (IN)OCI service context.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

get (IN) [optional]A client-defined function which acts an iterator to retrieve a batch of objects that need to be refreshed. If the function is not NULL, this function will be called to get a reference of an object. If the reference is not NULL, then the object will be refreshed. These steps are repeated until a NULL reference is returned by this function. The parameter context is passed to get() for each invocation

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Syntaxsword OCICacheFlush ( OCIEnv *env, OCIError *err, CONST OCISvcCtx *svc, dvoid *context, OCIRef *(*get) ( dvoid *context, ub1 *last ), OCIRef **ref );

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

err (IN/OUT)The OCI error handle. If there is an error, it is recorded in err and this function returns OCI_ERROR. Obtain diagnostic information by calling OCIErrorGet().

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

context (IN) [optional]Specifies an user context that is an argument to the client callback function get. This parameter is set to NULL if there is no user context.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

option (IN) [optional]If OCI_REFRESH_LOADED is specified, all objects that are loaded within the transaction are refreshed. If the option is OCI_REFRESH_LOADED and the parameter get is not NULL, this function will ignore the parameter.

DML Reference, 10g Release 1 (10.1)

AGGMAP ADD or REMOVE model

AGGMAP ADD or REMOVE modelThe AGGMAP ADD or REMOVE model command adds or removes a model from a previously defined aggmap

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Related FunctionsOCIObjectFlush() OCICacheRefresh()

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

context (IN) [optional]Specifies an user context that is an argument to the client callback function get. This parameter is set to NULL if there is no user context.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Commentsconsistent with the database, an application can free or refresh objects in the cache. If the object to … (), OCILobAssign(), or OCILobLocatorAssign() or by assigning another LOB locator to it, then the flush … makes a copy of the LOB value that existed in the source LOB at the time of the assignment or copy of

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

err (IN/OUT)The OCI error handle. If there is an error, it is recorded in err and this function returns OCI_ERROR. Obtain diagnostic information by calling OCIErrorGet().

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

svc (IN)OCI service context.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

OCI Flush or Refresh FunctionsThis section describes the OCI flush or refresh functions. Table 17-5 Flush or Refresh Functions

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

PurposeRefreshes all pinned persistent objects in the cache.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

OCICacheFlush()Purpose Flushes modified persistent objects to the server

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Commentsobjects are flushed in the order that they are newed or marked updated or deleted. See Also

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

object (IN)A pointer to the persistent object, which must already be pinned.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Related FunctionsOCIObjectPin(), OCICacheFlush()

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Related FunctionsOCICacheRefresh()

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Syntaxsword OCIObjectFlush ( OCIEnv *env, OCIError *err, dvoid *object );

DML Reference, 10g Release 1 (10.1)

AGGMAP ADD or REMOVE model

Syntax AGGMAP {ADD  model  TO  aggmap |REMOVE  model  FROM  aggmap } Arguments ADDTemporarily adds a model to an aggmap object. The model is attached to the aggmap only for the duration of the session. Even when the analytic workspace has been updated and committed, the model is discarded from the aggmap when the session is closed.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

err (IN/OUT)The OCI error handle. If there is an error, it is recorded in err and this function returns OCI_ERROR. Obtain diagnostic information by calling OCIErrorGet().

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Parametersenv (IN/OUT) The OCI environment handle initialized in object mode. See the description of OCIEnvCreate() and OCIInitialize() for more information.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

ref (OUT) [optional]If there is an error in flushing the objects ( *ref ) will point to the object that is causing the error. If ref is NULL, then the object will not be returned. If *ref is NULL, then a reference will be allocated and set to point to the object. If *ref is not NULL, then the reference of the object is copied into the given space. If the error is not caused by any of the dirtied object, the given REF

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Parametersenv (IN/OUT) The OCI environment handle initialized in object mode. See the description of OCIEnvCreate() and OCIInitialize() for more information.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Syntaxsword OCIObjectRefresh ( OCIEnv *env, OCIError *err, dvoid *object );

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Parametersenv (IN/OUT) The OCI environment handle initialized in object mode. See the descriptions of OCIEnvCreate() and OCIInitialize() for more information.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

OCIObjectFlush()Purpose Flushes a modified persistent object to the server.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

Comments, and must be refreshed before they can be locked or flushed. This occurs when the user issues a SQL … statement or PL/SQL procedure to modify any object in the server. Caution: Modifications made to … . This function does nothing for transient objects or values.

Programmer's Guide, 10g Release 1 (10.1)

OCI Flush or Refresh Functions

get (IN) [optional]object. This is repeated until a NULL reference is returned by the client function or the parameter … are returned from the client function must be newed or pinned using the same service context

DML Reference, 10g Release 1 (10.1)

AGGMAP ADD or REMOVE model

REMOVETemporary or Custom Aggregates Most aggmap objects are defined to calculate variable values that are … to another). However, users might wish to create their own aggregates at runtime for forecasting or … what-if analysis, or just because they want to view the data in an unforeseen way. Adding temporary … or custom

Developer's Guide, 10g Release 1 (10.1)

And/Or Activities (Oracle Workflow Developer's Guide)

And/Or Activitiesnode should transition forward when any of those parallel branches complete or when all of the … that all branches complete before continuing. Use the Or activity as the node for several converging … WF_STANDARD.ANDJOIN. Or Completes when the activities from at least one converging branch complete. Calls a PL

Constant Field Values (Oracle Ultra Search Java API Reference), 10g Release 1 (10.1)

Or (Oracle Ultra Search Java API Reference)

oracle.ultrasearch.query Class OrClass Or java.lang.Object   extended by oracle.ultrasearch.query.Or All Implemented Interfaces: Query … public class Or extends java.lang.Object implements Query Combine two or more queries using logical … OR. Or is the logical complement of And. Since: 9.0.2 See Also: And Constructor Summary Or

2 Day DBA, 10g Release 1 (10.1)

5 Managing the Oracle Instance

Shutting Down and Restarting the Instance and DatabaseIf you need to shut down and later restart your instance or database, you can do this with the … Shutdown or Startup button, under the General heading on the Database Home page as shown in Figure 5-1, "Shutdown/Startup Button on Home Page".

2 Day DBA, 10g Release 1 (10.1)

10 Monitoring and Tuning the Database

Using the SQL Access Advisor, materialized views, or logs to create, drop, or retain for faster performance. You can select your … workload from different sources including current and recent SQL activity, a SQL repository, or a user … include possible indexes, materialized views, or materialized view logs that can improve your query … .

2 Day DBA, 10g Release 1 (10.1)

Oracle® Database

Oracle® Databaseother intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation … created software or as specified by law, is prohibited. The information contained in this document is … permitted in your license agreement for these Programs, no part of these Programs may be reproduced or … transmitted in any

2 Day DBA, 10g Release 1 (10.1)

4 Configuring the Network Environment

Oracle Net ManagerYou can access Oracle Net Manager from the command line or for Windows platforms through the Start … menu. For command line (UNIX, Linux, or Windows) run netmgr. On Windows choose: Start > Programs

2 Day DBA, 10g Release 1 (10.1)

7 Administering Users and Security

Administering Database UsersTo create new users or administer existing ones select the Administration property page on the … -1 is displayed. From this page you can view, add, edit, or delete database users. Figure 7-1 Users Page Description of the illustration users.gif

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Managing Access to Schema ObjectsBy default, only the owner of an object or users with advanced system privileges can access the … create or identify an existing role that you want to use. Find or create the role by clicking Roles … ; to create a new role, click Create on the Roles page. On the Edit Role or Create Role property … page, depending

Broker, 10g Release 1 (10.1)

8 D atabase Properties

Valid values SYNC or ASYNC or ARCHDatatype String Valid values SYNC or ASYNC or ARCH

Broker, 10g Release 1 (10.1)

8 D atabase Properties

Valid values FULL or READ_ONLY or NONEDatatype String Valid values FULL or READ_ONLY or NONE

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Viewing Indexescan use the name of the index or the name of the table on which the index is built. Select whether … the search is for an index or a table by clicking the appropriate entry in the Search By list. To … basic information about the index, such as its status and the column or columns on which it is built

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Managing Indexesindex provides a quick access path to table data. Indexes can be created on one or more columns of a … table's data or structure, such as adding new rows, updating rows, or deleting rows, are automatically

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Managing Package Bodies, the developer of the package may have wrapped one or more of the individual procedures or functions … misuse the application or for competitors to see the algorithms. However, wrapped code cannot be

2 Day DBA, 10g Release 1 (10.1)

5 Managing the Oracle Instance

Overview of an Instance and Instance Managementusers or applications and structural information about the database itself called database metadata … . Information is stored persistently in these files. In order for you to view or update the data … database but it cannot be accessed by any user or application. The properties of a database … Oracle database are separate entities,

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Starting dbconsole in WindowsOracleDBConsole. The status of this process is listed in the Status column, either Started or Stopped … is either Manual or Automatic and not Disabled. Click Start, if the process is not already started

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

Managing Your BackupsManaging backups consists of two things: managing the backups themselves as they exist on disk oror tape, as recorded in the repository Expired, meaning that the backup no longer exists on disk or … off-site or a disk that is not mounted at the moment). Backups can also be obsolete or not. An

2 Day DBA, 10g Release 1 (10.1)

10 Monitoring and Tuning the Database

Proactive Database Monitoringdatabase. It monitors the vital signs (or metrics) related to database health, analyzes the workload … administrator. The identified issues are either presented as alerts in Enterprise Manager or, if you

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Using DBCA to Configure Database Optionsadd database options that have not been previously configured for use with your database, for example: Oracle Label Security or Oracle OLAP.

2 Day DBA, 10g Release 1 (10.1)

6 Managing Database Storage Structures

About Undoundo the changes of a misguided or unintentional transaction, or it can be part of a recovery … state of the data at 10:00 a.m. regardless of any updates or inserts by other users during the 15 … minute query. To enable Oracle's flashback features, which enables you to view or recover data to a

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

Restore and Recovery Operationsline or through Enterprise Manager), the entire restore and media recovery operation can be performed … type of restore operation to perform. You can choose to recover a whole database or selected … tablespaces, datafiles, archived logs, or tables. Note: In some recovery scenarios, such as a complete … , the database may be shut