Solaris/8.1.7/LOBSEGMENT

2003-03-31 Thread Vergara, Michael (TEM) 
Hi all!

I'm getting a report that a LOBSEGMENT has reached MAXEXTENTS.
How do I modify this?  ALTER LOBSEGMENT doesn't work.  I'm still
R'ing the FMs, but I thought I'd ask the list too.

Thanks,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: Solaris/8.1.7/LOBSEGMENT

2003-03-31 Thread Vergara, Michael (TEM) 
Title: RE: Solaris/8.1.7/LOBSEGMENT



Thanks! I found a note on MetaLink, and got your message 
at
about the same time. I figured it out, and applied the 

change.

Cheers,
Mike

  -Original Message-From: Jacques Kilchoer 
  [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 
  10:25 AMTo: '[EMAIL PROTECTED]'Cc: Vergara, Michael 
  (TEM)Subject: RE: Solaris/8.1.7/LOBSEGMENT
   -Original Message-  
  From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] 
I'm getting a report that a 
  LOBSEGMENT has reached MAXEXTENTS.  How do I 
  modify this? ALTER LOBSEGMENT doesn't work. I'm still 
   R'ing the FMs, but I thought I'd ask the list 
  too. 
  alter table owner.table_name modify lob (lob_name) (storage 
  (maxextents N)) ;

Re: Solaris/8.1.7/LOBSEGMENT

2003-03-31 Thread Robert Pegram 
alter table table_name
modify lob (lob_column) 
 (storage (maxextents unlimited)); 


Look in dba_lobs if you are unsure of the table_name
the lobsegment belongs to.

Rob Pegram
Oracle Certified DBA

--- Vergara, Michael (TEM) [EMAIL PROTECTED]
wrote:
 Hi all!
 
 I'm getting a report that a LOBSEGMENT has reached
 MAXEXTENTS.
 How do I modify this?  ALTER LOBSEGMENT doesn't
 work.  I'm still
 R'ing the FMs, but I thought I'd ask the list too.
 
 Thanks,
 Mike
 
 ---

===
 Michael P. Vergara
 Oracle DBA
 Guidant Corporation
 
 -- 
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 -- 
 Author: Vergara, Michael (TEM)
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (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).
 


__
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robert Pegram
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).