Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> OEM on UNIX

OEM on UNIX

From: Cyril Thankappan <cyril_thank_at_rediffmail.com>
Date: 7 Jan 2001 18:42:32 -0000
Message-Id: <10734.125941@fatcity.com> 





Hi!



Can anyone here help me with OEM on Unix platforms please?



Thanks






  Could be worse...they could decide that they should use CHAR instead of
VARCHAR under the pretense of eliminating potential fragmentation problems.
:)  (and I have seen this in a vendor database...rough calculations said it
would have required 1/7th the amount of disk space if they would have used
varchars and allowed nulls)



:)



Jeffery Stevenson


Chief Databeast Tamer


Medical Present Value, Inc.


Austin, TX



-----Original Message-----


Sent: Friday, January 05, 2001 12:37 PM


To: Multiple recipients of list ORACLE-L




What a waste of disk space!  Storing spaces instead of leaving a column
null?  Sounds like storing a bunch of useless garbage to me. 




-----Original Message----- 


Sent: Friday, January 05, 2001 1:21 PM 


To: Multiple recipients of list ORACLE-L 




Hi all, 


We have an outside vendor developing an application, which we will
ultimately inherit for maintenance.  They are porting this application from
a different database platform to Oracle, since we are an Oracle shop.  They
have decided to make every column in every table a NOT NULL column.  They
want to implement default values at the database level for every column ('
', 0 and some low date for varchar2, number and date) and then let the
application validate and enforce significant data as required.  I am looking
for opinions on the pros and cons of this type of approach, both from a
database and application point of view. 
Thanks, 


Siv 




-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.com 


-- 



Author: Siv Chelakkara 


  INET: Siv.Chelakkara_at_3cc.co.wayne.mi.us 

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: Jeffery Stevenson


  INET: jeff_at_mpv.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).





Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com











 From: "Rivera, Claudia" <crivera_at_utep.edu>
 Date: Sun, 7 Jan 2001 12:05:48 -0700 


 Subject: please help to display image



I am storing images as BLOBs.


But I would like to display them in a web page.



Does anyone have the sql and perl code on how to retrieve the image from the
database and display it????



Please..... I would take the time to figure out how to do it, but the
problem is I am running out of time!!! :(


--------------Claudia Rivera-----------------


DMC, Tech. Media Coordinator


crivera_at_utep.edu


http://dmc.utep.edu









 From: jared still <jkstill_at_teleport.com>
 Date: Sun, 7 Jan 2001 11:01:57 -0800 (PST)
 Subject: Re: Recovery Problem in Ora 7.3.4.0.1 on SunOS 5.6



Vivek,



I have no experience with this problem, but the nature
of it strongly suggests that you should open a TAR
with OWS and send them the core file.



Jared



On Sun, 7 Jan 2001, VIVEK_SHARMA wrote:


> 
> CASE Recovery Problem in Ora 7.3.4.0.1 on SunOS 5.6
> 
> Upon Rolling Foward using the Command :-
> SVRMGR> STARTUP MOUNT; 
> SVRMGR> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
> 
> After Successful application of about 15 Archived redo logfiles 
> , upon reaching a PARTICULAR Archived File No. (bby01_35416.dbf) 
> Cursor Exiting Silently to Unix $ Prompt WITHOUT Giving any Message 
> core dumped in the $CORE_DUMP_DESTINATION Dir 
> 



------------------------------





 From: "Rachel Carmichael" <carmichr_at_hotmail.com>
 Date: Sun, 07 Jan 2001 22:22:54 -0000


 Subject: Re: Recovery Problem in Ora 7.3.4.0.1 on SunOS 5.6



sounds awfully like a corrupted archived log...... and yes, call Support!


>From: jared still <jkstill_at_teleport.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Recovery Problem in Ora 7.3.4.0.1 on SunOS 5.6
>Date: Sun, 07 Jan 2001 11:05:43 -0800
>
>Vivek,
>
>I have no experience with this problem, but the nature
>of it strongly suggests that you should open a TAR
>with OWS and send them the core file.
>
>Jared
>
>On Sun, 7 Jan 2001, VIVEK_SHARMA wrote:
>
> >
> > CASE Recovery Problem in Ora 7.3.4.0.1 on SunOS 5.6
> >
> > Upon Rolling Foward using the Command :-
> > SVRMGR> STARTUP MOUNT;
> > SVRMGR> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
> >
> > After Successful application of about 15 Archived redo logfiles
> > , upon reaching a PARTICULAR Archived File No. (bby01_35416.dbf)
> > Cursor Exiting Silently to Unix $ Prompt WITHOUT Giving any Message
> > core dumped in the $CORE_DUMP_DESTINATION Dir
> >
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: jared still
>   INET: jkstill_at_teleport.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).

_________________________________________________________________


Get your FREE download of MSN Explorer at http://explorer.msn.com








 From: "aaaa wwwwww" <krisibm_at_lycos.com>
 Date: Sun, 07 Jan 2001 17:18:49 -0800


 Subject: Re: Recovery Problem in Ora 7.3.4.0.1 on SunOS 5.6



Dear Vivek



U type yourself archived files one by one



Then it takes



It thinks that there is no more files left



Rao

--

On Sun, 07 Jan 2001 11:05:43  
 jared still wrote:
>Vivek,
>
>I have no experience with this problem, but the nature
>of it strongly suggests that you should open a TAR
>with OWS and send them the core file.
>
>Jared
>
>On Sun, 7 Jan 2001, VIVEK_SHARMA wrote:
>
>> 
>> CASE Recovery Problem in Ora 7.3.4.0.1 on SunOS 5.6
>> 
>> Upon Rolling Foward using the Command :-
>> SVRMGR> STARTUP MOUNT; 
>> SVRMGR> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
>> 
>> After Successful application of about 15 Archived redo logfiles 
>> , upon reaching a PARTICULAR Archived File No. (bby01_35416.dbf) 
>> Cursor Exiting Silently to Unix $ Prompt WITHOUT Giving any Message 
>> core dumped in the $CORE_DUMP_DESTINATION Dir 
>> 
>
>-- 
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>-- 
>Author: jared still
>  INET: jkstill_at_teleport.com
>


Received on Sun Jan 07 2001 - 12:42:32 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US