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 FOREIGN KEY


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


SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on Foreign Key ConstraintsNone 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

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

3 Maintaining Data Integrity Through Constraints

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.

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

3 Maintaining Data Integrity Through Constraints

Foreign Key References Primary Key by DefaultIf 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.

Replication Administrator's Guide, 10g Release 1 (10.1)

3 Streams Conflict Resolution

Foreign Key Conflicts in a Streams EnvironmentA 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

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

3 Maintaining Data Integrity Through Constraints

Rules for Multiple FOREIGN KEY ConstraintsOracle 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.

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

3 Maintaining Data Integrity Through Constraints

Datatypes and Names for Foreign Key ColumnsYou must use the same datatype for corresponding columns in the dependent and referenced tables. The column names do not need to match.

Guide, 10g Release 1 (10.1)

7 Integrity Constraints

FOREIGN KEY Constraints in a Data WarehouseIn 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,

Guide, 10g Release 1 (10.1)

18 Query Rewrite

Rewrite Checks Dimensions Primary Key/Foreign Key/Not Null ConstraintsPrimary 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

SQL Reference, 10g Release 1 (10.1)

constraint

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.

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

3 Maintaining Data Integrity Through Constraints

Privileges Required to Create FOREIGN KEY Integrity ConstraintsTo 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

Advanced Replication, 10g Release 1 (10.1)

6 Planning Your Replication Environment

Foreign KeysWhen 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

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

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

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

3 Maintaining Data Integrity Through Constraints

About Nulls and Foreign KeysForeign 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

Error Messages, 10g Release 1 (10.1)

5 ORA-02140 to ORA-04099

ORA-02428: could not add foreign key referencesubsequent error message. ORA-02428: could not add foreign key reference

Error Messages, 10g Release 1 (10.1)

15 ORA-24280 to ORA-28674

ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELYfor foreign key if the associated primary key is NORELY

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

3 Maintaining Data Integrity Through Constraints

Choosing How Foreign Keys Enforce Referential Integrityspecified 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

Security Guide, 10g Release 1 (10.1)

16 Developing Applications Using Data Encryption

Key Storageto 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

SQL Reference, 10g Release 1 (10.1)

constraint

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

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITIONconstraint defined on any column ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

Error Messages, 10g Release 1 (10.1)

13 ORA-12700 to ORA-19361

ORA-14128: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION-14128: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION