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
Restrictions on Foreign Key Constraints → None of the columns in the foreign key can be of LOB, LONG, LONG RAW, VARRAY, NESTED TABLE, BFILE … table or view must already be defined. A composite foreign key cannot have more than 32 columns. The … constraints. See "View Constraints". You cannot define a foreign key constraint in
Managing FOREIGN KEY Integrity Constraints → , focusing specifically on issues regarding FOREIGN KEY integrity constraints, which enforce relationships … between columns in different tables. Note: FOREIGN KEY integrity constraints cannot be enabled if the … constraint of the referenced primary or unique key is not present or not enabled.
Foreign Key References Primary Key by Default → If the column list is not included in the REFERENCES option when defining a FOREIGN KEY constraint … key of the specified table. Alternatively, you can explicitly specify the column(s) to reference in … list references a primary or unique key of the parent table. If it does not, then an informative error is returned.
Foreign Key Conflicts in a Streams Environment → A foreign key conflict occurs when the apply process applies a row LCR containing a change to a row … that violates a foreign key constraint. For example, in the hr schema, the department_id column in … the employees table is a foreign key of the department_id column in the departments
Rules for Multiple FOREIGN KEY Constraints → Oracle Database allows a column to be referenced by multiple FOREIGN KEY constraints; there is no … limit on the number of dependent keys. This situation might be present if a single column is part of two different composite foreign keys.
Datatypes and Names for Foreign Key Columns → You must use the same datatype for corresponding columns in the dependent and referenced tables. The column names do not need to match.
FOREIGN KEY Constraints in a Data Warehouse → In a star schema data warehouse, FOREIGN KEY constraints validate the relationship between the fact … sales_time_fk FOREIGN KEY (time_id) REFERENCES times (time_id) ENABLE VALIDATE; However, in some … situations, you may choose to use a different state for the FOREIGN KEY constraints,
Rewrite Checks Dimensions Primary Key/Foreign Key/Not Null Constraints → Primary Key/Foreign Key/Not Null Constraints Matching SQL Text Not Required Not Required Filtering the … a functional dependency or functional determinance. For example, if a table contains a primary key … the table that contains required column data provided the materialized view contains a key that
Restrictions on Foreign Key Constraints on REF Columns → … Restriction on the ENABLE Clause You cannot enable a foreign key that references a disabled unique … validated). You cannot drop a table whose primary key is being referenced by a foreign key even if the … foreign key constraint is in DISABLE NOVALIDATE state.
Privileges Required to Create FOREIGN KEY Integrity Constraints → To create a FOREIGN KEY constraint, the creator of the constraint must have privileged access to … key of the parent table. The Child Table The creator of the referential integrity constraint must … users can create constraints The owner of the parent table to explicitly decide if foreign keys can depend on the primary
Foreign Keys → When replicating tables with foreign key referential constraints, Oracle Corporation recommends … that you always index foreign key columns and replicate these indexes, unless no updates and deletes
Restrictions on Dropping Constraints You cannot drop a primary key or unique key constraint that is… → alter_external_table_clauses Use the alter_external_table_clause to change the characteristics of an external table. This clause has no affect on the external data itself. The syntax and semantics of the parallel_clause, enable_disable_clause, external_data_properties, and REJECT LIMIT clause are the same as described for CREATE TABLE. See the external_table_clause (in CREATE TABLE ). PROJECT COLUMN
About Nulls and Foreign Keys → Foreign keys allow key values that are all NULL, even if there are no matching PRIMARY or UNIQUE … keys. By default (without any NOT NULL or CHECK clauses), the FOREIGN KEY constraint enforces the … for NULL values in composite foreign keys, which requires that all components of the key
ORA-02428: could not add foreign key reference → subsequent error message. ORA-02428: could not add foreign key reference
ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY → for foreign key if the associated primary key is NORELY
Choosing How Foreign Keys Enforce Referential Integrity → specified with the definition of a FOREIGN KEY constraint: Prevent Delete or Update of Parent Key The … references the key. For example:CREATE TABLE Emp_tab ( FOREIGN KEY (Deptno) REFERENCES Dept_tab … KEY constraint. For example:CREATE TABLE Emp_tab ( FOREIGN
Key Storage → to the data table using a primary key to foreign key relationship. For example, EMPLOYEE_NUMBER is … . EMPLOYEE_NUMBER is a foreign key to the SSN_KEYS table which stores the encryption keys for each … Key storage is one of the most important, yet difficult, aspects of encryption. To
Restrictions on the using_index_clause You cannot specify this clause for a view constraint. You cannot… → separate exceptions table for each index-organized table to accommodate its primary-key storage. You
ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION → constraint defined on any column ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
ORA-14128: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION → -14128: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION