SEO

#1 (**permalink**) 02-24-2008, 10:01 AM

SVRMGR> select version from v$instance;
VERSION
-----------------
8.1.7.2.0
1 row selected.
SVRMGR> desc dba_registry;
MGR-00360: object to be described does not exist
SVRMGR>

Am i missing some things?

#2 (**permalink**) 02-24-2008, 10:01 AM

Check the Oracle 8.1.7 Reference manual . I believe that dba_registry
was new with Oracle 9.

You can get Oracle version information from the view:
product_component_version, which provides the same information a
v$version but in a formatted manner: product, version, status.
HTH -- Mark D Powell --

#3 (**permalink**) 02-24-2008, 10:01 AM

On 3 Jan 2005 01:16:20 -0800, yls177@hotmail.com (yls177) wrote:

>SVRMGR> select version from v$instance;
>VERSION
>-----------------
>8.1.7.2.0
>1 row selected.
>SVRMGR> desc dba_registry;
>MGR-00360: object to be described does not exist
>SVRMGR>
>
>
>Am i missing some things?

You didn't upgrade to a supported version with this new feature, also
you didn't run select * from dict where table_name = 'DBA_REGISTRY' to
check whether the view acutally exists.

--
Sybrand Bakker, Senior Oracle DBA

#4 (**permalink**) 02-24-2008, 10:08 AM

spot on. Thanks DBAs

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode