Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02449: unique/primary keys in table referenced by
foreign keys
- 1 Answers
- 4196 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 |
TNS-00034: INTCTL: internal NR error
ORA-15070: maximum number of files string exceeded in diskgroup "string"
ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings
ORA-16504: The Data Guard configuration already exists.
ORA-06028: NETASY: unable to intialise for logging
TNS-12564: TNS:connection refused
ORA-12624: TNS:connection is already registered
ORA-32307: must use FROM ONLY clause when referencing an object table
ORA-32131: bind data type cannot be changed
NNC-00411: invalid default domain name "string"
ORA-12077: temporary updatable materialized view log does not exist
PCC-00070: Illegal syntax, Exponential value in SQL statement: string
Oracle Errors 
