Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Post Unanswered: ORA-03113 while I try to create view

    Hi all I hope that someone will help me whit this problem

    Here is the situation: I use Oracle 9.2.0.1.0 Database and it works fine except one little thing.When I try to create view in my schema Oracle return error:

    ORA-03113: End of file on comunnication channel

    I know this error is not because of Net8 or Listener problem, usualy this error returns when some other error ocurs. I searched the internet and I find something about "two-task shadow processes" as possible problem. Can anybody help me with this. Here is the sample of creation script for this view:

    CREATE OR REPLACE VIEW P2 AS
    SELECT SUM(P.COLUMN_1) COLUMN_2, V.COLUMN_3, P.COLUMN_4
    FROM VIEW1 P, VIEW2 V
    WHERE TO_CHAR(P.COLUMN) = V.COLUMN
    GROUP BY V.COLUMN_3,P.COLUMN_4;

  2. #2
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102

    Re: ORA-03113 while I try to create view

    first check your alert.log and traces.

    do you use a database-link within some of your views ?
    if yes try to set
    event="10127 trace name context forever, level 1"
    in your pfile.
    ^/\x

  3. #3
    Join Date
    Nov 2003
    Posts
    2

    Re: ORA-03113 while I try to create view

    Originally posted by berxh3g
    first check your alert.log and traces.
    I have alredy checked my alert.log and I can't find anything suspicious in there, just usual messages about ARC processes.
    But in my core-dump file I found something. I dont understand anything there and I dont know how to decode that file :-( . I will atach this so if anyone can help me.

    Thanks 4 the help
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •