Re: Synonyms and table partitions

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 20 Jan 2000 23:55:08 -0000
Message-ID: <948412709.14833.0.nnrp-11.9e984b29@news.demon.co.uk>

No, but what you can do is create a view which names one partition, and create a synonym for the view.

create or replace view big_table_199912 as select * from big_table partition(p199912);

create public synonym big_table_199912 for big_table_199912;

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Kurt Johnson wrote in message ...
>Greetings:
>
>Is it possible to have a synonym on a table partition?
>
>Oracle 8.0.5.0.0
>
>T I A,
>
>Kurt
>
>
Received on Thu Jan 20 2000 - 17:55:08 CST