Thanks Richard. I don't think creating views will
occupy extra space as views are just windows to the
tables. Correct? But what will happen to the
indexes??? They will still by owned by PRODCTL &
PRODDTA.

OK.. How about this? What if I keep all tables &
indexes in prodctl schema but give all DML privileges
to testctl? Will it let testctl schema to
access,change?? It will not let testctl schema to
alter prodctl tables or create indexes....

--- Richard Quintin <[Email Address Removed] wrote:
> Could you use views from test schema to prod schema?
>
> begin
> for x in (select table_name from dba_tables where
> owner = 'PRODCTL') loop
> execute immediate 'create view
> '||x.table_name||' as select * from
> prodctl.'||x.table_name;
> end loop;
> end;
>
> Richard Quintin
> VTLS, Inc.
> http://www.vtls.com/

=====
Ashish Saxena
Oracle DBA

__________________________________________________
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
Oracle LazyDBA home page