ORA-12001: cannot create log: table 'string' already has a
trigger



ORA-12001: cannot create log: table 'string' already has a trigger..

Answer / guest

Cause: Materialized view logs are filled by a trigger on the
master table. That trigger cannot be created.

Action: To create a materialized view log, drop the current
trigger on the master.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12656: Cryptographic checksum mismatch

1 Answers  


ORA-27457: argument string of job "string.string" has no value

1 Answers  


ORA-28001: the password has expired

1 Answers  


RMAN-10037: RPC anomaly detected on channel string, upinblt=number

1 Answers  


ORA-01931: cannot grant string to a role

1 Answers  






ORA-06804: TLI Driver: could not bind an IPX address at initialization

1 Answers  


ORA-00054: resource busy and acquire with NOWAIT specified

1 Answers  


QSM-01129: query has NO_MULTIMV_REWRITE hint

1 Answers  


TNS-00200: Unable to do nsanswer on context result=string

1 Answers  


ORA-09260: sigpidu: error obtaining process id

1 Answers  


ORA-12675: External user name not available yet

1 Answers  


ORA-25405: transaction status unknown

1 Answers  


Categories