9i R2

boss

I went to oracle.com and went in to download section and saw that 9i database software download.
But i want to know where did u find R2 version in the web site. i was searching for word R2 but could not get it.

so where is that latest R2 version lying in the web site

pravin

PRAVIN: Click on the early adopter program link on the right hand side of the frontpage.

JULIAN: Yes, you can have a locally managed SYSTEM tablespace in Rel2. Actually, the default installation now creates it as local.

Quote:

---

Originally posted by KenEwald
I heard at OpenWorld that R2 has alot of XPATH enhancements.

downloading now..

---

There's a whole new section called XML Database. It's shown as a separate node in enterprise manager. I'm going to start having a play with it today if I get time.

Quote:

---

Originally posted by TimHall
JULIAN: Yes, you can have a locally managed SYSTEM tablespace in Rel2. Actually, the default installation now creates it as local.

---

Did you notice that you can rename columns and constraints in 9.2.0.1.0?

Yeah! Nice.....

I think I've found my first bug on Rel2.

The XDK packages, although loaded under SYS have been replaced with DBMS_% equivalents in the XDB schema. I'm assuming these new packages are part of the kernel rather than Java since they don't have the associated first-load lag you see when you use the XDK equivalents.

Anyway, I'm trying to update an example I used for 8i to use the DBMS_% packages. In doing so I've noticed that the dbms_xslprocessor.getValue procedure never seems to return a value.

I've logged a TAR on metalink and I'm waiting for the reply.

Cheers

Hi Tim

Could you kindly post the new features of oracle9i R2 on your website.Its really great for me to know that the system tablespace si loaclly manged.columns can be renamed contraints can be renamed etc.but i would prefer short guide of new feautres ....i wont be able to download because of lack of bandwidth will be depending on you....

regards
Hrishy

I'll be doing a few new features articles over the next few days/weeks. Oracle has a PDF document available that gives a brief description of the changes:

http://www.oracle-base.com/Links/db_r2features.pdf

It's about 45K so it's not too bad.

Cheers

Quote:

---

Originally posted by TimHall
Yes, you can have a locally managed SYSTEM tablespace in Rel2. Actually, the default installation now creates it as local.

---

Tim,

is it better now to create all the tablespace locally managed. not a single dictionary managed.

what is your opinion

Oracle are planning on deprecating Dictionary Managed tablespaces in a future version. With this in mind it's a good idea to get used to Locally Managed tablespaces, including SYSTEM, now.

You should also consider using "Automatic Segment Free Space Management". In the default 9i Rel2 installation all tablespaces except SYSTEM, TEMPTBS1 and UNDO use this feature. I'm sure this will become compulsory in versions to come:

http://www.oracle-base.com/Articles/...Management.asp

Cheers