ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data

ORA-33920: (MAKEDCL34) The string SURROGATE must have one of
the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.

Question Posted / guest

1 Answers
2923 Views
I also Faced
E-Mail Answers

ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, T..

Answer / guest

Cause: The user attempted to define a surrogate without
specifying a valid data type.

Action: Specify the data type (ID, NTEXT, TEXT, NUMBER, or
INTEGER) in the definition of the surrogate.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06257: NETNTT: cannot send command line to shadow process

1 Answers

NNL-00517: Insert-replaces a data item under an existing name

1 Answers

ORA-00365: the specified log is not the correct next log

1 Answers

ORA-34296: (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).

1 Answers

ORA-04086: trigger description too long, move comments into triggering code

1 Answers

TNS-12526: TNS:listener: all appropriate instances are in restricted mode

1 Answers

RMAN-06495: must explicitly specify DBID with SET DBID command

1 Answers

ORA-07207: sigpidu: process ID string overflows internal buffer.

1 Answers

ORA-10647: Tablespace other than SYSTEM, string, string not found in read only mode

1 Answers

PLS-00230: OUT and IN OUT formal parameters may not have default expressions