Foreign Key to table in other schema?

Hi there,

I've checked the docs, but the only limitation I can find about FKs is related to clustering.

From the SQL Syntax doc, I figured the below should be possible:

alter table scott.child
add constraint fk_child_child
foreign key (parentid) references northwind.parent (id)

I was logged in with "system" and I can select from "northwind.parent", but the statement above kept on returning: ORA-00942: table or view does not exist

Is this possible, or isn't it?

-- 
With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com