Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32033: unsupported column aliasing
- 3 Answers
- 19130 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bunditj
The database version is major problem. Using a column alias on subquery factoring, it is not allowed on 10g, but practical to 11g onwards.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / dhanabalan
ORA-32033: unsupported column aliasing
32033. 00000 - "unsupported column aliasing"
*Cause: column aliasing in WITH clause is not supported yet
*Action: specify aliasing in defintion subquery and retry
WITH Numbers(n) AS
(
SELECT 1 AS N
FROM dual
UNION ALL
SELECT N + 1 AS N
FROM Numbers
WHERE N < 9
)
SELECT *
FROM Numbers;
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / guest
Cause: column aliasing in WITH clause is not supported yet
Action: specify aliasing in defintion subquery and retry
Please add more information about this Error
| Is This Answer Correct ? | 4 Yes | 6 No |
ORA-36968: (XSRELTBL11) workspace object must be a relation.
ORA-02265: cannot derive the datatype of the referencing column
ORA-25204: invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP
NNL-00580: register_ns: <name server> <address> <domain>
ORA-29878: warning in the execution of ODCIINDEXTRUNCATE routine
ORA-16167: LGWR network server could not switch to non-blocking mode
ORA-32338: on commit refresh grab all the detailed tables
ORA-19573: cannot obtain string enqueue for datafile string
ORA-24907: invalid pair of callback and recepient protocol attributes
ORA-00096: invalid value string for parameter string, must be from among string
ORA-19578: end of volume while duplexing to sequential files, backup piece incomplete
ORA-04012: object is not a sequence
Oracle Errors 
