Re: views/sequences

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 15 Apr 2003 11:01:28 -0700
Message-ID: <2687bb95.0304151001.13d9a6f5@posting.google.com>

"Michael L. Hostbaek" <carlos_at_pez.dk> wrote in message news:<slrnb9o2eg.1sk5.carlos_at_freebsdcluster.dk>...
> I have successfully inserted all data and table structures from one
> oracle server to another (thorugh db link)
>
> I can see my data on the new server, however how can I see if views and
> sequences are also on the new server ? Is it possible to select all
> views and sequences on the old server ? If so, how ?
>
> Thanks

Select from the Oracle dictionary views on both databases and look to see if your objects are there. You should be able to use the same link you used to copy the data to query the all_ versions of the dictionary views.

HTH -- Mark D Powell -- Received on Tue Apr 15 2003 - 13:01:28 CDT