Re: Foreign key references a table in an other schema of the database

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Sat, 10 Jan 2004 00:56:32 +1100
Message-ID: <3ffeb4ae$1$26119$afc38c87@news.optusnet.com.au>

Does any1 know if this changed in 10g?

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:rvudnUxcS9ixxGCiRVn-gQ_at_comcast.com...




> this privilege must be granted directly to the schema that will create the

> FK reference (as shown) -- it cannot be granted to a ROLE (ORA-01919),

> except for the PUBLIC role

Received on Fri Jan 09 2004 - 07:56:32 CST

This message: [ Message body ]
Next message: jim: "delete child table rows based on parent table predicates"
Previous message: Noons: "Re: Professional or Not (was Database Design)"
In reply to: Mark C. Stock: "Re: Foreign key references a table in an other schema of the database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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