Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32033: unsupported column aliasing
- 3 Answers
- 19229 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 |
SQL*Loader-00475: field for dynamic file name is string in table string
ORA-30037: Cannot perform parallel DML after a prior DML on the object
ORA-00254: error in archive control string 'string'
ORA-01640: cannot make tablespace read only with active transactions
PCC-02353: Semantic error at line number, column number, file string:
ORA-01103: database name 'string' in controlfile is not 'string'
ORA-31624: operation string not allowed when job in string state
PLS-00170: the SQL statement in an OPEN statement or FOR loop must be a SELECT
ORA-25269: cant specify sognature with get signature option
ORA-31451: invalid value string for capture_values, expecting: OLD, NEW, or BOTH
PCC-02446: FOR clause not allowed in a DEALLOCATE statement
NNC-00004: connection is broken
Oracle Errors 
