Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE
EXCHANGE SUBPARTITION



ORA-14282: FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION..

Answer / guest

Cause: The corresponding columns in the tables specified in
the ALTER TABLE EXCHANGE SUBPARTITION statement have
different FOREIGN KEY constraints.

Action: Ensure that the two tables do not have FOREIGN KEY
constraints defined on any column or disable all FOREIGN KEY
constraints on both tables. Then retry the operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NPL-00313: requested form string does not match actual form string

1 Answers  


ORA-37126: (XSCCOMP01) The COMPRESSED COMPOSITE workspace object can only be used as a base of a single variable.

1 Answers  


ORA-14049: invalid ALTER TABLE MODIFY PARTITION option

1 Answers  


PLS-00599: SAMPLE percentage must be in the range [0.000001,100)

1 Answers  


ORA-10918: TABLESPACE GROUP name cannot be the same as tablespace name

1 Answers  


ORA-25230: invalid value string, WAIT should be non-negative

1 Answers  


ORA-37001: You have one or more attached but unupdated analytic workspaces.

1 Answers  


ORA-02067: transaction or savepoint rollback required

1 Answers  


ORA-25106: only one of PARALLEL or NOPARALLEL clause may be specified

1 Answers  


PLS-01417: Use of %%attribute

1 Answers  


PCC-02398: Indicator ignored in this statement for this type

1 Answers  


ORA-08194: Flashback Table operation is not allowed on materialized views

1 Answers  


Categories