Home » SQL & PL/SQL » SQL & PL/SQL » How to create a view (Oracle 9i)
How to create a view [message #569604] Tue, 30 October 2012 05:10 Go to next message
kumar_hi21@yahoo.com
Messages: 6
Registered: August 2012
Location: chennai
Junior Member
Dear Experts,

I am trying to create view ..Using totally Five tables....

The main driven table almost 10 GB Data

When i am creating a view..

End of communication channel Error raise...

At the same time I am running query ..Running Fine...

Kindly Advice me ...

Thanks in Advance
Kumar
Re: How to create a view [message #569606 is a reply to message #569604] Tue, 30 October 2012 05:17 Go to previous messageGo to next message
tigsav
Messages: 38
Registered: April 2012
Member
Hi Kumar,

Please carry that entire activity in SQL Plus session and post it for easy understanding of all the members.

Thanks
Srinivas
Re: How to create a view [message #569608 is a reply to message #569604] Tue, 30 October 2012 05:20 Go to previous messageGo to next message
kumar_hi21@yahoo.com
Messages: 6
Registered: August 2012
Location: chennai
Junior Member
Hi,

Thanks for your Reply...

Select query Running no error..

I am trying to create the view ..Error Occured

ORA - 03113 Occured


Thanks
Re: How to create a view [message #569609 is a reply to message #569608] Tue, 30 October 2012 05:21 Go to previous messageGo to next message
Michel Cadot
Messages: 58643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

Regards
Michel
Re: How to create a view [message #569611 is a reply to message #569608] Tue, 30 October 2012 05:25 Go to previous messageGo to next message
kumar_hi21@yahoo.com
Messages: 6
Registered: August 2012
Location: chennai
Junior Member
Query


[EDITED by LF: applied [code] and [spoiler] tags to cut a long query short and make it beautiful]

[Updated on: Tue, 30 October 2012 13:12] by Moderator

Report message to a moderator

Re: How to create a view [message #569612 is a reply to message #569611] Tue, 30 October 2012 05:30 Go to previous message
Michel Cadot
Messages: 58643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 30 October 2012 11:21
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

Regards
Michel

Previous Topic: Difference between Deterministic functions and Function result cache in 11g
Next Topic: Select query to get top two rows based on statusdate (merged 3)
Goto Forum:
  


Current Time: Fri Aug 01 18:15:28 CDT 2014

Total time taken to generate the page: 0.09752 seconds