Hi

I want list of features which were there in 7.2 and 8.x but are not
present in oracle 9.2

Thanks and Regards,
Umesh

umesh wrote:

> Hi
>
> I want list of features which were there in 7.2 and 8.x but are not
> present in oracle 9.2
>
> Thanks and Regards,
> Umesh

What makes you think any exist?

I understand you could argue that server manager went away with 9i.
But the feature is still there ... we just perform the function in
SQL*Plus rather than a different executable.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

umesh wrote:

>
> I want list of features which were there in 7.2 and 8.x but are not
> present in oracle 9.2
>

The only ones I can think of -

Oracle7 Backup Utility EBU
svrmgr (svrmgrl)
Context
Multi-dimension system
RBO

All have been replaced by (IMO) far superior mechanisms:

EBU replaced by RMAN in 8.x
svrmgrl replaced by SQLPLUS using AS SQLDBA
Context replaced by Intermedia Text (8.x) and Oracle Text (9.x)
MDS replaced by Intermedia Locator and Spatial
RBO replaced by CBO (in process in 8.x, 9,x) finally with 10g)


Then there is the plethora of '7.x can not do this' features that have
vanished with 8.x and 9.x. Examples include Relational Objects, Java, Bit
Map indexes, Partitioning, RAC, Analytics, etc.

Aside from that, each version of Oracle (since 8.0 at least) has a "New
Features" document that describes the most significant changes. The
documents are, of course, publically available at http://docs.oracle.com
Using that, I'm sure you could extract and publish a list.

/Hans

partition views?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/
"Hans Forbrich" <forbrich@yahoo.net> wrote in message
news:yC5oc.32778$LA4.5920@edtnps84...
> umesh wrote:
>
> >
> > I want list of features which were there in 7.2 and 8.x but are not
> > present in oracle 9.2
> >
>
> The only ones I can think of -
>
> Oracle7 Backup Utility EBU
> svrmgr (svrmgrl)
> Context
> Multi-dimension system
> RBO
>
> All have been replaced by (IMO) far superior mechanisms:
>
> EBU replaced by RMAN in 8.x
> svrmgrl replaced by SQLPLUS using AS SQLDBA
> Context replaced by Intermedia Text (8.x) and Oracle Text (9.x)
> MDS replaced by Intermedia Locator and Spatial
> RBO replaced by CBO (in process in 8.x, 9,x) finally with 10g)
>
>
> Then there is the plethora of '7.x can not do this' features that have
> vanished with 8.x and 9.x. Examples include Relational Objects, Java, Bit
> Map indexes, Partitioning, RAC, Analytics, etc.
>
> Aside from that, each version of Oracle (since 8.0 at least) has a "New
> Features" document that describes the most significant changes. The
> documents are, of course, publically available at http://docs.oracle.com
> Using that, I'm sure you could extract and publish a list.
>
> /Hans

Niall Litchfield wrote:

> partition views?
>

So much for my "I don't wanna use the docco" memory.

Hans Forbrich wrote:

> umesh wrote:
>
>
>>I want list of features which were there in 7.2 and 8.x but are not
>>present in oracle 9.2
>>
>
>
> The only ones I can think of -
>
> Oracle7 Backup Utility EBU
> svrmgr (svrmgrl)
> Context
> Multi-dimension system
> RBO
>
> All have been replaced by (IMO) far superior mechanisms:
>
> EBU replaced by RMAN in 8.x
> svrmgrl replaced by SQLPLUS using AS SQLDBA
> Context replaced by Intermedia Text (8.x) and Oracle Text (9.x)
> MDS replaced by Intermedia Locator and Spatial
> RBO replaced by CBO (in process in 8.x, 9,x) finally with 10g)
>
>
> Then there is the plethora of '7.x can not do this' features that have
> vanished with 8.x and 9.x. Examples include Relational Objects, Java, Bit
> Map indexes, Partitioning, RAC, Analytics, etc.
>
> Aside from that, each version of Oracle (since 8.0 at least) has a "New
> Features" document that describes the most significant changes. The
> documents are, of course, publically available at http://docs.oracle.com
> Using that, I'm sure you could extract and publish a list.
>
> /Hans

Not that it's important, but I think you'll find that bitmap indexes
were there in 7.3.

The 9i bitmap JOIN index, however, was entirely new, absolutely
brilliant, and a godsend to data warehouses for which we should all be
grateful.

Regards
HJR

Howard J. Rogers wrote:

> Not that it's important, but I think you'll find that bitmap indexes
> were there in 7.3.
>

IIRC not in 7.2 (which is the basis of discussion). However, I do stand
corrected - thanks.

/Hans

umesh_adi@yahoo.com (umesh) wrote in message news:<61faee1c.0405102144.2f87ceb1@posting.google. com>...
> Hi
>
> I want list of features which were there in 7.2 and 8.x but are not
> present in oracle 9.2
>
> Thanks and Regards,
> Umesh

http://download-west.oracle.com/docs...pa.htm#1010632

I want Heather Locklear.

jg
--
@home.com is bogus. "It's one of the hardest jobs in the world to
keep a place both open and the author of two books on computer
security. " - Print version of
http://www.signonsandiego.com/uniont...7m7breach.html

Joel Garry wrote:


> http://download-west.oracle.com/docs...pa.htm#1010632

Curious, this one:

"The Oracle9i installation includes the following two scripts for
creating a table that stores exceptions from enabling constraints:
utlexcpt.sql and utlexpt1.sql. The utlexpt1.sql script can be run on
index-organized tables as well as regular tables, while the utlexcpt.sql
script can be run only on regular tables, but not on index-organized tables.

In Oracle9i, you must always run the utlexpt1.sql script."

I wish they'd have clarified what they meant by that last sentence,
because it isn't true as it stands (well, I've never had a problem with
just plain old utlexcpt.sql in 9i). Obviously, if you want to do it for
an IOT, you need the UROWID which utlexpt1.sql gives you, but for heap
tables, I find the old script works just fine.

So whatever can they have meant by saying "you MUST always run...."?

Or have I missed something?

Regards
HJR

Hans Forbrich wrote:

> umesh wrote:
>
>
>>I want list of features which were there in 7.2 and 8.x but are not
>>present in oracle 9.2
>>
>
>
> The only ones I can think of -
>
> Oracle7 Backup Utility EBU
> svrmgr (svrmgrl)
> Context
> Multi-dimension system
> RBO
>
> All have been replaced by (IMO) far superior mechanisms:
>
> EBU replaced by RMAN in 8.x
> svrmgrl replaced by SQLPLUS using AS SQLDBA
> Context replaced by Intermedia Text (8.x) and Oracle Text (9.x)
> MDS replaced by Intermedia Locator and Spatial
> RBO replaced by CBO (in process in 8.x, 9,x) finally with 10g)
>
>
> Then there is the plethora of '7.x can not do this' features that have
> vanished with 8.x and 9.x. Examples include Relational Objects, Java, Bit
> Map indexes, Partitioning, RAC, Analytics, etc.
>
> Aside from that, each version of Oracle (since 8.0 at least) has a "New
> Features" document that describes the most significant changes. The
> documents are, of course, publically available at http://docs.oracle.com
> Using that, I'm sure you could extract and publish a list.
>
> /Hans

Context still exists ... they just changed the name a few times.
And the RBO does too.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)