How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Node-Local or Clusterwide File Systems → When creating Oracle ACFS file system resources, you can create a node-local file system or to … can mount on. Depending on if it is created with SRVCTL or acfsutil commands, it may only mount on … one node, a subset of nodes, or all the configured nodes. In some cases, this could look the same as … certain configurations, such
Oracle ACFS and Dismount or Shutdown Operations → file before an Oracle ASM instance is shutdown or a disk group is dismounted. After the file systems … dismounted or the instance shut down. If the Oracle ASM instance or disk group is forcibly shut down … or fails while an associated Oracle ACFS is active, the file system is placed into an offline error … file
A.2.1 Enabling GeoRaster → By default the GeoRaster feature is disabled after the Oracle Spatial and Graph is initially installed. To enable GeoRaster, follow these steps: Connect to the database as SYS AS SYSDBA. Enter the following statement: EXECUTE MDSYS.enableGeoRaster; After GeoRaster is enabled, if you later upgrade the database, you do not need to re-enable GeoRaster.
System-Generated File Name or Fully Qualified File Name → Every file created in Oracle ASM gets a system-generated file name, otherwise known as a fully qualified file name. This is similar to a complete path name in a local file system. Oracle ASM generates file names according to the following scheme: +diskGroupName/databaseName/fileType/fileTypeTag.fileNumber.incarnation An example of a fully qualified file name is the following: +data/orcl/CONTROLFILE/Current.256.541956473
A.2.2 Ensuring Oracle XML DB Repository is Installed → For more information, see the installation and upgrade notes near the start of Chapter 1 in Oracle Spatial and Graph GeoRaster Developer's Guide. To use the GeoRaster feature of Oracle Spatial and Graph, Oracle XML DB Repository must be installed properly. (In general, you should ensure that Oracle XML DB Repository is installed before you install Oracle Spatial and Graph.) If Oracle Spatial and Graph
A.2 Ensuring That GeoRaster Works Properly After an Installation or Upgrade → To use the GeoRaster feature of Oracle Spatial and Graph, you must enable it and ensure that Oracle XML DB Repository is properly installed, as explained in these topics: Enabling GeoRaster Ensuring Oracle XML DB Repository is Installed
Migrating Oracle ASM Disk Groups with Oracle Cluster Registry or Voting Files → To migrate Oracle ASM disk groups with Oracle Cluster Registry (OCR) or voting files to Oracle ASM
Migrating Oracle ASM Disk Groups without Oracle Cluster Registry or Voting Files → To migrate Oracle ASM disk groups without Oracle Cluster Registry (OCR) or voting files to Oracle
6.2.3 Choosing Non-Ellipsoidal or Ellipsoidal Height → data: non-ellipsoidal or ellipsoidal. Although ellipsoidal height is widely used and is the default … many cases, there are applications for which a non-ellipsoidal height may be preferable or even
OR Expansion → In OR expansion, the optimizer transforms a query with a WHERE clause containing OR operators into … a query that uses the UNION ALL operator. The database can perform OR expansion for various reasons … . For example, it may enable more efficient access paths or alternative join methods that avoid … table using
char 'fmt' Match or Error? → When you insert or update a column value, the data type of the value that you specify must … , a value that you insert into a DATE column must be a value of the DATE data type or a character
You create one or more jobs using the DBMS_SCHEDULER.CREATE_JOB or DBMS_SCHEDULER.CREATE_JOBS procedures… → repeat interval, or both a program and schedule. You can also create jobs by specifying job programs
6.2.2 Choosing a Geodetic or Projected Coordinate System → coordinate system or a projected plane coordinate system. In deciding which approach to take with the … plane projection will never give accurate results for a large area such as Canada or Scandinavia. For … . Computations involving large areas or requiring very precise accuracy must account for the curvature of
Deprecated Subprograms or Commands → Table E-1 lists deprecated commands and their replacements that you can use to perform the same or
Running catexp.sql or catalog.sql → To use Import, you must run the script catexp.sql or catalog.sql (which runs catexp.sql ) after the … database has been created or migrated to a newer version. The catexp.sql or catalog.sql script
Objects, Not Types, Are Editioned or Noneditioned → noneditionable in the schema or the object has the NONEDITIONABLE property. Therefore, the \" CREATE [ OR … REPLACE ] Statements \" and \" ALTER Statements \" let you specify EDITIONABLE or NONEDITIONABLE. See
Table 6-7 OR Truth Table → OR TRUE FALSE UNKNOWN TRUE TRUE TRUE TRUE FALSE TRUE FALSE UNKNOWN UNKNOWN TRUE UNKNOWN UNKNOWN For … example, the following query returns employees who have a 40% commission rate or a salary greater … than $20,000: SELECT employee_id FROM employees WHERE commission_pct =.4 OR salary > 20000 ORDER BY employee_id;
21.4.5 Making an Index Invisible or Visible → Making an index invisible is an alternative to making it unusable or dropping it. An invisible … initialization parameter to TRUE at the session or system level. You cannot make an individual index … , then an error is returned. To determine whether an index is visible or invisible: Query the dictionary … views USER_INDEXES, ALL_INDEXES,
Task 2 Create One or More CDBs → When you have completed the necessary planning, you can create one or more CDBs using either the … Database Configuration Assistant (DBCA) or the CREATE DATABASE SQL statement. In either case, you must
10.4.1 Checking for Missing or Extra Files → file corresponding to MISSING nnnn is read-only or offline normal, then you can make the data file … to a data file that was not read-only or offline normal, then you cannot use the rename operation