Re: configuring management server 8.1.7

Michael, Try ... http://docs.oracle.com/DOCS_DOT_PDF_Storage/a85247.pdf Rama Petrus, Mike (CAP, GEFA) wrote: Does anyone know of a good document outlining the installation and configuration of the Oracle Management Server v 8.1.7? Also important would be the relationship between

Export from sql plus

Is it possible to export the whole content of a table to a file. If is it , what is the command to do this? Thanks, Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Liggayu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

SQL Trace ( Perl script help needed)

Hello Gurus, I was trying to pull distinct sql's and their total execute count from a bunch of 250 trace output files(output from tkprof trace files). How can I achive this. What i need the cumulative sum of execute count from different files for each sql's. As u all know sql can extend more

Re: Export from sql plus

What about: set head off set feed off set pages 0 set lines 1 set trims on spool c:\mytable.lst SELECT '' || col1 || ',' || col2 || ',' || col3 || ',' || ... || '' FROM mytable; spool off or, if you wanted to do it for later import, change the SELECT to: SELECT 'insert into

how to insert quote in a column

Hi, I have a column defined as varchar2..i need to insert name like 'joy' in it with quote how can we insert quote(') to column. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network

Will OEM tools replace I/Watch and other monitoring tools?

Reading over some of the white papers on OEM...and it seems like Oracle is finally building some decent performance monitoring tools. I don't know if these cost extra in 9i or they come with OEM. My question is how long before products like Quest's I/Watch are really not necessary in relation

Re: Export from sql plus

I wouldn't use the term export, because it's too easily confused with the real export utility, but you can write the output of a query to a file: SET PAGESIZE 0 SET LINESIZE 999 SPOOL output.txt SELECT * FROM your_table SPOOL OFF Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] *

Re: how to insert quote in a column

Hello Harvinder, If you are doing the insert from SQL*Plus, double up on the quote. For example: insert into your table (name) values ('''joy'''); The resulting value will be (quotes included): 'joy' BTW, this came in handy recently when I went to a web site (I won't say whose) and tried

Sql*Loader and assign a ROLLBACK segment

Hello, I have a sql*loader script which failed due to the non possibility to extend a rollback segment in the TBS ROLLBACK_DATA. Oracle version 8.1.6.2 on AIX 4.3.3. I have a huge rollback segment in the TBS ROLLBACK_DATA, but how tell to sql*loader to use this rollback segment ? I have not

Re: how to insert quote in a column

Harvinder: Use two single quotes in a row ('') for a single tick. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio From: Harvinder Singh [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California Reply-To: [EMAIL PROTECTED] Date: Mon, 18 Jun

Re: Sql*Loader and assign a ROLLBACK segment

Phillipe: Try setting the other rollback segments temporarily offline so that the loader only finds the big segment for use. Regards adm-unix@eram

RE: Sql*Loader and assign a ROLLBACK segment

and please check whether other user is doing any transaction in the rollback segment. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 9:35 AM To: Multiple recipients of list ORACLE-L Phillipe: Try setting the other rollback segments temporarily

Re: Router filtering

Hahahhah, I looked all over the place, even metaslop to find out if I could do this, I couldn't. According to everything that I read there is no way to know what port oracle is going to allocate for the connection. Do you mean that it would use say port 1521 for every connection that is made?

Re: how to insert quote in a column

Harvinder, if you do select chr(39) from dual, you will get the answer as a ' Therefore, you could do select chr(39)||1||chr(39) from dual to get:- '1' so now you can help your self. for future when ever you need to find the ascii of such characters, do:- select ascii('?') from dual;

RE: Router filtering - caution - awful pun included.

Kevin, You can allocate a shared port is you use MTS. In that case, both the connection and data share the same port on the server. I believe that Oracle recommends no more than 10 connections per shared port, but YMMV. This is not a case for NT-bashing. You might want to research a little

HP OpenView Service Desk 3.0

has any body use or administering this application please? I have encountered with several problems, because of the bad application design. eg they are not using bind variables, there 4 or 5 similar statements with the count upto 300 or more. lots of full table scan. though I have indexed some

RE: Router filtering

On Metalink check out the following note: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOTp_id=132729.1 This is the Technical Library Connection Manager and Firewalls index. eg check out: How to enable USE_SHARED_SOCKET on WINNT and Windows 2000 124140.1

No Subject

Dear Subscribers, I have a broken database that I wish to recover. The old database come from other SID Could you please help me how to recover ? m-t-x Our greatest glory is not in never falling but in rising every time we fall -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE:

A broken database ??? Dear Hermanto, more details would really help... -- From: Hermanto P[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Dear Subscribers, I have a broken

problem encountered while exporting

Hi All, I'm trying to export a (8.0.4) database using a an exp from an 8.0.4 database. But I'm getting the following error. Connected to: Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production With the Partitioning option PL/SQL Release 8.0.4.0.0 - Production Export done in US7ASCII

Re: Oracle Database setup document

Joe, Thanks for that information. But what I am looking to do, is document the planned instance and what oracle parameters I may wish to change away from the defaults. I believe the Oracle dbassist prompts me for the basics but does it ask me what Oracle Parameters for the init.ora I may

<    1   2