If you look at the view definitions you will find that they *are* different,
specifically they all include a column INST_ID. Having a think about what
this column could be will give you the clue as to the difference.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Dino Hsu" <dino1.nospam_at_ms1.hinet.net> wrote in message
news:ntqpotk581r2pna33a9qlbefva1hb87llf_at_4ax.com...
> Dear all,
>
> There are many dynamic views which starts both with GV$ and V$ and
> look the same. The books only mention those with V$, why are there
> also GV$? Thanks in advance.
>
> Dino
>
Received on Wed Aug 29 2001 - 08:38:28 CDT
