Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02449: unique/primary keys in table referenced by
foreign keys
- 1 Answers
- 4304 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-29827: keyword USING is missing
ORA-01124: cannot recover data file string - file is in use or recovery
IMP-00069: Could not convert to environment national character set's handle
ORA-33445: (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.
LPX-00237: invalid condition section keyword, must be INCLUDE or IGNORE
IMP-00076: Missing NLS_NCHAR_CHARACTERSET in props$
ORA-32127: REFs do not belong to any connection
ORA-07588: spdcr: $GETJPIW get image name failure
AMD-00152: Workspace "string" is not currently open.
RMAN-06564: must use the TO clause when the instance is started with SPFILE
ORA-13152: invalid HHCODE type
RMAN-06177: restore not done; all files readonly, offline, or already restored
Oracle Errors 
