suryapinna
asked on
CAN WE USE MUTIPLE GROUP FUNCTIONS IN ORACLE 9I
Hi
Please note this query is resulting an output in Oracle 10G but the same is not working with Oracle 9i
SELECT ProviderName, ProviderID, Count(ProviderID) AS NumOfReferrals, MAX(SubmitDate) AS MaxDate
FROM ReferralView
GROUP BY ProviderName, ProviderID;
I am given the below error trying to execute this query from the sql prompt and the session gets terminated.
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Please update
Thank you
Surya
Please note this query is resulting an output in Oracle 10G but the same is not working with Oracle 9i
SELECT ProviderName, ProviderID, Count(ProviderID) AS NumOfReferrals, MAX(SubmitDate) AS MaxDate
FROM ReferralView
GROUP BY ProviderName, ProviderID;
I am given the below error trying to execute this query from the sql prompt and the session gets terminated.
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Please update
Thank you
Surya
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> ORA-03113: end-of-file on communication channel
Yes you are right.
It is a very vague error, which could be resulted from N number of reasons.
Most of the times, it could be becuase of a bug and it may require patching.
The best resolution is - to contact Oracle support. They can dig your trace files and log files to locate the actual problem.
Yes you are right.
It is a very vague error, which could be resulted from N number of reasons.
Most of the times, it could be becuase of a bug and it may require patching.
The best resolution is - to contact Oracle support. They can dig your trace files and log files to locate the actual problem.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The error ORA-03113 occurs when an unexpected end-of-file occurred during the communication channel. There should be something else that is causing a communication failure between the server and your oracle client.
Are you using Unix or Linux environments where the environment variable TWO_TASK is set specifying that you are connecting to a remote server?
This error could also occur if the shadow two-task process associated with the connection terminated abnormally.
Let me check if there is any reference could be found on ORACLE and get back to you.
Good luck :)