Re: 10g

Correct. You can follow his announcement on www.Oracle.com at 2PM PDT. Babette Turner-Underwood wrote: Yes, but then all the listers who have been DYING to fill us in, will be allowed to finally spill their guts, no? - Babette -Original Message- Mogens Norgaard Sent: Monday, September

RE: Re: Oracle Masters exam

So, what was your reason for taking the OCM exam Tanel? Mark -Original Message- Tanel Poder Sent: 08 September 2003 22:10 To: Multiple recipients of list ORACLE-L About 50 I believe. But there are probably more DBAs in the world who don't give a damn about this (or any other)

RE: EM To Go

Apart from when you are on the move (to/from work), or sat at home in the evening, or at the pub, or shopping, or sat in Hooters.. How about when you're lay in bed on a Sunday morning (we've had customers fix problems in exactly this situation!)? Monitors are great - we sell one! - and IMHO

Re: Database Link

Hamid, Did you create the database link from the 9i database to the 8i database? One database does not know about the other database links. Ron [EMAIL PROTECTED] 09/08/03 05:39PM Dear List, I have two database one on 8.1.7.4 on sun Solaris 8.2 and another one on oracle 9.0.1(two separate box)

ORA-03113 on using create_stored_outlines

Hello list I need your help with a problem I am having whenever I start using outlines. I am using Oracle 9.2.0.1.0 enterprise edition on windows . Suppose two users scott and hr have select any table, create any outline privileges and select_catalog_role. SQL conn scott/[EMAIL PROTECTED]

Resynchronizing the stored outline definition

Hello list , I am using Oracle 9.2.0.1.0 Enterprise edition on windows. I get an error while trying to resynchronze a private outline after I have edited it. I get this error when I use the identity statement SQL create private outline test from private test ; create private outline test from

Re: alter system reset

You are correct arup The parameter originally existed as *.parameter=value After running alter system set parameter=value sid='lahiri' ; it now exists as lahiri.parameter=value So either I specify the sid name while setting the parameters or I should use the following to reset the parameters

RE: Resynchronizing the stored outline definition

Hello list , I am using Oracle 9.2.0.1.0 Enterprise edition on windows. I get an error while trying to resynchronze a private outline after I have edited it. I get this error when I use the identity statement SQL create private outline test from private test ; create private outline test

RE: EM To Go

Mark Leith scribbled on the wall in glitter crayon: land line constantly whilst you are on call.. DBAs have lives too.. ;) OK, how come nobody ever told me i was allowed to have a life? and where the web site to order one?;-) -- Bill Shrek Thater ORACLE DBA BAARF Party member #25

Oracle and Perl

Can anyone tell me how to pick up the $ORACLE_SID or $ORACLE_HOME from within a Perl script? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

OT: Oracle 9iOAS install help needed

Hi All, I am trying to install Oracle 9iAS on Win 2000 I installed Infra structure successfully. While trying to install next component OAS with BI/Forms I get a message Existing Oracle9iOAS Single Sign-On. Enter hostname and port number of existing Single Sign-On. Heck I do not know if it

Re: Weird ORA-00060 (deadlock) with pragma autonomous

What version are you on??? There is a bug in 9.2.0.3, I was getting this error regularly on my rman repository db when an rman resync was run. I've patched to 9.2.0.4 and the error has gone away. ...JIM... [EMAIL PROTECTED] 9/8/03 11:09:27 PM We are getting a strange deadlock problem and I am

How to send an email from unix command line?

Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? Thanks in advance Sami __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use

AW: Oracle and Perl

Hi, Ron my $ORA_SID = $ENV{'ORACLE_SID'} my ORAC_HOME = $ENV{'ORACLE_HOME'} should siffice ;) HTH. Milen -Ursprüngliche Nachricht- Von: Smith, Ron L. [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 9. September 2003 15:39 An: Multiple recipients of list ORACLE-L Betreff: Oracle and

RE: question on spfile and pfile

Title: RE: question on spfile and pfile Create pfile='/path/initSID.ora' from Spfile='/path/spfileSID.ora'; Change initSID.ora Delete old spfile Create spfile='/path/spfileSID.ora' from Pfile='/path/initSID.ora'; All Done Scott Stefick MILPDS OCP Oracle DBA [EMAIL PROTECTED]

RE: Oracle and Perl

$ENV{ORACLE_HOME}, $ENV{ORACLE_SID} -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Ron L. Sent: Tuesday, September 09, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Subject: Oracle and Perl Can

RE: Oracle 9iOAS install help needed

There is a ports.ini file somewhere in the infra and middle Oracle homes, they would tell you what port to use. Patrice. -Original Message- Sent: Tuesday, September 09, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi All, I am trying to install Oracle 9iAS on Win 2000 I

RE: How to send an email from unix command line?

is sendmail running? $HOST:/ps -ef | grep mail root 250 1 0 Aug 24 ?0:00 /usr/lib/sendmail -bd -q15m root 2358 2295 0 08:18:42 pts/10:00 grep mail man mail or pester your admin if all else fails. For example we disable sendmail unless it's required. ~brian

RE: How to send an email from unix command line?

Have you tried mailx? That's what we use here. Scott Canaan ([EMAIL PROTECTED]) -Original Message- Sent: Tuesday, September 09, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL

RE: 10g

Sweet! Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.' sarcasmNo more SQL tuning! No more STATSPACK! No more

Documents in or outside the database.

Hi listers, We are working on a project that will have documents as attachments. The developers want to store the documents outside the database on the application server. I want to store the documents inside the database for recovery purposes. Is there a white paper or document that has

RE: 10g

You're up to 3 wishes and then it will crash ... I wonder if you have to rub the server or the disk box to get the genie ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED]

Re: offshoring article

Let's see if I have this straight, the US is nearly a half trillion dollars in debt. It is going to add at least another 87 billion to that number. It has just reduced taxes on its citizens. And, now it is good for the country to send its best paying jobs overseas. Looks to me like the US is

RE: How to send an email from unix command line?

Is it not echo message body 1 | mailx -s Test Subject [EMAIL PROTECTED] Fraser Talbot M-I LLC Database Administrator Information Technology 832.295.2245 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Hi List I

RE: 10g

Well... We've tried the Oracle Expert on 8i... Hopefully it works better in the newer versions. I also noticed that in 9i they dropped intelligent from the name Oracle Intelligent Agent. You always need someone to take responsibility for administering the databases. Patrice. -Original

Jobs and OEM... how to

Hi to everybody!! I would like to create a job that EXPort my database, but... I *do not* want to use OEM. OEM uses tcl and the intelligent agent to schedule its jobs... how can I create a job that can export my database? (no problem if I have to program with tcl files) Any ideas? any sample

Re: How to send an email from unix command line?

mailx -s Test Subject [EMAIL PROTECTED] __EOF__ body line1 body line2 __EOF__ ..I couldn't find mailx on Linux, so use mail there... on 9/9/03 7:59 AM, Talbot, Fraser at [EMAIL PROTECTED] wrote: Is it not echo message body 1 | mailx -s Test Subject [EMAIL PROTECTED] Fraser Talbot M-I

RE: How to send an email from unix command line?

Try something like tar cf - /|uuencode my_system.tar|mailx -s This is my system, don't you like it? [EMAIL PROTECTED] That command would attach the complete backup of your system to the email message. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED]

RE: Jobs and OEM... how to

Title: RE: Jobs and OEM... how to Perl and cron. -Original Message- From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 09, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Subject: Jobs and OEM... how to Hi to everybody!! I would like to create

RE: How to send an email from unix command line?

Brian, Thanks for your response. snedmail is running. $ ps -ef|grep -i mail root 621 1 0 Aug 25 ?0:00 /usr/lib/sendmail -bd -q15m oracle 29802 28321 0 10:11:34 pts/60:00 grep -i mail --- Brian Dunbar [EMAIL PROTECTED] wrote: is sendmail running? $HOST:/ps -ef |

RE: 10g

No, you get 3 wishes from the genie, after that you have to buy a licence for geniEE. Come to think of it, maybe the g in Oracle 10g stands for genie rather than grid? At 06:59 AM 9/9/2003 -0800, you wrote: You're up to 3 wishes and then it will crash ... I wonder if you have to rub the

RE: Jobs and OEM... how to

Hi Stefick... thanks for your input... well, I was thinking about dbms_job, may be I was not so clear... thanks again. Regards JL --- Stefick Ronald S Contr ESC/HRIDD [EMAIL PROTECTED] wrote: Perl and cron. -Original Message- Sent: Tuesday, September 09, 2003 10:04 AM To:

RE: Oracle 9iOAS install help needed

Thanks for the reply. I already verified the correct port but no go. Thanks Rick Boivin, Patrice

Re: RE: 10g

there are some semi-technical articles on otn about 10g. Im less than impressed with the pl/sql enhancements. anyone look at the HTML DB stuff? is that considerably better than the htp package or pl/sql server pages? From: Wolfgang Breitling [EMAIL PROTECTED] Date: 2003/09/09 Tue AM

RE: Jobs and OEM... how to

How about a shell script, scheduled with AT or CRON? -Original Message- Sent: Tuesday, September 09, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Hi to everybody!! I would like to create a job that EXPort my database, but... I *do not* want to use OEM. OEM uses tcl and the

Re: Resynchronizing the stored outline definition

Perhaps some RTFM is in order here. A studios examination of the fine docs might suggest 'create or replace'. Jared On Tue, 2003-09-09 at 05:59, [EMAIL PROTECTED] wrote: Hello list , I am using Oracle 9.2.0.1.0 Enterprise edition on windows. I get an error while trying to resynchronze a

Re: Database Link

The error message should be a definite clue. If you're not familiar with the 'oerr' utility, now is the time to try it out. On either of your servers, type this command from the system command prompt: oerr ora 12154 The info provided there should make it clear that some modification are

Privileges associated with Role

Hi List How to look for all the privileges associated with particular Role(for example R1)? Alos does anyone have a query to identify ALL(either directly or thru role) the privileges granted on particular tables TIA Sami __ Do you Yahoo!? Yahoo! SiteBuilder -

RE: How to send an email from unix command line?

Mladen Gogala scribbled on the wall in glitter crayon: Try something like tar cf - /|uuencode my_system.tar|mailx -s This is my system, don't you like it? [EMAIL PROTECTED] That command would attach the complete backup of your system to the email message. you, sir, are evil. i admire

RE: Jobs and OEM... how to

Since DBMS_JOB executes PL/SQL code (and that's what you want to use), you'll have to write an external stored procedure, which calls Export, wrap it in PL/SQL procedure, and call it from DBMS_JOB. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Jose Luis Delgado Sent:

RE: Oracle 9iOAS install help needed

I installed our Oracle 9iAS on Win 2000 following Oracle 9iAS Release 2 (9.0.2.0.1) Windows Installation Cookboook (Note: 21469.1). It's been a few months so I don't recall exactly how it went. The document does mention to verify the SSO Login by going to http://hostname.domain:port/pls/orasso,

Re: 10g

Oracle's Kumar likens ADDM to 'a genie in your database-if you have a performance problem, you just ask the database what the problem is and it automatically analyzes the complete database system and comes up with recommendations.' If this works like Oracle Expert, then it's recommendations

ORA-01403 error, help!!!

If logged in SQL Plus the following SQL returns just one row: SELECT t$orno FROM ttdsls805501 WHERE t$user = 'exped9' GROUP BY t$orno; If I do use the same SELECT statement inside a stored procedure and have the returning value stored in a local variable:

RE: Oracle and Perl

Worked Great! Thanks! Ron -Original Message- Sent: Tuesday, September 09, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Hi, Ron my $ORA_SID = $ENV{'ORACLE_SID'} my ORAC_HOME = $ENV{'ORACLE_HOME'} should siffice ;) HTH. Milen -Ursprüngliche Nachricht- Von: Smith,

RE: ORA-01403 error, help!!!

bash-2.05a$ oerr ora 1403 01403, 0, no data found // *Cause: // *Action: Make up some data. Use your imagination -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fermin Bernaus Sent: Tuesday, September 09, 2003 1:09

RE: How to send an email from unix command line?

Thank you, thank you! I'm doing my best. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thater, William Sent: Tuesday, September 09, 2003 12:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to send an

RE: Privileges associated with Role

Select * from dba_sys_privs where grantee='R1'; Select * from dba_tab_privs where grantee='R1'; Select * from dba_tab_privs where owner='schema' and table_name='table_name'; -Original Message- Sent: Tuesday, September 09, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Hi List

chained/migrated rows

I am trying to redo my scripts to remove the chained rows on a table. I am running on AIX, oracle 9.2.0.4. The issue I am running into is not being able to issue DDL from inside a loop or remotely from unix. I want the script to be launched from cron, create cursor of all the non system

Re: Documents in or outside the database.

Compromise? BFILE? Unless we are actually trying to search the documents themselves, I store documents outside the database and store the pathname to the document location within the database itself. --- M.Godlewski [EMAIL PROTECTED] wrote: Hi listers, We are working on a project that will

RE: ORA-01403 error, help!!!

Fermin, Are you sure it is failing here? As Mladen said, 1403 is No Data Found. Do you have any other select statements in the Procedure? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 09, 2003 1:09 PM To: Multiple recipients of list ORACLE-L

RE: Privileges associated with Role

This was posted here a while ago. I modified it to work through a database link but if you leave the database link blank it will work on your current database. It gives you all the privs (sys, role, and tab) granted directly to the userid as well as all the privs granted to it via roles. --

Re: Can't query through a synonym, the solution

Nice on your part to share. Hi List Well, we figured it out. Here was the sequence of events T1 - init ora parameter dblink_encrypt_login set to true in the target database T2 - synonym created T3 - init ora parameter dblink_encrypt_login set to false in the target database The

Re: Privileges associated with Role

I should have read your question more closely. The grants script that I provided will also work with a role instead of a userid. To get all the privileges granted on a table select * from dba_tab_privs where table_name = 'TABLE_YOU'RE_INTERESTED_IN';

RE: Weird ORA-00060 (deadlock) with pragma autonomous transaction

Babette, Could you post the deadlock trace file please. Henry -Original Message- Babette Turner-Underwood Sent: Tuesday, September 09, 2003 12:09 AM To: Multiple recipients of list ORACLE-L We are getting a strange deadlock problem and I am having trouble understanding the cause and

Re: ORA-01403 error, help!!!

Fermin...: ORA-01403 means No data found... you should manage an EXCEPTION code in your procedure to catch this kind of error. HTH JL --- Fermin Bernaus [EMAIL PROTECTED] wrote: I get ORA-01403. I have no clue why I am getting this error, can you help please? Many thanks!

Re: 600-[25012] on delete of IOT table

Apologies for not replying immediately. Was tied up with something else. Searched again on metalink advanced option for quote 8.1.7.2 IOT [25012] /quote with MATCH all (AND(++)) option . Click on Doc ID: Note:165461.1 (ie) option 4 8.1.7.X Patch Sets - List of Bug Fixes by Problem Type Search

Re: Privileges associated with Role

dba_sys_privs role_sys_privs - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 21:44 Hi List How to look for all the privileges associated with particular Role(for example R1)? -- Please see the official ORACLE-L

Re: Resynchronizing the stored outline definition

Duh,oh Thanks But Jared , the problem was that the FM itself told me to type : CREATE PRIVATE OUTLINE p_ol1 FROM PRIVATE p_ol1; Ref : Oracle 9i Database Performance Tuning Guide and Reference a96533.pdf page 7-9 , Chapter 7 : Using Plan Stability to Preserve Execution Plans, Section : Example

Re: Privileges associated with Role

Hi I wrote script some time back that you use to find all privileges granted to a user or role, system, object and role. It does this hierarchically so that it shows privs granted to roles granted to roles etc. It is available from http://www.petefinnigan.com/tools.htm its the first script

overloading and = comparisons in SQL

I don't know what to think re. this. There is a view here that produces an error, I identified why -- in one AND clause a number(9) datatype column is being joined with a varchar2(50) datatype column. The developer of this code says that this used to run, there must be something wrong with the

Re: overloading and = comparisons in SQL

My intuition says: NO. Your intution loses. :) drop table a; drop table b; create table a as select object_id, object_name from dba_objects where rownum 11 / create table b as select to_char(object_id) object_id_char, object_name from a / alter table b modify(object_id_char

RE: overloading and = comparisons in SQL

You can have in a where clause a varchar2 column compared to a number column , if the varchar2 column only contains numeric then it will work. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187

Re: 10g

It's also called Graham in a Box internally in Development because Graham Wood put some effort into it. It's Statspack on steroids plus more, but it will of course still be as useless as Statspack wrt system-wide measurement data. It does contain the SQL stuff if you ask it to, and that's

Re: 10g

ADDM (pronouned Adam) is - as I wrote a minute ago - Statspack++ - for what it's worth. Of course you can't tell a damned thing about performance problems from system-data. Unless there's only one and the same user on the system in the observation internval. Active Session History (ASH),

Re: offshoring article

Makes sense. Peter Barnett wrote: Let's see if I have this straight, the US is nearly a half trillion dollars in debt. It is going to add at least another 87 billion to that number. It has just reduced taxes on its citizens. And, now it is good for the country to send its best paying jobs

Re: overloading and = comparisons in SQL

Hi! Which kind of error? And where does it occur? What's the view code? Oracle does an implicit datatype conversion (if possible) when comparing different datatypes. Try to add the conversion explicitly with to_number for example try then. Note that Oracle can't use indexes in joins for

RE: Antw: Database Link

Yes I also have one from 9 to 8 but still the same error??? -Original Message- [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 11:49 PM To: Multiple recipients of list ORACLE-L Hi Hamid, excuse me: AARRRGGHH! Ok, feeling better now. You can't use the db link this way. You

Re: overloading and = comparisons in SQL

It looks like it always converts a character column to a number (or date) before comparing, never the other way around: SQL create table a ( N1 number ); Table created. SQL create table b (c1 varchar2(50)); Table created. SQL insert into a values (1000); 1 row created. SQL insert into a

Re: Resynchronizing the stored outline definition

Yeah, well, not all FM's are created equal. It's very common to see 'CREATE OBJECT' in documentation, Oracle or otherwise. I usually use 'CREATE OR REPLACE OBJECT' on objects that allow it, but that's just my preference. As for the ORA-3113, sounds like a bug. The 3113 is a generic error.

Re: overloading and = comparisons in SQL

where can i find a list of sqltrace events? seems that 10053 and 10046 are well documented on hotsos. how many are there? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 5:39 PM Hi! Which kind of error? And where does

Re: How to send an email from unix command line?

cat filename|mailx -s subject mailid HTH GovindanK Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? Thanks in advance Sami

question about migrating to 9i

Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace

RE: question about migrating to 9i

Ryan If you (or whoever) is using dbca, I believe all this is configured automatically. But watch the block size. That is the only thing you can't change later. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September

RE: How to send an email from unix command line?

If you wanted to send as an attachment use 'elm' Madhu Reddy -Original Message- Sent: Tuesday, September 09, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body

Re: overloading and = comparisons in SQL

Boivin, Patrice J wrote: I don't know what to think re. this. There is a view here that produces an error, I identified why -- in one AND clause a number(9) datatype column is being joined with a varchar2(50) datatype column. The developer of this code says that this used to run, there

Re: overloading and = comparisons in SQL

Courtesy Julian Dyke ( http://www.juliandyke.com ): SET SERVEROUTPUT ON DECLARE err_msg VARCHAR2(120); BEGIN dbms_output.enable (100); FOR err_num IN 1..10999 LOOP err_msg := SQLERRM (-err_num); IF err_msg NOT LIKE '%Message

RE: question about migrating to 9i

Little tidbits I kind of like is setting a default temporary tablespace and setting it in the create database statement. You can also change the sys and system passwords in the create database statement. Plus, you can create the undo tablespace there too. I seem to be creating a lot of

Re: overloading and = comparisons in SQL

Wow. Extremely simple and extremely nice :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:24 AM Courtesy Julian Dyke ( http://www.juliandyke.com ): SET SERVEROUTPUT ON DECLARE

RE: Antw: Database Link

That's a classic SQL*Net name resolution error. Something is not configured properly. I've had links that went both ways and the only problem was with the TIMESTAMP data type because 8.1.7 didn't know what to make of it. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL

Re: OT: Oracle 9iOAS install help needed

are you using the full host name? webbox.mycompany.com? Is iasdb or whatever you named your infrastructure instance up and running? [EMAIL PROTECTED] 9/9/2003 8:59:26 AM Hi All,I am trying to install Oracle 9iAS on Win 2000I installed Infra structure successfully. While trying to install

RE: EM To Go

Dick, The obvious questions are: 1) what does it monitor? 2) what problems does it diagnose and fix on its own? Jared On Mon, 2003-09-08 at 13:14, Goulet, Dick wrote: Binley, I've spent more time than I care to remember in reactive mode. It stinks, which is most likely why I

Re: overloading and = comparisons in SQL

example try then. Note that Oracle can't use indexes in joins for implicitly or explicitly converted data - unless you have relevand function based indexes there... So, you might have problem in your design. Just a little clarification to my own post just in case: The index can not be used

RE: How to send an email from unix command line?

Or check out mpack Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

Re: 10g

did oracle provide you with documentation on these tools or just the 10g database and you had to find it all yourself? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 5:39 PM ADDM (pronouned Adam) is - as I wrote a minute

Re: 10g

It will even - in EM - highlight if an execution plan hash value changed. We did that 2 years ago in Perl for Oracle DBA's :) Jared Mogens Nørgaard [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/09/2003 02:34 PM Please respond to ORACLE-L To:Multiple recipients of list

Re: 10g

I have done it in Word using ctrl-B for few times ;) Tanel. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 10, 2003 2:04 AM Subject: Re: 10g It will even - in EM - highlight if an execution

Re: How to send an email from unix command line?

Or telnet to your SMTP gateways port 25 and start scribbling keywords like helo and rcpt etc... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 2:44 AM Or check out mpack Ron Thomas Hypercom, Inc [EMAIL

imp with dd pipe

Hi Friends, I exported with full=y my whole database(on AIX5.1,oracle8174), I exported with pipe and dd (bs=65536k)commands, Export went very well. But my problem now Iamimporting back with tables=mytable its just sitting there? with out any response. IfI query osits showing its running.. Iam

Re: imp with dd pipe

Perhaps you could include the export command line. I'm having a difficult time understanding why you would use dd with export. Jared venkat Rama [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/09/2003 05:49 PM Please respond to ORACLE-L To:Multiple recipients of list

HTML Report Question

Hi DBAs! I am trying to generate an HTML report, and send it through the mail in HTML format. Only one problem...Outlook thinks it's text not html, even though the first line of the report is html. I'm generating the report with... sqlplus -silent -markup HTML ON ...and then using mailx

RE: Weird ORA-00060 (deadlock) with pragma autonomous transaction

It is at work. I will bring it home (on floppy) and post it tomorrow. -Original Message- Henry Poras Sent: Tuesday, September 09, 2003 2:39 PM To: Multiple recipients of list ORACLE-L transaction Babette, Could you post the deadlock trace file please. Henry -Original

RE: Weird ORA-00060 (deadlock) with pragma autonomous

We are on version 8.1.7.4 on the mainframe (OS390 platform) -Original Message- James Howerton Sent: Tuesday, September 09, 2003 10:05 AM To: Multiple recipients of list ORACLE-L What version are you on??? There is a bug in 9.2.0.3, I was getting this error regularly on my rman

RE: Weird ORA-00060 (deadlock) with pragma autonomous transaction

Yes we have a commit in the procedure and we rollback if an exception is raised. That was one of the first things I looked at. It would have been nice if that was the only problem. - Babette -Original Message- Ryan Sent: Tuesday, September 09, 2003 12:29 AM To: Multiple recipients of

RE: question about migrating to 9i

Ryan dbca is indeed available with Solaris. I used it today in fact. What I've learned about it is: - It runs in X-Windows. I don't have much expertise with X-Windows, but it seems to run fine from the Solaris console. - Unable to create a block size greater than 8k, at least what I've

imp with pipe and dd cmds

Hi Friends, I exported with full=y my whole database(on AIX5.1,oracle8174), I exported with pipe and dd (bs=65536k)commands, Export went very well. But my problem now Iam importing back with tables=mytable its just sitting there? with out any response. If I query os its showing its running..

Re: imp with dd pipe

Jared, My database size is big i.e more than 150GB, so Iam using pipe(mknod) feed thru dd input and output to tape, same way Iam importing back thru tape as input and pipe as a file input to imp. So Iam geting no response..I hope you understood now!! thanks [EMAIL PROTECTED] wrote: Perhaps you

Oracle 11i

I would like to evaluate Oracle 11i. Could any body let me know what are pros and cons between Oracle 11i and Oracle Collaboration Suite? Is there any place where I can download Oracle 11i and related documents for trial? I can not find them on Oracle web site. Thanks for any inputs in

Re: Oracle 11i

Heh,heh forget it, they are very different products - Collaboration Suite is for e-mail, calendar sharing, messaging, file storing and conferencing. Oracle E-Business Suite 11i is an integrated ERP, CRM, MFG, yadda-yadda package, which doesn't help you with your e-mails or videoconferences, but

Re: imp with pipe and dd cmds

Are you sure that your exportfile is intact, that it was saved fully and correctly to tape and it is read fully and correctly from tape. And it is passed fully and correctly to the pipe? Shouldn't you have used exp with pipe and split for this purpose? Tanel. - Original Message

Re: Oracle 11i

The 11i docs, however, are available from docs.oracle.com. Latest version is 11.5.9. Tanel. You can't download 11i, you can order it for evaluation from Oracle, it's about 50 CD (when the heck will they put it on DVD?), but you have to be a fairly serious company for getting the eval.

  1   2   >