Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Dependencies

Dependencies

From: áÌÅËÓÁÎÄÒ ÷. óÍÉÒËÉÎ <sandy_at_adm.les.lipetsk.ru>
Date: 2000/07/07
Message-ID: <8k43u6$pqh@news.lipetsk.su>#1/1

Hi All!
Problem:
There ara some objects in schema

TABLE table1

FUNCTION function1
BEGIN
  SELECT *
  FROM view1

  SELECT *
  FROM table1
END VIEW view1
AS
  SELECT function1
  FROM Dependencies:

table1

    function1

        view1
            function1

When I try ALTER/DROP function1, view1:
ORA-00600: internal error code, arguments: [4882], [561014708], [566901908], [560833668], [], [], [], []

When I try ALTER/DROP table1:
ORA-00604 error occurred at recursive SQL level 1 ORA-01000 maximum open cursors exceeded

Have you any information to cure this problem without drop schema? Received on Fri Jul 07 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US