| Back to Questions Page |
| |
| Question |
ORA-38429: invalid datatype for a stored attribute: string |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: The (resulting) datatype for the attribute was not
appropriate for storing.
Action: Choose a stored attribute that has a resulting
datatype of NUMBER, VARCHAR2, CHAR or DATE.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38428: too many attributes selected for indexing |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: An attempt was made to create an expression filter
index with more than 490 indexed attributes.
Action: Remove some of the indexed attributes. Make sure
that the default indexed attributes associated with the
attribute set combined with the indexed attributes specified
in the Create Index Parameters clause are less than or equal
to 490.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38427: attribute string does not exist |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: An attempt was made to use an attribute set that does
not exist.
Action: Create the attribute set.
Please add more information about this Error  |
| Guest |
| |
| |
|
|
| |
| Question |
ORA-38426: attribute set assigned to an expression set may
not be dropped |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: An attempt was made to drop an attribute set when it
is still associated with an expression set.
Action: Un-assign the attribute set from the expression set
before dropping it.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38425: attribute set used for an index object may not be
unassigned |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: An attempt was made to un-assign an attribute set
from an expression set when there is an Expression Filter
index defined on the column.
Action: Drop the index before un-assigning the attribute set.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38424: no attribute set currently assigned to the
expression set |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: An attempt was made to un-assign an attribute set
from an expression set when there is no attribute set
assigned to it.
Action: No action is required.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38423: Attribute set created from an ADT may not be
extended. |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: An attempt was made to add an elementary attribute to
an attribute set created from an ADT.
Action: Create a new attribute set and add all the required
elementary attributes one at a time.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38422: invalid datatype for the attribute: string |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: An attempt was made to create an attribute with
invalid datatype.
Action: If the data type of the attribute is an ADT, make
sure that the type exists.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38421: attribute string already exists |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: An attribute with a matching name (or form) already
exists in the attribute set.
Action: Drop the existing attribute or choose a different
name for the new attribute.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38420: invalid stored attribute sub-expression: string |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: The sub-expression used for the stored expression was
invalid.
Action: Set serveroutput ON and repeat the operation for
additional information.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38419: invalid identifier in attribute : string |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: An identifier used in the stored/indexed attribute
sub-expression was not defined or was invalid.
Action: Create all the required elementary attributes and
user-defined functions and try again.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38418: ADT associated with the attribute set string does
not exist |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: The ADT with the same name as the attribute set was
not found in the current schema.
Action: Drop the attribute set and recreate it.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38417: attribute set string does not exist |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: An attempt was made to use an attribute set that does
not exist.
Action: Create the attribute set or choose an existing
attribute set.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38416: A stored attribute may not be longer then 300
characters. |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: An attempt was made to create a stored or indexed
attribute longer than 300 characters.
Action: A predicate with such attribute may not be indexed.
It will be evaluated as sparse predicate.
Please add more information about this Error  |
| Guest |
| |
| |
| Question |
ORA-38415: invalid name or datatype for the attribute: string |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Cause: An invalid name or datatype was used for the attribute.
Action: Set serveroutput ON and repeat the operation for
additional information.
Please add more information about this Error  |
| Guest |
| |
| |
|
| |
|
Back to Questions Page |