How do I create object in other schemas?

From: Raymond Everly <reverly_at_ucs01.cfr.usf.edu>
Date: 22 Nov 1994 23:24:09 GMT
Message-ID: <3atuip$r2h_at_mother.usf.edu>


I am creating tables in other schemas with primary keys. The table appears in the other schema but the index ends up in my schema. Yet when I try to supply what I think would be a fully qualified "uid.keyname" I get a sysntax error.

 Any way to get around this without logging into the other schema?

Any way to specify a different tablespace for the key and the table? Received on Wed Nov 23 1994 - 00:24:09 CET

Original text of this message