I have a problem to create a constraint referencing table in another schema

From: Mathias Kluge <software_at_dgateway-ger.com>
Date: 9 Dec 2002 07:04:19 -0800
Message-ID: <263641f3.0212090704.453736a0@posting.google.com>

Hallo,

the begin of the problem is, i will migrate the structure of a Sybase Adaptive Server Anywhere Database into ORACLE 8i(8.1.7)Personal Edition. On the Sybase DB exist 2 users. This users a contained all tables. One of that are calling "DBA". That user was my first problem on 8i. I must delete the role "DBA" to craete a user "DBA". Is it a problem, when the role "DBA" not exist?

After that, i can create all tables with little adaptations on the column names and datatypes. When i will create a references from the schema "DBA" to another called "Heiko", i become the 'ORA-01031 - insufficient privileges' Error Message. The User "DBA" and "Heiko" have all system privileges.

What is my problem? Who can help me?
Thanks.
Mathias Received on Mon Dec 09 2002 - 09:04:19 CST