Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32033: unsupported column aliasing
- 3 Answers
- 19119 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-06140: NETTCP: no such user
IMP-00028: partial import of previous table rolled back: number rows rolled back
DRG-12202: error while creating section group
ORA-30565: Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified
RMAN-06099: error occurred in source file: string, line: number
PROC-00032: Cluster Ready Services on the local node is not running
IMP-00085: multiple input files specified for unbounded export file
ORA-25148: ONLINE option not permitted
ORA-12441: policy string already exists
NCR-03016: NCRO: Message has bad address
ORA-36636: (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
ORA-08112: a composite partition may not be coalesced as a whole
Oracle Errors 
