ORA-32033: unsupported column aliasing
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 |
RMAN-06168: no backup pieces with this tag found: string
PLS-00523: ORDER methods must return an INTEGER.
RMAN-05019: WARNING: no channel of required type allocated to recover copy of datafile number
ORA-13336: failure in converting standard diminfo/geometry to LRS dim/geom
RMAN-06190: PL/SQL package string.string version string in string database is not current
ORA-02185: a token other than WORK follows COMMIT
ORA-08318: sllfsk: Error reading file
DRG-11873: System Call Replies
ORA-36982: (XSRELGID03) The grouping variable/relation workspace object must be dimensioned by all dimensions of the source relation workspace object which have more than one element in status.
ORA-14254: cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table
DRG-11833: Request-URI Too Big
ORA-25956: join index cannot be created on tables owned by SYS