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
CREATE VIEW → Purpose Use the CREATE VIEW statement to define a view, which is a logical table based on one or … more tables or views. A view contains no data itself. The tables upon which a view is based are called … base tables. You can also create an object view or a relational view that supports
DROP VIEW → Purpose Use the DROP VIEW statement to remove a view or an object view from the database. You can … change the definition of a view by dropping and re-creating it. See Also: CREATE VIEW and ALTER VIEW … for information on creating and modifying a view Prerequisites The
ALTER VIEW → Purpose Use the ALTER VIEW statement to explicitly recompile a view that is invalid or to modify … view constraints. Explicit recompilation lets you locate recompilation errors before run time. You may … want to recompile a view explicitly after altering one of its base tables to ensure that the … alteration does
View Description → *_SCHEDULER_CHAIN_RULES These views show all rules for all chains. *_SCHEDULER_CHAIN_STEPS These views show all steps for all chains. *_SCHEDULER_CHAINS These views show all chains. *_SCHEDULER_CREDENTIALS These views show all credentials. *_SCHEDULER_GLOBAL_ATTRIBUTE These views show the current values of Scheduler attributes. *_SCHEDULER_JOB_ARGS These views show all set argument values for all
ALTER MATERIALIZED VIEW → Purpose A materialized view is a database object that contains the results of a query. The FROM … are called the master databases. Use the ALTER MATERIALIZED VIEW statement to modify an existing … materialized view in one or more of the following ways: To change its storage characteristics To change … materialized view
CREATE MATERIALIZED VIEW LOG → Purpose Use the CREATE MATERIALIZED VIEW LOG statement to create a materialized view log, which is … a table associated with the master table of a materialized view. Note: The keyword SNAPSHOT is … supported in place of MATERIALIZED VIEW for backward compatibility. When DML changes are made to master … table data,
DROP MATERIALIZED VIEW → Purpose Use the DROP MATERIALIZED VIEW statement to remove an existing materialized view from the … database. When you drop a materialized view, Oracle Database does not place it in the recycle bin … . Therefore, you cannot subsequently either purge or undrop the materialized view. Note: The keyword … SNAPSHOT
DROP MATERIALIZED VIEW LOG → Purpose Use the DROP MATERIALIZED VIEW LOG statement to remove a materialized view log from the … database. Note: The keyword SNAPSHOT is supported in place of MATERIALIZED VIEW for backward … compatibility. See Also: CREATE MATERIALIZED VIEW and ALTER MATERIALIZED VIEW for more information on
CREATE MATERIALIZED VIEW → Purpose Use the CREATE MATERIALIZED VIEW statement to create a materialized view. A materialized … view is a database object that contains the results of a query. The FROM clause of the query can name … : The keyword SNAPSHOT is supported in place of MATERIALIZED VIEW for backward compatibility. For … feature.
ALTER MATERIALIZED VIEW LOG → Purpose A materialized view log is a table associated with the master table of a materialized view … . Use the ALTER MATERIALIZED VIEW LOG statement to alter the storage characteristics or type of an … existing materialized view log. Note: The keyword SNAPSHOT is supported in place of MATERIALIZED VIEW
Updating a Join View → An updatable join view (also referred to as a modifiable join view ) is a view that contains more … , UPDATE, or DELETE operation on a join view can modify only one underlying base table at a time … . UPDATE Rule All updatable columns of a join view must map to columns of a key-preserved table. See \"Key
Task 2 -View Problem Details → You continue your investigation with the Problem Details page. To view problem details: On the … Incident page or Data Failure page, click View Problem Details. The Problem Details page appears … , showing the Incidents subpage. (Optional) To view incident details, select an incident, and then click … View. The
View Constraints → You can create constraints on views. The only type of constraint supported on a view is a RELY
11 SQL Statements: ALTER MATERIALIZED VIEW to ALTER SYSTEM → This chapter contains the following SQL statements: ALTER MATERIALIZED VIEW ALTER MATERIALIZED VIEW
Task 1 - View Critical Error Alerts in Enterprise Manager → alerts on the Database Home page. To view critical error alerts: Access the Database Home page in … to view the details of the problem associated with the critical error alert that you are … investigating, proceed with Task 2 -View Problem Details. If the graphical timeline shows a large number of … different problems over the
Expansion of Defining Queries at View Creation Time → When a view is created, Oracle Database expands any wildcard (*) in a top-level view query into a … query to be syntactically correct. As an example, assume that the dept view is created as follows … : CREATE VIEW dept AS SELECT * FROM scott.dept; The database stores the defining query of the dept view
Dynamic Performance View Descriptions → the \"Next\" button to go to the first dynamic performance view.
Materialized View Logs → Materialized view logs are required if you want to use fast refresh, with the exception of PCT … refresh. That is, if a detail table supports PCT for a materialized view, the materialized view log on … that detail table is not required in order to do fast refresh on that materialized view. As a general … rule,
Materialized View Schema Design → Summary management can perform many useful functions, including query rewrite and materialized view … realize significantly greater query execution performance and materialized view refresh performance … guidelines. A materialized view definition includes any number of aggregates, as well as any number of … joins. In several ways,
Analyzing Materialized View Capabilities → view or potential materialized view. In particular, this procedure enables you to determine: If a … materialized view is fast refreshable What types of query rewrite you can perform with this … materialized view Whether PCT refresh is possible Using this procedure is straightforward. You simply call … DBMS_MVIEW.EXPLAIN_MVIEW,