Re: Is there a wildcard for synonyms?

Maybe you could do something like this:

ALTER SESSION SET CURRENT_SCHEMA = NAME_OF_SCHEMA; Or create public synonyms like this

SELECT 'CREATE PUBLIC SYNONYM '||table_name||' FOR '||OWNER||'.'||table_name||';' FROM dba_tables
where owner = 'OWNER_NAME';

mehaase_at_gmail.com wrote:
> 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 - 22:04:02 CDT