| Issue with Oracle 7.3 ! [message #99521] |
Sun, 23 December 2001 19:22  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
