RE: number of Mb to add?

Also, expanding the available space on a datafile to handle only the next extent is just not being a proactive DBA. Give it enought room to expand. Also don't forget that the datafile it self can be expanded in size (7.3 and above) up to the available space on the volume or the file size limit of the OS. Unless you have to, you don't have to make another datafile.

>>> lkoivu_at_qode.com 03/12/01 12:20PM >>>
Joseph,

Well, do you really want to deal with a datafile that small, whether that's KB or bytes? What about when it extends beyond that extent? Usually datafiles less than 100MB are not worth the hassle, and the size should be much larger in a production database. Of course, this is just my opinion...

HTH Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

-----Original Message-----
Sent: Monday, March 12, 2001 11:20 AM
To: Multiple recipients of list ORACLE-L

if I get this message,

IMP-00058: ORACLE error 1654 encountered ORA-01654: unable to extend index TOTSAPPL.PK_DAILY_OPERATOR_ACTIVITIES by 15006 in tablespace USERS

the 15006, is it bytes or rows or what? I just want to know how many bytes to enter
as the size of the new ADDFILE.

TIA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Leyden, Joseph
  INET: LeydenJ_at_MTA.NET 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).