Home » Infrastructure » Windows » Issue with Oracle 7.3 !
Issue with Oracle 7.3 ! [message #99521] Sun, 23 December 2001 19:22 Go to next message
Karthik
Messages: 63
Registered: February 2000
Member
I have a customer who is still using Oracle 7.3. One of the tables called TOTAL has the setting of using maxextents 255. I think so in Oracle 7.3, more than 255 extents cannot be used. My application will prompt an error if the extents go more than 255. Already it has reached 250. How to tackle this?

In case, I have to rebuild the table, how do I do that? The table is huge with a size of 76MB and has 5 indexes. What procedure do I use for rebuilding the table.

Thanks in advance and your inputs are highly appreciated.

Warm regards
Karthik

----------------------------------------------------------------------
Re: Issue with Oracle 7.3 ! [message #99570 is a reply to message #99521] Mon, 14 January 2002 12:54 Go to previous message
Willem
Messages: 2
Registered: January 2002
Junior Member
Oracle 7.3 does NOT have a limitation on the number of extents that can be allocated to a segment like it war on pre 7.3 releases. In fact, UNLIMITED was introduced in this release. So, you don't have to rebuild your table because of this. If however you wish to rebuild, you can do two (or more) things:

1. Upgrade to Oracle 9.0.1 (9i) or higher, because there it can be done using a DBMS (Oracle) package;
2. Export/import via any of a couple of methods to recreate the table, it's indexes and object privileges.
Previous Topic: Re: Can I install 7.3.4 on Windows 2000?
Next Topic: Re: HELP: Unable to install personal oracle 8.0 on windows 2k server
Goto Forum:
  


Current Time: Sat Mar 02 00:59:00 CST 2024