Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32033: unsupported column aliasing
- 3 Answers
- 19116 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-10916: TABLESPACE GROUP already specified
ORA-25304: Queue Table has primary/secondary instance affinity. Cannot add buffer
ORA-13158: Oracle object string does not exist
ORA-01239: database must be in ARCHIVELOG mode to use external cache
RMAN-06464: BACKUP BACKUPSET is not supported with VALIDATE option
RMAN-08090: channel string: starting proxy restore
ORA-16625: cannot reach the primary
ORA-27124: unable to detach from shared memory segment
ORA-19626: backup set type is string - can not be processed by this conversation
ORA-09880: sstasfre/sstasdel: shmdt error, unable to detach tas write page
ORA-09950: Unable to get server operating system privileges
QSM-02173: the unique constraints does not exist on the join columns of the inner table
Oracle Errors 
