Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02449: unique/primary keys in table referenced by
foreign keys
- 1 Answers
- 4300 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: An attempt was made to drop a table with unique or
primary keys referenced by foreign keys in another table.
Action: Before performing the above operations the table,
drop the foreign key constraints in other tables. You can
see what constraints are referencing a table by issuing the
following command: SELECT * FROM USER_CONSTRAINTS WHERE
TABLE_NAME = "tabnam";
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-22991: insufficient space allocated for argument string
ORA-36982: (XSRELGID03) The grouping variable/relation workspace object must be dimensioned by all dimensions of the source relation workspace object which have more than one element in status.
ORA-12335: database (link name string) is not open
ORA-00476: RECO process terminated with error
ORA-02278: duplicate or conflicting MAXVALUE/NOMAXVALUE specifications
ORA-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT
ORA-29658: EXTERNAL NAME clause is not compatible with its supertype
ORA-08450: invalid specification of CR in picture mask
LSX-00167: defining form of "~S" must occur at the top level
RMAN-06734: Do you really want to drop all backups and the database (enter YES or NO)?
ORA-12036: updatable materialized view log is not empty, refresh materialized view
NNL-00573: load_tnsnames [<file>, ... ] : load tnsnames into ONames
Oracle Errors 
