Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is there a wildcard for synonyms?
I have a schema for development which is shared with several other
people. I'm writing some code which reads a bunch (maybe 30-40) of the
tables and uses other things like types, sequences, stored procedures,
etc. I'd like to be able to run this code in a private schema...so I
need to create synonyms to all the objects...but there's several
hundred of them. Is there some kind of wildcard schema that just says
"look first in my schema and if you don't find the object there then
look in this other schema?"
Then...I will be inserting/updating to a handful of tables (6-7). I'd like not to alter the development schema's tables at all, so I'm planning to make private copies, as in
CREATE TABLE test AS SELECT * FROM DEV_SCHEMA.test;
etc...
But this won't capture any constraints on the table, will it? Is there a way to copy a table such that you keep all of the contraints, indices, etc.? Received on Thu Jun 01 2006 - 21:25:45 CDT