RE: cron script

You've got it set up at 1am (server time). What is the current server time? Use date command. -Original Message- Sent: Tuesday, February 06, 2001 9:47 PM To: Multiple recipients of list ORACLE-L Hi All, We have a cron script to take export of a table on 1 st of every

RE: need the detailed explanation of the difference between schem

hi£¬Mandar Ghosalkar£¬ thanks for your explanation. but what about create schema? i read oracle8i sql reference,but still not clear. and someone once tell me something about virtual user,which has something to do with the difference between schema and user. can

RE: System tablespace as locally managed only on 8.1.7

Hi Gopal, That was 8.1.5. I have not tried it again since. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Wednesday, 7 February 2001 16:56 To: Multiple recipients of list ORACLE-L Gautam ! If my memory serves

Re: Re:Alert Log

Dick, Seems you haven't called OTS recently. They come up nowadays with a lot of "interesting" ideas. Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 5:43 PM How did OTS come up with the idea that your using

Re: ora 704 --- URGENT!!!!!

Try to see whether the ROLLBACK_SEGMENTS list in the database init.ora file contains the name of a rollback segment that does not exist. HTH Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 06, 2001 4:22 PM hi, os : hp

Re: Insert data into LOB column

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 02:35 I am new to working with LOBs. I want to insert data (through SQL or PL/SQL) into a table that looks like this: column1 varchar2(100) column2 BLOB column3

RE: how to read column with LONG datatype

Yes, as you do with other fields: select long_field from table. However you can't apply to it a char function as substr or rtrim, etc in a SQL. Although there is a way to treat it with PL/SQL. I strongly recommend you to use LOBs: CLOB or BLOB or even BFILE. And you can manage them with

Re: ora 704 --- URGENT!!!!!

If you have support you should probably call them. This is what I found on Metalink as well: Explanation: This is a general error reported at startup when there is some problem during processing of bootstrap information. There should be an accompanying error/s.

UTLBSTAT and UTLESTAT

Hi Djordje, Statistics tables created by these scrpts are get created as system user so it is better to change the default tablespace of system user before running this scripts. UTLESTAT script creates the end statistics tables , finds the differences and then

Re: Sun- SGA size and sgabeg question?

Hi, in theory, 32-bit word size can address max. 4Gb memory space. I guess total 1.7GB restriction is for HP-UX (32-bit). As I know, you can have an SGA of 1 Gb max. and 1.7Gb total on HP-UX (32-bit). Solaris and HP memory managements are different. if you dont change sgabeg, maximum SGA

Insert data into LOB column

Hi! I am new to working with LOBs. I want to insert data (through SQL or PL/SQL) into a table that looks like this: column1 varchar2(100) column2 BLOB column3 number How can I insert data into that table directly? insert into table (column1, colum2, column3) values

Re: Crontab ,HELP!!!

Hello, We solved this problem by invoking our .profile first in the script Like : . /opt2/OraHome/.profile exp system/pwd file=/opt2/OraHome/exp/Billingfulldata.dmp full=y log=blb.txt good luck Regards Henrik -- ---

Re: need the detailed explanation of the difference between schema and user?

Hi Chaos, 1, Associated with each database user is a schema. A schema is a collection of schema objects. Examples of schema objects include tables, views, sequences, synonyms, indexes, clusters, database links, snapshots, procedures, functions, and packages. 2, Purpose of create schema

recovery catalog creation

Dear all I am trying to create a recovery catalog for RMAN On windows NT And although I type: rman catalog user/user@database create catalog tablespace "tablepsace"; I recieve a error about TNS and Service name. Anyone came accros with something like this? Thanks in advance Nektarios

RE: Pinning Tables

My cheque? The Lottery win? That scratch card I've had in my wallet for the last six months? :^) -Original Message- Sent: Wednesday, February 07, 2001 05:56 To: Multiple recipients of list ORACLE-L cash it Rao -- On Mon, 05 Feb 2001 17:26:19 Allan Nelson wrote: Use the cache

re:re: cron script (fwd)

Hi Molina, Yes I want it to run at every day at 1am . But it is not running at all. My server time is correct . -- neena -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: TIL-TEC INET: [EMAIL PROTECTED] Fat City Network

TKPROF

This is the output from tkprof call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.02 0.02 0 0 0 0 Execute 1 0.00 0.00

Re: STARTUP Force

Neena, after looking at your last 3 messages, you need to sit down and read the administrators guide, 90% of your questions are answered in that book and nowadays there is no excuse for not reading docs(unlike back in version 6 days when people used to hoard the books). joe TIL-TEC wrote:

ORACLE-L@fatcity.com

Test Mail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suganya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

HELP! Re: Dynamic SQL- Issue a connect stmt.

Could anybody think of any other way to open a session from within a procedure, by accepting userid and password from the user. Sarah, thanks very much trying. Radhika. From: Sarah Satterthwaite [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

NOT COMPLETE LOG

MY DB 8.1.6 ON 3 SERVERS WORK WITH OAS DURING FOLLOW UP MY ALERT LOG FOUND LINES 'CHECKPOINT NOT COMPLETE' 'Thread 1 cannot allocate new log, sequence 609'

Sql Tuning help

I have been having some problems with this statement SELECT to_char(NVL(SUM(bet_amount),0))FROM sb_betsWHERE processed_DATE = add_months(TO_DATE('07011999 00','MMDD HH24MISS'),19-1) AND processed_DATE add_months(TO_DATE('07011999 00','MMDD HH24MISS'),19) AND

8.1.7 install

8.1.7 install prompts for location of a JDK and then falls over when I use the default /opt/java Platform is AIX 4.3.3 What is the pathor do I need to install a JDK? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED]

RE: RE: STOMACH WRENCHINGLY OFFTOPIC RE: RE: RE: OT NT2K vs

I think I will add stomach to my e-mail exclude list. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 07, 2001 10:11 AM To: Multiple

Re: recovery catalog creation

Psycharis, Do you have the database defined in your tnsnames.ora file? Can you connect via sql*net to this database shown behind the @ symbol? We get this error when we don't have our ORACLE_HOME set properly. We have multiple versions of Oracle on the same Unix box. Cherie Psycharis

RE: Sql Tuning help

Matt, have you tried replacing the IN statement with an EXISTS statement? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 07, 2001 8:31 AMTo: Multiple recipients of list ORACLE-LSubject: Sql Tuning help I have been having

Detail steps for transportable tablespace

Hi, Steps for trasportable tablespaces are : 1. Make tabblespace read only. 2. Export metadata from scorce 3. Copy data files to target system 4. Trasfer export file 5. Import metadata into target 6. If necessary alter the tablespace to read write For

RE: Pl/SQL Dynamic SQL questions

Susan, Dynamic SQL can get pretty interesting, depending on the values of your programmer defined records. Obviously your code compiles, but when you add the variable, funny things can happen. When you break out of the routine, what line is showing as being the hangup? If it's your bigSQL,

Database Startup Trigger is not pinning all packages

Greetings, I have a database startup trigger which is created from the sys account. The trigger is only designed to pin some packages in the shared pool. However, the trigger is only pinning the packages that belong to the sys account. I am getting the following error in the alert log file when

RE: recovery catalog creation

Hi, You dont have "database" in your tnsnames.ora or whatever name service you use. Sure, sqlplus user/user@database will give you the same. You need to add this entry to your service list on this machine, for exmple into tnsnames.ora Vadim Gorbounov Oracle DBA

Re:RE: RE: RE: OT NT2K vs Unix.

They're suppose to be in the vendors area of the upcoming IOUG-A, which I hope to get to. Wonder if they can do wireless networking from the middle of the lake? Dick Goulet Reply Separator Author: Suhen Pather [EMAIL PROTECTED] Date: 2/6/2001 1:47

RE: LMT's Question

"Kirsh, Gary" [EMAIL PROTECTED] wrote: Terry,I've seem LMT's used in standby db's without a problem. As a matter offact, if you ever want to use the standby in read-only mode, the temptablespace needs to be a LMT, otherwise any query resulting in a sort todisk will fail.Gary KirshNext Extent,

OEM Management Server

Hey guys, I have a quick question about the management server service: Oracle 8.1.6 R2 Win2K box. I have just installed OEM 2.1 on my machine, and when trying to start the management server I get the following error: Could not start the OracleOraHome81ManagementServer service on Local

RE: V$log Status

Hi Ray, There are two different fields in v$log ARCHIVED - tells us if the log is archived or not STATUS - tells us status of data in the log - CURRENT - LGWR is currently writing this log - ACTIVE - the transactions from this log aren't written to the

RE: Sql Tuning help

Here's some thoughts. I don't know if between is faster, but it might be, and won't a straight join do the same as your subquery? SELECT to_char(NVL(SUM(bet_amount),0)) FROM sb_bets WHERE processed_DATE between add_months( .) and add_months( ..) AND

RE: NOT COMPLETE LOG

Implies that Oracle has to switch the current redo but it hasn't accomplished a checkpoint that it's been working on. It is a warning that denotes performance problems. You should increase the size of your redo logs. Regards. -Mensaje original- De: Waleed Haggagy ( Nile Networks )

RE: 8.1.7 install

Does oracle user have permissions to write into /opt/java ? -Original Message- Sent: Wednesday, February 07, 2001 5:36 AM To: Multiple recipients of list ORACLE-L 8.1.7 install prompts for location of a JDK and then falls over when I use the default /opt/java Platform is AIX 4.3.3

RE: RMAN

Title: RE: RMAN That's my dilemma - I would have to install both .. but I have not heard anything good about version 8.1.5. I don't want to install it and have to deal with all kinds of issues. Does anyone know - is RMAN always going to be this way (that you need a catalog for each

Vendor Package Implementation Strategy

Title: Vendor Package Implementation Strategy Hi everyone - I posted this some time ago and didn't really get much response, so I'm trying again. For those of you that are implementing multiple application packages, how to you determine how many Oracle instances and servers to use? For

RE: How to use Export Transportable Tablespaces

Thanks a whole bunch Tim, but one final question. Why did you drop the tablespaces drop tablespace stage_haines_data including contents; drop tablespace stage_haines_index including contents; -Original Message- Sent: Wednesday, February 07, 2001 4:36 AM To: Multiple recipients of list

Re: NOT COMPLETE LOG

1-Your log files are small. 2-If message is coming constantly, then you have to increase size of log files. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 07 Feb 2001 05:00:53 -0800 MY DB 8.1.6 ON 3 SERVERS WORK WITH OAS DURING

RE: NOT COMPLETE LOG

This note is from MetaLink Rick CHECKPOINT NOT COMPLETE === At times you may see "checkpoint not complete" messages in the alert log as follows: Thread 1 advanced to log sequence 248 Current log# 2 seq# 248 mem# 0: /prod1/oradata/logs/redologs02.log

Re: Crontab ,HELP!!!

The script probably needs to set up the oracle environment variables before it will work. Try this. 1) In the oraenv script that's either in /opt/bin or /usr/local/bin depending on your platform, look for the comment that says "Install any custom code here" and insert right after itthefollowing

TABLE CACHE

Hi DBAs I have one large table.I want to keep it into memory thru alter table tname cache; Is there any computation formula how much ram this table takes. Please help me.Thanks in advance. Regards -Mala _ Get Your Private,

Re: NOT COMPLETE LOG

Hello Waleed. Set the follwoing parameters. - LOG_CHECKPOINT_INTERVAL = the number of OS blocks identical to the redo log file size. It starts a checkpoint only on each switched log file. - LOG_CHECKPOINT_TIMEOUT = 0. This disables the checkpointing based on time interval. After these two

RE: re: cron script (fwd)

Try: ps -ef |grep cron you should see: /usr/sbin/cron as one of the entries. If not, then your cron daemon is not running. If it is, then it may be the syntax of your crontab entry. Try: crontab -l cron.txt Post your cron.txt to the list and we'll have a look. HTH Gerardo

oracle on win2k

i installed 8.1.6 on windows 2000 it installed succesfully. when i tried to start the service it gave the ERROR - 1053 from the windows admin Servives, where is the problem __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great

RE: Sql Tuning help

Try joining the 2 tables as below. I think the IN will do a FTS always. Correct me if I'm wrong. Rick SELECT to_char(NVL(SUM(a.bet_amount),0)) FROM sb_bets a, customer b WHERE a.processed_DATE = add_months(TO_DATE('07011999 00','MMDD HH24MISS'),19-1) AND a.processed_DATE

RE: Crontab ,HELP!!!

My god, I almost had a cow when I came in this morning. All my mail that has cron in it goes to its own folder as I have all oracle server mail routed to my exchange mail. I thought I was having system problems. -Original Message- Sent: Tuesday, February 06, 2001 8:35 PM To: Multiple

Re: Database Startup Trigger is not pinning all packages

Did you use 'dbms_shared_pool.keep' package to ping your objects? and did you include schema name with the object name. Below is one example I am using to keep objects in the shared poll immediately after database startup. execute dbms_shared_pool.keep ('SWBAPPS.SWSP_TULEAD_PKG'); Eveleen

Re: Sql Tuning help

Instead of customer_id in...try where exists (select 'x' from customers where sb_bets.customer_id = customers.customer_id and sb_bets.customer_id and LICENSEE_ID=6130) [EMAIL PROTECTED] 02/07/01 08:30AM I have been having some problems with this statement SELECT

Re: Database Startup Trigger is not pinning all packages

Why do you want to pin through trigger. Put it into sql file and run it as @file_name at startup. For example: ORACLE_SID=OPRO4; export ORACLE_SID . oraenv svrmgrl !!opro4 @startup !!opro4 sqlplus -s sys/password @opro4_pin_pkg.sql Sample file: spool opro4_pin_pkg.lst EXECUTE

RE: Crontab ,HELP!!!

I use the following method to execute the profile so environment variables are all set just like when you manually run the script on the command line. 00 01 * * * ksh -c ". $HOME/.profile; /db/oracle/oradata/scripts/SIEBELBKUP/coldbkup" Richard Ji -Original Message-From:

Re: Vendor Package Implementation Strategy

Lisa, We have just been upgrading the majority of our applications that run on Oracle from 7.3.4 to 8.1.5. Some of the apps do not run on 8.1.5 or are not certified. Our solution has been to leave some apps where they are on 7.3.4, have some at 8.0.4 and some at 8.1.5. In other words, we have

ORA-12547: TNS:lost contact at execution of svrmgrl/sqlplus

Hi all, We are running Oracle 8.1.5 on HP-UX 11.0. Recently we started getting an error 'ORA-12547: TNS:lost contact' whenever trying to connect to svrmgrl. No upgrades on the server, it was working fine before. I searched the metalink and tried everything (relinking). The listener

RE: How to use Export Transportable Tablespaces

This process was repeated monthly. So, all references in the target database were dropped each time the process was performed. [EMAIL PROTECTED] 02/07/01 11:56AM Thanks a whole bunch Tim, but one final question. Why did you drop the tablespaces drop tablespace stage_haines_data including

RE: Vendor Package Implementation Strategy

Lisa, The last company I was at had up to 4 different versions of Oracle on the same server. We had 7.3.4 for one package, 8.0.6 for another, 8.1.5 for another and were doing development on 8.1.6 databases. There were a total of 3 development servers with, at one point in time, 30 databases.

Oracle on Unix

Dear All, I've been working with Oracle on NT for years, never had the one on unix. Now, I am trying to use the one on Linux. I see that the installation screen is just the same as on NT. Is this also the same with other unix platform such as AIX, Solaris, HP-UX, etc? TIA Nosie

Oracle on Unix

Dear All, I've been working with Oracle on NT for years, never had the one on unix. Now, I am trying to use the one on Linux. I see that the installation screen is just the same as on NT. Is this also the same with other unix platform such as AIX, Solaris, HP-UX, etc? TIA Nosie

RE: RE: controlfile schema global enqueue lock

Hi Joan, Please ignore all lock types other than ST and CF. Please capture all sessions. It is important to see which session is holding the CF or ST lock when others are waiting. Sid 111 has had a TX lock for 1007 seconds, and has been waiting for the CF enqueue for 3 seconds - this is because

Oracle on Unix

Dear All, I've been working with Oracle on NT for years, never had the one on unix. Now, I am trying to use the one on Linux. I see that the installation screen is just the same as on NT. Is this also the same with other unix platform such as AIX, Solaris, HP-UX, etc? TIA Nosie

RE: oracle on win2k

did it give anymore detail? Is the machine on a network? -Original Message- aradhyula Sent: Wednesday, February 07, 2001 2:26 PM To: Multiple recipients of list ORACLE-L i installed 8.1.6 on windows 2000 it installed succesfully. when i tried to start the service it gave the ERROR -

Oracle on Unix

Dear All, I've been working with Oracle on NT for years, never had the one on unix. Now, I am trying to use the one on Linux. I see that the installation screen is just the same as on NT. Is this also the same with other unix platform such as AIX, Solaris, HP-UX, etc? TIA Nosie

Bstat/Estat File - Table?

Hi, Just curious if anyone has a script(s) that will take the contents of the report.txt file and turn it into loadable files or something along those lines. I know about 'statspack' but many companies are hesitant to permit the creation of tables for storing statistics on their production

Re:Vendor Package Implementation Strategy

Lisa, I assume your meaning is NT vs. Unix not NT vs Oracle. But you do bring a point. There are up and down sides all over the place. Most vendors would prefer that you handle their application as needing a separate instance server. Well that can cost since you need an Oracle license

RE: Database Startup Trigger is not pinning all packages

In order to get the startup trigger to fire correctly, you need to grant "EXECUTE ANY PROCEDURE" to the SYS user. Startup and login triggers fire before any role grants take place, so the privileges have to be granted explicitly. -Original Message- From: Mohammad Rafiq [SMTP:[EMAIL

Re: 8.1.7 install

Hi, I was also confused by the installer too -Oracle ships a IBM 1.1.8 jre on the disk. But I found a jdf 1.2.2 under /usr/local and have this used instead. oli On Wednesday 07 February 2001 15:46, [EMAIL PROTECTED] wrote: 8.1.7 install prompts for location of a JDK and then falls over when

8.1.7 DB and auto registration with Listener

Hello All, While using the default port number and default listener name with Oracle 8.1.7, the automatic service registration takes place when the database is started after starting the 8.1.7 Listener. But if the listener is bounced then the 8.1.7 database does not auto register. However, other

Re:Oracle on Unix

Same screen on HP-UX. Only problem is that you HAVE to have an Xterminal or emulator, damn it. Dick Goulet Reply Separator Author: "Nosie" [EMAIL PROTECTED] Date: 2/7/2001 12:00 PM Dear All, I've been working with Oracle on NT for years, never

RE: Bstat/Estat File - Table?

I would put it the other way around. If you need that information in tables (which I agree is much better than in the report.txt file) edit the utlestat and put the result in a table, or at least create a file in a loadable format (series of inserts or file suitable for Sql*Loader), and not go

RE: TABLE CACHE

It will take the same amount of memory that it currently is taking in disk space. You will need to increase your cache until it is at least as large as the number of blocks that are in the table. If you are running Oracle 8, then there is a new feature that allows you to assign specific pools

iFS1.1: penguin gets slaughtered

Hi, I've played a little bit with ifs1.1. O.K. the penguin is a little bit lightweighted for this task (EE8.1.7, SuSE7.0, kernel 2.4.1, 512 MB RAM, 600 MHz PIII) They say that's the minimal configuration for iFS (2 users, 2 protocols) but anyway I only try it out. Now the machine is in polling

RE: Oracle on Unix

FYI, the box of 817 CDs I got included a sheet of paper warning you to cd out of the cdrom directory before trying to switch CDs. Jim [EMAIL PROTECTED] 02/07/01 03:45PM Yes, The java installer is the same look and feel across all platforms. With 8.1.7 you have 2 CD's on some systems.

Extent allocation

Title: Extent allocation Hi - I am confused now about how oracle actually determines the size an extent should be. I have db_block_size set at 8192 and have defined a tablespace (and tables) at initial and next extents of 128K. When I do a show parameter db_file_multiblock_read_count it

RE: oracle on win2k

timing mismatch ... and status goes into starting --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: did it give anymore detail? Is the machine on a network? -Original Message- aradhyula Sent: Wednesday, February 07, 2001 2:26 PM To: Multiple recipients of list ORACLE-L i

Re: TABLE CACHE

Hi select blocks from dba_segments where segment_name ='table' shows the size of your table. oli On Wednesday 07 February 2001 19:54, [EMAIL PROTECTED] wrote: Hi DBAs I have one large table.I want to keep it into memory thru alter table tname cache; Is there any computation formula how

RE: NESTED MINUS?

Mike, It's not only possible, but I do it all the time. In fact I just did a query against our database that had a Union nested within a Minus nested within an Intersect - not often I get to use all three in the same statement! This particular Select hit several tables of over a million rows

RE: Oracle on Unix

I did this about 4 months ago. Oracle has probably tired of geting the irate phone calls on switching CD's. ;) -Original Message- Sent: Wednesday, February 07, 2001 3:35 PM To: Multiple recipients of list ORACLE-L FYI, the box of 817 CDs I got included a sheet of paper warning you to

RE: Extent allocation

Title: Extent allocation It is a big clue. Oracle rounds to multiples of 5 extents to prevent the existence of a free extent of fewer than 5 blocks, which is unlikely to be usable. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile)

RE: NESTED MINUS?

The syntax is only OK without the "table"'s in it. I think you might be seeing some extra underscores where they aren't. If I run the sql exactly as it is in this message, I get the same error message stated here. Here is the output: 1 select * from table A where A.f1 in ( 2

BSM and Legato

Hello Gurus I am asking a question which is little off topic, please forgive me. I am in the process of upgrading legato networker 5.1 to 6.0.1. I am now running 5.1 with BSM for oracle on my HPUX box running 10.20 OS. My question is in the process of upgrading networker , do I have to remove

No Subject

lists -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Travis Scrivner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

USE_SHARED_SOCKET on 8.1.5 8.1.6

I'm trying to activate port sharing under Win NT 4.0 SP 5. I've set the USE_SHARED_SOCKET to TRUE in Control Panel, System environment. Connected to database from a client. Stopped the listener on the server. But my client connection didn't terminate. I think my connection should have

No Subject

list -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Travis Scrivner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

enqueue waits from statspack report

The following is from a Statspack report from an 8.0.5 database on a Sun server during a load test. Can anyone explain what type of enqueues these are and where I can find some doco on them? I did look on MetaLink and Steve Adams' site. Thanks. Enqueue activity for DB Enqueue

Re: NESTED MINUS?

Thanks Elliott, Jack and Krishna. Well I don't know... after I received your responses I tried in again and it worked!!! Some missing comma or something. Elliot, this was only an example query, the really query is a little trickier. I am using the minus because using the "not in" (my first

Re: enqueue waits from statspack report

CI - Cross-instance Call Invocatiom UL - User-defined locks [EMAIL PROTECTED] wrote: The following is from a Statspack report from an 8.0.5 database on a Sun server during a load test. Can anyone explain what type of enqueues these are and where I can find some doco on them? I did look on

RE: ORA-12514 TNS names could not resolve service name

Thanks for the tip - we just installed 8.1.6 on NT this afternoon and had the problem. Your solution did the trick!!! Laura H. Myers ATT Solutions-ITS [EMAIL PROTECTED] Phone: (336) 698-2375 Fax: (336) 698-2385 -- From: Ruiz, Mary A (CAP, CDI)[SMTP:[EMAIL PROTECTED]]

RE:

And more lists David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 [EMAIL PROTECTED] -Original Message- Sent: Wednesday, February 07, 2001 4:29 PM To: Multiple recipients of list ORACLE-L lists -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Travis

Re:

to port or starboard? [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] On 7 Feb 2001, at 14:41, Travis Scrivner wrote: list ...

steve adams' site

Hello, Can any one tell me steve adams web site and also his book name? rgds, raja Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL

Re:RE: final frontier / RE: RE: RE: OT NT2K vs Unix.

Dick, I'll ask for the details. Might take a while since there is a river next to the campus, and they might want to do extensive "proof of concept" testing prior to releasing internal specifications to the general public. I'll volunteer to bring my kayak for the testing, but it will have to

Re: Extent Allocation

Hi, Oracle allocates blocks to an extent in multiple of 5. -- Neena -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: TIL-TEC INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

A Solaris question on memory usage

Good day, I am looking at how Oracle and other applications running on a Solaris 2.6 server are using memory. The server has 512 MB of RAM. I issued the "/usr/proc/bin/pmap $pid" command to display memory usage info and used the figure from the "total KB" line of the output (the last line of the

Re: steve adams' site

http://www.ixora.com.au/home.htm Oracle8i Internal Services, O'Reilly - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 8:35 PM Hello, Can any one tell me steve adams web site and also his book name? rgds, raja

SQL Query (Sorting)

BDY.RTF

Re: SQL Query (Sorting)

Use decode function in the Order by clause, if the possible values of the column are limited. Message History Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Hi, I have a table with a

Re: SQL Query (Sorting)

select decode(substr(col1,1,1),'+',substr(col1,2,1)||'+','-',substr(col1,2,1)||'-', col1) from test order by to_number(decode(substr(col1,1,1),'+',substr(col1,2,1),'-',substr(col1,2,1), col1)) / This will do the thing Regards Arun Aggarwal Aithent Technologies (P) Ltd. [EMAIL PROTECTED]