Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02449: unique/primary keys in table referenced by
foreign keys
- 1 Answers
- 4221 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-24154: rule string.string already in rule set string.string
ORA-23317: a communication failure has occurred
ORA-27202: skgfpen: sbtpcend returned error
ORA-01100: database already mounted
IMG-00531: empty or null image processing command
ORA-31051: Requested access privileges not supported
ORA-34871: (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
NNL-00230: Controller NOCONFIRM mode is currently string
QSM-01071: a lossy join in materialized view, string, from table, string, not found in query
QSM-02049: subquery using the ANY clause in mv
ORA-01636: rollback segment 'string' is already online
ORA-19726: cannot plug data [string] at level string into database running at compatibility level string
Oracle Errors 
