RE: tnsnames.ora not working ?
Are you using Oracle Services? I've seen this happen before and we change SERVICE_NAME to SID and everything works fine. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -Original Message- Reuben D. Budiardja Sent: Tuesday, January 20, 2004 10:49 AM To: Multiple recipients of list ORACLE-L Hello, I'm trying to add description in my $ORACLE_HOME/network/admin/tnsnames.ora, but it seems that the client (ie. sqlplus) wont use it. Whenever I try to connect to the service using sqlplus, I got : $> sqlplus Enter user-name: [EMAIL PROTECTED] Enter password: * ORA-12154: TNS:could not resolve service name I tried to add the description to my ~/.tnsnames.ora too with no luck. The entry in the tnsnames.ora is: DEV_DB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dev_db) ) ) (note: I removed the real hostname for privacy/security reason of course) However, when I use sqlplus using the following way: $> sqlplus Enter user-name: developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = dev_db))) Enter password: * It would work, where all the information from the description is just a copy-paste from the tnsnames.ora file. Is there anything I overlook? Sorry if this is kinda a newbie question. I'm still learning my way around this. I'm using Oracle9i on Redhat Linux. Thanks for any help. Reuben D. Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - "To be a nemesis, you have to actively try to destroy something, don't you? Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect." - Linus Torvalds - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: Risk of knowing password hash value (Was: OEM permissions)
This is what I got, Oracle 8.1.7.4 on Sun Solaris (I dropped the user): Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production SQL> create user scott identified by tiger; User created. SQL> select password 2 from dba_users 3 where username = 'SCOTT'; PASSWORD -- F894844C34402B67 SQL> Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -Original Message- rahul sharma Sent: Tuesday, December 23, 2003 1:14 AM To: Multiple recipients of list ORACLE-L 8.1.7 on win2000 SQL> select password 2 from dba_users 3 where username = 'SCOTT'; PASSWORD -- F894844C34402B67 - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, December 23, 2003 11:44 AM > Hi, > > Okay. I'm almost a believer of this as a problem. How > about 9.2.0.4 on RH9.3. > > 1) What does anyone/everyone get for my this query (my > results shown): > > connect system/[EMAIL PROTECTED]; > alter user scott identified by tiger; > -- > select password > from dba_users > where username = 'SCOTT'; > > PASSWORD > > F894844C34402B67 > > 2) If you all get the same, then I'm concerned. > > Regards, > > Mike Thomas > > --- Yong Huang <[EMAIL PROTECTED]> wrote: > > Jared, > > > > I see you log out and log back in as SYSTEM to DB2. > > But how do you know the > > password for SYSTEM to log back in with after you > > change it? > > > > What if you don't log out? When I tried that (i.e. > > not logging out), I got > > ORA-1017. > > > > Yong Huang > > > > --- Jared Still <[EMAIL PROTECTED]> wrote: > > > Environment: > > > > > > DB1: RH 8.0 with Oracle EE 9.2.0.4 > > > > > > DB2: Win2k SP3 with Oracle EE 9.2.0.1 > > > > > > SYSTEM user on each database initially have > > different passwords. > > > > > > __ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Michael Thomas > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: Misbehaving query
That's what I was thinking, too. I tried it on 8.1.7.4 and it works the
same way, as I expected. You would need an outer join to get something
back.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
-Original Message-
Carol Bristow
Sent: Friday, December 12, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
Junk minus junk2 results in no rows, and when you do the implied
cartesian join between view a and view b, joining no rows with one row
gives no rows.
Makes sense to me.
Carol Bristow
DPRA Inc.
1300 N 17th St Suite 950
Rosslyn, VA 22209
Work: 703-841-8025
Fax: 703-524-9415
-Original Message-
Sent: Friday, December 12, 2003 3:05 PM
To: Multiple recipients of list ORACLE-L
Hi!
I have a query that I think is behaving oddly; and, it may just be that
I'm
blind and am doing something silly (*there's* a first!), or it may be
environment specific, but, I'm thinkin it may just be a bug. I have
filed a
TAR with Oracle, and they keep sending workarounds, when I told them
from
the start that I've got one, this is only a question of why this query
isn't
working. So, two parts, really... is this query really not working, and
if
so, does anyone have a clue as to why?
We're on 9.2.0.2 on SunOS. The overall issue is easy. I have two
tables.
I want to find the difference in the contents. This is easily
accomplished
by doing
A MINUS B
UNION
B MINUS A
*That's* not the issue. The issue is that if I do this through inlines,
the
query fails. I'll put everything out there so you can just cut and
paste
iffen you wanna...
SQL> create table junk (test char(1));
Table created.
SQL> insert into junk values ('A');
1 row created.
SQL> insert into junk values ('B');
1 row created.
SQL> insert into junk values ('C');
1 row created.
SQL> create table junk2 as select * from junk;
Table created.
SQL> insert into junk2 values ('X');
1 row created.
SQL> select * from junk;
T
-
A
B
C
SQL> select * from junk2;
T
-
A
B
C
X
SQL> select * from junk minus select * from junk2
2 union
3 select * from junk2 minus select * from junk;
T
-
X
SQL> select a.*
2 from
3 ( select * from junk2 minus select * from junk ) a;
T
-
X
SQL> select a.*, b.*
2 from
3 ( select * from junk2 minus select * from junk ) a,
4 ( select * from junk2 minus select * from junk ) b;
T T
- -
X X
SQL> select a.*, b.*
2 from
3 ( select * from junk minus select * from junk2 ) a,
4 ( select * from junk2 minus select * from junk ) b;
no rows selected
Anyone?
Bambi.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bellow, Bambi
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Carol Bristow
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Scott Canaan
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: Oracle 10g Migration
According to the presentation by Dave Foster of Oracle at the last UNYOUG meeting, there will be a direct upgrade from 8.1.7 and 9.2. Also, the new dbassistant has an undo feature, to rollback the upgrade. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -Original Message- Sent: Friday, November 21, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Mladen, Direct 8i(as in 8.1.7.4) to 10 or do you HAVE to go through 9.x first? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, November 21, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Yes. On 11/21/2003 09:29:31 AM, Tracy Rahmlow wrote: > Does anybody know whether or not Oracle will support and upgrade of an 8i > database to 10? Thanks > American Express made the following > annotations on 11/21/2003 07:28:27 AM > -- > ** > > "This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Thank you." > > ** > > > == > Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: New Virus alert from paypal
Since, I believe, Paypal is owned by eBay, has any that's received this sent a message to safeharbor? I would think they should be made aware of it. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -Original Message- Sent: Wednesday, November 19, 2003 10:40 AM To: Multiple recipients of list ORACLE-L List, Any one else get word of this new virus? Ron >>> Mar-D Greer 11/19/2003 9:34:44 AM >>> There is a new virus that has surfaced since last week. This virus reports that users need to update their PayPal accounts. Do not open this, delete the e-mail as PayPal has not issued this e-mail and the e-mail itself contains a virus. The actual e-mail reads as follows: (Found virus WORM_MIMAIL.J in file www.paypal.com.pif) ** Dear PayPal member, We regret to inform you that your account is about to be expired in next five business days. To avoid suspension of your account you have to reactivate it by providing us with your personal information. To update your personal profile and continue using PayPal services you have to run the attached application to this email. Just run it and follow the instructions. IMPORTANT! If you ignore this alert, your account will be suspended in next five business days and you will not be able to use PayPal anymore. Thank you for using PayPal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: Point-In-Time recovery question, Non-RMAN solution
Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -Original Message- Sent: Thursday, November 06, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: RE: dba interview questions
What do you need the stmt for? Just do:
begin
for a in (select username from dba_users
where username not in ('SYS','SYSTEM',...))
loop
execute immediate 'alter user '||a.username||' account
lock';
end loop;
end;
/
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
-Original Message-
Sent: Friday, October 24, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
Sure do, here's my favorite:
You have a database with 3000 registered users, you need to lock
all accounts except for a list of 20. How would you do it?
Obviously there's several correct answers. But the one I'm looking for
is the "anonymous PL/SQL block" defined like:
declare
stmt varchar2(200);
begin
for a in (select username from dba_users
where username not in ('SYS','SYSTEM',...))
loop
stmt := 'alter user '||a.username||' account lock';
execute immediate stmt;
end loop;
end;
/
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Friday, October 24, 2003 12:00 PM
To: Multiple recipients of list ORACLE-L
do any of you ask dbas pl/sql questions? I think its important for DBAs
to be good developers as well. especially if they are part of a
development team. I dont think the skill sets should be seperate. they
overlap.
>
> From: "Jamadagni, Rajendra" <[EMAIL PROTECTED]>
> Date: 2003/10/24 Fri AM 11:39:33 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject: RE: dba interview questions
>
> We prefer to ask their experiences and then throw a curve ball and ask
them to defend it. Small issues like "Why would/wouldn't an index help?"
etc ...
>
> Another question that I *always* ask is "what do you or have you read
in last 3 months outside of Oracle manuals?" or "Do you know any other
sites that give you lot of oracle related information?" I expect to hear
at-least couple form following list ... ixora, hotsos, jlcomp,
oracle-dba, oraperf, orapub. If they mention that they have read YAPP,
that's a bonus too.
>
> But if someone says they haven't read anything other than manuals
questions become a little steep.
>
> Raj
>
> -Original Message-
> Sent: Friday, October 24, 2003 9:49 AM
> To: Multiple recipients of list ORACLE-L
>
>
> The problem with such lists is that the prospects also have those...
> A few years ago Mike Ault published one. We used it to screen
candidates via phone interviews.
> Two out of four I talked to gave me perfect answers: word to word from
Mike's list.
>
> Use Conner's approach: Give the candidate a white/black board, and ask
him/her to draw the SGA
> with all it interal structures, all background processes, and explain
how all this works
> together.
>
> - Kirti
>
>
**
> This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged,
attorney work product or exempt from disclosure under applicable law. If
you have received this message in error, or are not the named
recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.
>
**4
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jamadagni, Rajendra
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
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 fro
RE: Question about sql
How about: insert into table3(company_id,lev_id,vare_id) (select table2.company_id,lev_id,vare_id from table1, table2 where table1.company_id = table2.company_id); Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -Original Message- Sent: Thursday, October 16, 2003 10:20 AM To: Multiple recipients of list ORACLE-L Hallo, Anyone whom could gíve me some good help on this. I have a table with one field, called Company_id Like this Company_id 16 45 50 In table 2 I have this field and values: Company_id Lev_idVare_id 16 45 56 34 10 20 67 10 20 45 15 30 50 12 12 I would like to from table 2 do a select and find the Company_ids from table1 and find out the responding lev_id and vare_id in table2and then insert them into a new table(table3) so it would look like this: Company_idLev_idVare_id 1645 56 Anyone whom could give me some help on this how to write the sql- query. I have tried with this sql query. What is wrong? insert into table3(company_id,lev_id,vare_id) select company_id,lev_id,vare_id from table2 where vare_id = 56 (where exists select company_id from table1) Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: FIRST_ROWS hints
Did you remember to cut the db_file_multiblock_read_count in half, since you doubled the blocksize? I would assume that you also started seeing more full table scans, as well. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -Original Message- From: Sai Selvaganesan [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 2:54 PM To: Multiple recipients of list ORACLE-L Subject: FIRST_ROWS hints hi i had a migration from 9.2.0.3 to 9.2.0.4 of a database and here are a couple of observations. please help me in understanding this. i changed the db block size from 8k to 16k and all sql queires which were using nested loops earlier moved to sort merge joins. i ran 10053 and form whatever i could understand the 9204 db has fewer number of blocks compared to the existing 9203 (db size changed to 16k) and sort merge join turned out to be less costlier than nested loops (i couldnt understand the sort statistics). no parameter other than db block size was changed. after breaking my head i changed the optimizer mode from choose to first rows and the query is back to the old explain plans. please clarify 1. whether this is a expected behaviour 2. what is first_rows hint and whether it is good move to go to first_rows to fix this problem. thanks sai
RE: Using dimensions
Title: Using dimensions Dimensions are data warehouse constructs. They are implemented as tables in the database, but have the characteristic of a hierarchy that can be traversed. For example: a time dimension can have the hierarchy of date, day, week, month, quarter, year, decade, century. This is used for rollup reporting within the data mart. I don’t see any good use of it in an OLTP environment, but I may be wrong. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 10:55 AM To: Multiple recipients of list ORACLE-L Subject: Using dimensions I have tried, but haven't found a good example of how to _use_ a dimension in 9ir2. I defined one, but then sat clueless on what to do with it. Is it any good in an OLTP environment? (I smell the answer is a NO, but still) ... Any notes from your experience? TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !
RE: Sqlloader question
The way I handled a similar situation was to create a default SQL*Loader file with something recognizable in the place that you want to do the substitution (in your case, the infile filename). Then, I wrote a shell script that created the correct filename and copied the default SQL*Loader file to the one that was going to be run, substituting the created name for the default name. In my case, I used it to determine which partition should be loaded, but the concept should still work. I used sed to do that: sed "6s/partition()/partition(`echo $IN_DATE_FMT`)/g" em_contact_hist_ld.orig > em_contact_hist_ld.ctl In the script, this was followed by a call to sqlldr with the control file em_contact_hist_ld.ctl. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -Original Message- Sent: Thursday, September 11, 2003 9:14 AM To: Multiple recipients of list ORACLE-L Hallo, Anyone whom could tell me if it is in an sqlloader possible to write for instance this if you dont know the exactly name of file. infile '/d31/datafiler/sema/incoming/konkurrenter.*' If there are going to be files with different extensions fo rinstance the first time a file is going to be inserted will be konkurrenter.txt.1 and the next time the file will have the name konkurrenter.txt.2 etc. How should I handle this? Thanksin advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: 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 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 web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: Sun HA Monitoring and Oracle 9
Barb, This isn't an Oracle limitation. It's a Sun HA limitation. Oracle 9i will run on Sun Solaris HA 2.2, with no problem. We've installed it and built an instance and run it. The problem comes in when you want to HA monitor the database. HA 2.2 won't even run when it gets to the Oracle 9i instance. The problem is so bad that the program just exits as soon as it hits that instance, so it ends up not monitoring anything, not even the 8i instances. Our SA called Sun and was told that HA 2.2 only works with Oracle through 8i. If we want to use it with Oracle 9i, then we have to buy HA 3.0 (it's not an upgrade, they consider it a new product). They did say that HA 3.0 will support Oracle 8i and 9i, but nothing before Oracle 8i. Unfortunately, the changeover means that we would have to do a complete rebuild of the Sun Cluster, which is not possible. We can't have that much downtime (about 1 week). If we get the funding, our plan is to buy 2 more Sun machines, build a 2-node cluster with HA 3.0, migrate the applications to that cluster, then bring 2 of the original Sun machines into that cluster, making it a 4-node cluster again. Barbara Baker wrote: Scott (or anyone runing HA 2.2 wishing to upgrade to 9i): I noticed you did not receive a response from this message a couple of months back. We're in same situation (Sun Cluster 2.2, wishing to upgrade to Oracle 9i). It's not clear from the Oracle certification matrix if this is supported. (Clearly not supported if you're running RAC, but we're not) We're not convinced we want to upgrade to Sun cluster 3.0 (and certainly not clear we want to pay for it.) I'm wondering if there are others with this configuration, and if so what you decided to do. Thanks in advance for any information. Barb -Original Message- Sent: Monday, January 06, 2003 10:14 AM To: Multiple recipients of list ORACLE-L Here's a little background. We are currently running Oracle 8.1.6.0, 8.1.7.0, and 8.1.7.4 on a Sun cluster. We use HA monitoring for failover, in case there is a problem with any of the nodes. The version of HA is 2.2. We installed Oracle 9.2.0.1 on the cluster and created a new database using it. When the SA tried to start the HA monitoring, it wouldn't run. We ended up recreating the database in 8.1.7.4. When the SA contacted Sun, he was told that HA version 2.2 only supports up to Oracle 8.1.7. In order to monitor Oracle 9, we had to buy (not upgrade to) HA 3.0, which would require a rebuild of the entire cluster. Has anyone else run into this problem? If so, what have you done to get around it? Let me know if I forgot any important piece of information. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://platinum.yahoo.com -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.
Import Problem
I ran into a problem yesterday afternoon. I had exported a production database, via a full database export, and ftp'd it to another machine to import it there and make that the new production machine. It was a long import (about 8 hours) and about 2/3 through it, my network connection was dropped. I was running it in a ssh shell. When the connection disappeared, the import died. Since I had to get the job done by morning, I chose to drop the database, rebuild it, then re-import. That worked. What I am wondering is: Is there a way to resume an import, once it has been interrupted? I have been looking in metalink and on the net and haven't found anything that says how to do it. I tried technet, but it was way too slow. Any thoughts would be greatly appreciated. Thank you, -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: UPDATE...REPLACE...'...apostrophe...
chr(44) "Gorden-Ozgul, Patricia E" wrote: I'm running Oracle on Solaris 2.6.I successfully inserted data from a composite file by replacing apostrophes with ' by way of sed...s/'/\'/g...beforehand.Now I need to perform an UPDATE, REPLACE...UPDATE tbl SET col = REPLACE(col, ''', ...with what?)Please advise.Pat -Original Message- From: Saira Somani [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 25, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: SQL struggle Thank you for your assistance - it works - and I have one more question: How can I also get the SELECT to show me the original item number - i.e with the '-OR'? Thanks, Saira -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] Sent: February 25, 2003 1:57 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: SQL struggle (see answer below) > -Original Message- > From: Saira Somani [mailto:[EMAIL PROTECTED]] > > Oracle 8.1.7 on AIX 4.3 > > Here is what my data looks like in a table called item_w: > > WHSE_CODE ITEM_NUM LAST_COST > -- -- > HL1 111230 1.12 > CPD-TWH 111230-OR 0 > CPD-TGH 111230-OR 0 > HL1 50034 .91 > MSH-CDS 50034 0 > CPD-TGH 50034-OR 0 > HL1 650300 4.789 > TWH-STAT 650300 0 > CPD-TWH 650300-OR 0 > CPD-TGH 650300-OR 0 > > If you'll notice, only the items with WHSE_CODE='HL1' have a cost > associated with them. > > What I need to is: > > Parse ITEM_NUM for those items which have a suffix of -OR in order to > compare with an ITEM_NUM without -OR so that I can take the last cost > from there and display it beside the one that has -OR. Also > note, there > are some $0 cost items that don't have a suffix of -OR; I > would need to > match those up with a cost as well. > > So in the end, I suppose, this is the result I'm looking for: > > WHSE_CODE ITEM_NUM LAST_COST LAST_COST_REV > - - - > HL1 111230 1.12 1.12 > CPD-TWH 111230-OR 0 1.12 > CPD-TGH 111230-OR 0 1.12 > HL1 50034 0.91 0.91 > MSH-CDS 50034 0 0.91 > CPD-TGH 50034-OR 0 0.91 > HL1 650300 4.789 4.789 > TWH-STAT 650300 0 4.789 > CPD-TWH 650300-OR 0 4.789 > CPD-TGH 650300-OR 0 > 4.789 > > And if any of you out there use Cognos Impromptu, perhaps you > could tell > me how I can achieve these results in a report. Would this work? select a.whse_code, a.item_num, a.last_cost, b.last_cost as last_cost_rev from item_w a, item_w b where a.last_cost = 0 and replace (a.item_num, '-OR') = b.item_num and b.last_cost > 0 union select c.whse_code, c.item_num, c.last_cost, c.last_cost as last_cost_rev from item_w c where c.last_cost > 0 ; -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.
Sun HA Monitoring and Oracle 9
Here's a little background. We are currently running Oracle 8.1.6.0, 8.1.7.0, and 8.1.7.4 on a Sun cluster. We use HA monitoring for failover, in case there is a problem with any of the nodes. The version of HA is 2.2. We installed Oracle 9.2.0.1 on the cluster and created a new database using it. When the SA tried to start the HA monitoring, it wouldn't run. We ended up recreating the database in 8.1.7.4. When the SA contacted Sun, he was told that HA version 2.2 only supports up to Oracle 8.1.7. In order to monitor Oracle 9, we had to buy (not upgrade to) HA 3.0, which would require a rebuild of the entire cluster. Has anyone else run into this problem? If so, what have you done to get around it? Let me know if I forgot any important piece of information. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan 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: warehouse builder's dependance on oem job system.
I run the jobs via cron, without any parameters and we don't have any problems. If you look at the parameter list, you'll find that most (if not all) have default values anyway. I have been running them via cron for months without any issues, other than the fact that we can't multitask. "Mandar A. Ghosalkar" wrote: > Chris, > > the parameters 3,2,50,1000,50,wb,10 are used inside the oem-owb job tcl script as > set p_oper_mode [lindex $parList [incr parList_i]] > set p_audit_level [lindex $parList [incr parList_i]] > set p_num_errors [lindex $parList [incr parList_i]] > set p_commit_frequency [lindex $parList [incr parList_i]] > set p_bulk_size [lindex $parList [incr parList_i]] > set p_purge_group [lindex $parList [incr parList_i]] > set p_percentage [lindex $parList [incr parList_i]] > > and then the package.main is called > > try the following. i would recommend testing this on the test server before putting >it on prod :-) > > sql>exec C40_ADMIN_CUSTOMER_MAP.Main(p_operating_mode => 3, p_audit_level => 2, >p_max_errors => 50, p_commit_frequency => 1000, > p_bulk_size => 50, p_job => 'wb'); > > -Mandar > > Original Message- > Sent: Thursday, December 12, 2002 1:09 PM > To: Multiple recipients of list ORACLE-L > > here is the tcl that was generated: > > "-r" "3,2,50,1000,50,wb,10" "-c" "WE8MSWIN1252" > > the package that is generated is quite long. > i have absolutely no idea how to read the tcl. > if you could point me somewhere, i could try and figure it out myself. > any help is appreciated. > > attached is the package code if you are willing to take a look... > > (for some reason my computer associates .pls extensions with real audio) > > > > > -Original Message- > Sent: Tuesday, December 10, 2002 1:11 PM > To: Multiple recipients of list ORACLE-L > > Chris, > > All the owb etl jobs are packages and if you have configured it right, then you >could the execute the package_name.main procedure to run the etl process. your best >best would be to read the tcl script and the associated parameters for the owb-oem >job. > > You could paste the tcl and the parameters here to help u more. > > -Mandar > > -Original Message- > Sent: Tuesday, December 10, 2002 9:31 AM > To: Multiple recipients of list ORACLE-L > > ok, here's the situation: we are loading our warehouse via etl processes generated >by warehouse builder (owb). we went live with this a little over a week ago. up to >this point we have been running the jobs manually through owb. for obvious reasons >we need to be able to schedule these jobs. the only way (that i know of) to schedule >the owb jobs is to deploy them to entreprise manager. the problem is that our oem is >VERY unreliable and seems to be related to bugs. we are running oem v9.2 and oracle >ee v9.2. when jobs are scheduled through oem, they run sometimes and hang others. >this is unexceptable. > > so my question is: does anyone know of a way to trap the commands that oem sends to >the database? the obvious solution would be to just cron execution of the packages >owb generates inside the database. this doesn't work though because owb generates >funky code that takes parameters, whose values i don't know, for logging purposes. > > hopefully i explained the situation well enough. > > any ideas??i'd like to get rid of the dependance on oem. > > oem sucks > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mandar A. Ghosalkar > 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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: hmm...
You can update the global_name by using sqlplus or svrmgrl (internal or "/ as sysdba" or sys): update global_name set global_name = newname; commit; I do this every time I clone a database. If you don't change it, then the database links won't work. DENNIS WILLIAMS wrote: > Adam - Someone posted a better "hidden?" parameter awhile back. Jared, was > that you? > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Friday, December 06, 2002 11:29 AM > To: Multiple recipients of list ORACLE-L > > I was afraid that'd be the only way. Thanks. > > Adam > > -Original Message- > Sent: Friday, December 06, 2002 12:05 PM > To: Multiple recipients of list ORACLE-L > > Hi > > Set global_names = false in init.ora file and try again > > -Original Message- > Sent: vrijdag 6 december 2002 17:41 > To: Multiple recipients of list ORACLE-L > > Don't ask how we got into this situation, but I have two instances with the > same global_name and need to be able to create a link between them. Is this > doable? > > Adam > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Donahue, Adam > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jack van Zanen > 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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Donahue, Adam > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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: But I *want* to use RBO!
Only 9.0.1 (June 30, 2003). There is no desupport notice for 9.2. You'd be better off on 8.1.7, which is supported until Dec. 31, 2003. "Mercadante, Thomas F" wrote: 9i is being desupported soon? you really must be joking.At least I hope you are.Oracle, if it is moving this fast, is going to hurt themselves. We can't move that fast. Tom Mercadante Oracle Certified Professional -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: But I *want* to use RBO! 9i is also being de-supported soon ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Subject: But I *want* to use RBO! (just kidding) No more RBO as of 10i... http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=NOT&p_id=189702.1 "10i"? I haven't even upgraded to "9i" yet because none of our vendors have, either. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer.
Strange performance problem
I got a call from a customer earlier. He said that he was trying to run a query and it was taking way too long. He ran the same query last Friday and it came back in seconds. I looked at it in OEM and noticed that two of the tables were being accessed by full table scans. These tables have 22,000+ and 24,000+ rows each. I took the sql from OEM and ran it in a svrmgrl session (connected internal), and it came back in seconds. His still hadn't come back. To further complicate things, I connected as the owner of the tables (the same user he was using) and ran the query again. This time, I ended up killing it after 10 minutes. I'm confused as to what can cause such a difference in performance from sys to another user. The server did crash sometime over the weekend. He said that it was fine before the crash. I ran a dbverify on all of the data files and came up with nothing. The vitals are: Oracle 8.1.6.0.0 Digital Unix V4.0F (Rev. 1229) Unfortunately, upgrading Oracle isn't an option because the processor is too old. Oracle won't support it on any versions higher than 8.1.6. A patchset may be possible, though. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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).
Another Character Set Problem
We are currently having a character set problem. We have a third-party product that is used for on-line courses (Prometheus from Blackboard, Inc.). The character set that the instance was created with was US7ASCII. The vendor says it should be WE8ISO8859P1, but we need to support Chinese and Japanese characters. I contacted Oracle support, and was told that the specified character set would not support those characters, but that I should use UTF8. I altered the instance to use UTF8 and ran into a CLOB problem. We installed patchset 4 (so we are now 8.1.7.4.0 on Sun Solaris 2.8) and that problem went away. However, none of the CLOB data is rendered properly in the application and I don't have a tool that allows me to see it directly out of the database. I am tempted to try to change the character set to WE8ISO8859P1, as the vendor requested, with the hope that any deficiencies in that character set have been handled by their product. At this point, can I change the instance from UTF8 to WE8ISO8859P1? I do have a tar open on this issue and will be asking the same question there, but I'm hoping I'll get a response here faster (ok, I'm expecting that I will). Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Please need some help on imp
Bill, Where are you trying to load the data to? Do the tables already exist? If so, then use the ignore=y option and it won't complain if the table already exists when it tries to create it, but it will load the data into it. Bill Conner wrote: > Hi All, > > i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3 > times but don't seem able to get the imp to just load the data and not the > tables as well. Am running solaris 8 &oracle 8.1.7 anything that i might > not be seeing would be very much appreciated!! > > TiA > > -bill > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bill Conner > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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).
Performance Problem after Migration
I have an interesting problem. I recently migrated a database from a Digital Unix system to a Sun Solaris system, with an EMC disk array. Since I was going to be migrating the database, I decided to double the block size from 4k to 8k. I also created the tablespaces on the new box as locally managed, with fixed extent sizes. Then I did a full database export, ftp'd the file, and imported it. It went well, or so I thought. The application works, but it is much slower than it was on the original (Digital) system. One side effect was that I didn't change the db_block_buffers, so that part of the SGA essentially doubled in size. The library cache hit rate was always around 99%, but the data cache hit rate used to only be about 85%, now it is 95 - 99%. All of the sorts are being done in memory, with memory to spare (52G yesterday, not used). According to the statistics, the database should be screaming. But the users are complaining that the online screens are taking much longer to come up. They say that the screens used to come up in 1 - 2 seconds, now it's taking about 10. Just for fun, I tried deleting the statistics and changing the optimizer_mode from choose to rule. That made things worse, which was what I expected, but it was worth a try. I have tried to capture a session, but I need to get a repository up to look at the trace that was generated. Until then, I'm pretty baffled. I'd appreciate any ideas that anyone has on this. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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).
Hints and Case Statements
I have run into a performance issue that I can't find any information on. There is a query that has a case statement in it. We added indexes to the fields being referenced in the case statement, but Oracle doesn't use the indexes. I added hints to the SQL to force it to use the indexes, it still won't do it. I am wondering if the optimizer realizes that the fields are being referenced, since they are inside the case. It wants to do a full table scan each time. I can get it to use an index on the same table, if I specify and index on a field outside of the case. Required information: Oracle Version: 8.1.7.0.0 Platform: Sun Solaris 2.8 Thank you, -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Asynchronous Procedure Calls
That is true, I have figured it out. dbms_job will allow the asynchronous execution of procedures and dbms_pipe allows the communication between the processes to occur. It works. I'm doing it now. The jobs are being kicked off in groups of 10 and they are sending a message back to the calling program via pipes. Each job has it's own pipe, so the main program can keep track of who is done. Currently, I am waiting for all 10 to complete before starting the next 10, but I may work on a way to start the eleventh job when the first one finishes. I'm just glad that I got something to work. Thank you for your help. [EMAIL PROTECTED] wrote: > DBMS_JOB will not solve the problem of > async communications. > > Jared > > "Khedr, Waleed" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 07/01/2002 12:23 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: Asynchronous Procedure Calls > > You need dbms_job(s) > Also make sure you have enough background job processes to handle the > expected maximum number of concurrent procedure calls. > > Regards, > > Waleed > > -Original Message- > Sent: Monday, July 01, 2002 2:20 PM > To: Multiple recipients of list ORACLE-L > > Advanced Queuing will do what you need. > > There are examples at otn.oracle.com > > Jared > > Scott Canaan <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 06/28/2002 01:23 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:Asynchronous Procedure Calls > > I have a need to call a procedure repeatedly and asynchronously. I > am using dbms_pipe for the communication between the calling procedure > and the called procedure and that seems to be working. What I want to > do is call the procedure multiple times, asynchronously, from the main > procedure. The problem is that Oracle waits for each call to complete > before continuing processing. Is there any way to do this in PL/SQL? > My environment is: Oracle 8.1.7.0.0, Sun Solaris 2.8. I need to do > this in PL/SQL because it has to run through Oracle Warehouse Builder. > > Thank you. > > -- > Scott Canaan ([EMAIL PROTECTED]) > (585) 475-7886 > "Life is like a sewer, what you get out of it depends on what you put > into it" - Tom Lehrer > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Scott Canaan > INET: [EMAIL PROTECTED] > > 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: [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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > 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: [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). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services
Re: Stop Store proc from running
In Oracle, find the sid and serial# of the session and do an "alter system kill session" command. That will kill it. It might take awhile to kill, depending on how much rollback it has to do. [EMAIL PROTECTED] wrote: > Hi, > I want to immediately stop a running stored proc.I tried kill -9 pid > . It shows killed. > But procedure is still continuing.. > > Thanks > Manoj -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Cloning Question
I'm sorry, and I should know better. We are on 8.1.7.0.0 on Sun Solaris 2.6. [EMAIL PROTECTED] wrote: > In some versions of Oracle, you need a SECOND rollback segment created in the > SYSTEM tablespace in order to create another tablespace. It can't hurt to add > it (you can drop it immediately after you get the rollback tablespace created) > but it could be the solution. > > Since you didn't include the version of the database you are working with, we > have to be somewhat generic in our answers > > Rachel > > |+---> > || | > || | > || srcdco@ritvax| > || .rit.edu | > || | > || 05/09/2002 | > || 02:28 PM | > || Please | > || respond to | > || ORACLE-L | > || | > |+---> > >| > || > | To: [EMAIL PROTECTED] | > | cc: (bcc: Rachel Carmichael) | > | Subject: Re: Cloning Question| > >| > > I thought there was a rollback segment in system that would be there. It should > be enough to get things started. After all, there isn't a separate one when you > create a database, until you create it. > > DENNIS WILLIAMS wrote: > > > Scott - I think that Rachel offered better advice, and I'm sure you've read > > her note by now. I have some experience with missing files when cloning a > > database :-), but I haven't had the rollback tablespace missing, and that > > would be different. One thought would be to create an extra rollback > > tablespace on production, so that when you perform the clone operation, > > Oracle still has some rollback segments available. > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Thursday, May 09, 2002 12:03 PM > > To: Multiple recipients of list ORACLE-L > > > > Dennis, > > No. I did a create controlfile set database... I commented out the > > rollback_segments line in the init.ora and removed the reference to the file > > in > > the create controlfile statement. With no reference (that I know of) to the > > rollback segments or tablespace, I thought that the database should have > > come > > up, then I could create a new one. I must have missed something, but I > > don't > > know what that was. > > > > DENNIS WILLIAMS wrote: > > > > > Scott - Let's see if I understand specifically what you did. You ran the > > > CREATE DATABASE script that was generated from your production system. > > Now, > > > since the datafile for rollback tablespace isn't there, Oracle will come > > up > > > without it. Once your new instance was up, then you did a DROP TABLESPACE > > on > > > the rollback tablespace, followed by a CREATE TABLESPACE. I've done that > > > scenario quite a few times on Oracle 8.1.6, just yesterday, as a matter of > > > fact (that was a temp tablespace). If those weren't your steps, then > > provide > > > more details. > > > Dennis Williams > > > DBA > > > Lifetouch, Inc. > > > [EMAIL PROTECTED] > > > > > > -Original Message- > > > Sent: Thursday, May 09, 2002 8:48 AM > > > To: Multiple recipients of list ORACLE-L > > > > > > I spent a long time trying to clone our production data warehouse > > > into test, to refresh it. I do this frequently, as both a way to > > > refresh test instances and to test the backups. After fighting through > > > 2 bad backups, I finally got a good one. However, the problem I had was > > > that the production rollback tablespace is larger than the disk on test. > > > > > > My thought was that I could restore everything except the rollback > > > tablespace, which is not the way I usually do it. I commented out the > > > rollback_segments line in the init.ora and created a script that would > > > create a new rollback tablespace and rollback segments, smaller than > > > those in production. This didn't work, even though Oracle support said > > > it should have. When I did the clone, t
Re: Cloning Question
I thought there was a rollback segment in system that would be there. It should be enough to get things started. After all, there isn't a separate one when you create a database, until you create it. DENNIS WILLIAMS wrote: > Scott - I think that Rachel offered better advice, and I'm sure you've read > her note by now. I have some experience with missing files when cloning a > database :-), but I haven't had the rollback tablespace missing, and that > would be different. One thought would be to create an extra rollback > tablespace on production, so that when you perform the clone operation, > Oracle still has some rollback segments available. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Thursday, May 09, 2002 12:03 PM > To: Multiple recipients of list ORACLE-L > > Dennis, > No. I did a create controlfile set database... I commented out the > rollback_segments line in the init.ora and removed the reference to the file > in > the create controlfile statement. With no reference (that I know of) to the > rollback segments or tablespace, I thought that the database should have > come > up, then I could create a new one. I must have missed something, but I > don't > know what that was. > > DENNIS WILLIAMS wrote: > > > Scott - Let's see if I understand specifically what you did. You ran the > > CREATE DATABASE script that was generated from your production system. > Now, > > since the datafile for rollback tablespace isn't there, Oracle will come > up > > without it. Once your new instance was up, then you did a DROP TABLESPACE > on > > the rollback tablespace, followed by a CREATE TABLESPACE. I've done that > > scenario quite a few times on Oracle 8.1.6, just yesterday, as a matter of > > fact (that was a temp tablespace). If those weren't your steps, then > provide > > more details. > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Thursday, May 09, 2002 8:48 AM > > To: Multiple recipients of list ORACLE-L > > > > I spent a long time trying to clone our production data warehouse > > into test, to refresh it. I do this frequently, as both a way to > > refresh test instances and to test the backups. After fighting through > > 2 bad backups, I finally got a good one. However, the problem I had was > > that the production rollback tablespace is larger than the disk on test. > > > > My thought was that I could restore everything except the rollback > > tablespace, which is not the way I usually do it. I commented out the > > rollback_segments line in the init.ora and created a script that would > > create a new rollback tablespace and rollback segments, smaller than > > those in production. This didn't work, even though Oracle support said > > it should have. When I did the clone, the database would not open. I > > kept getting the following error: > > > > ORA-00600: internal error code, arguments: [25012], [1], [2], [], [], > > [], [], [] > > > > Does anyone know what I was doing wrong? I can't figure it out, and > > Oracle support couldn't figure it out, either. I was able to get the > > database up by getting more disk added, so that there was enough space > > to restore the rollback tablespace file. > > > > Thank you. > > > > -- > > Scott Canaan ([EMAIL PROTECTED]) > > (585) 475-7886 > > "Life is like a sewer, what you get out of it depends on what you put > > into it" - Tom Lehrer > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Scott Canaan > > INET: [EMAIL PROTECTED] > > > > 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: [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). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >
Re: EMC Storage Array Issue
Since I started this thread, I thought I'd update everyone on what the problem ended up being. There is a problem with one of the power supplies on the switch in the SAN. The other power supply was not plugged in, so it halted everything occasionally. We plugged the other power supply in, and haven't had the problem since. Now we need to get the power supply replaced. Interesting that EMC tried to blame it on Oracle first. Scott Canaan wrote: > We have implemented a Sun Solaris Cluster (4 machines), connected to > an EMC storage array. The migration began last fall, and we now have 15 > Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We > recently have had 2 occurances of asynchronous I/O wait times exceeded. > When this occurs, every database crashes at the same time. The solution > from EMC is to turn asynchronous I/O off in all of the Oracle instances > (disk_async_io = false) and to increase the database writer slaves > (dbwr_io_slaves = ) to emulate asynchronous I/O. > Has anyone run into this problem before? If so, how did you > "correct" it? My feeling is that EMC is trying to give us a bandage to > cover up the real problem, by trying to get Oracle to ignore it. > > Thank you. > > -- > Scott Canaan ([EMAIL PROTECTED]) > (585) 475-7886 > "Life is like a sewer, what you get out of it depends on what you put > into it" - Tom Lehrer > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Scott Canaan > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: EMC Storage Array Issue
Claudio, I didn't think to mention the process. It is always the ckpt (checkpoint) background process that reports the problem. The database goes down with an ORA-27062. claudio cutelli wrote: > Hi, > which background process had the problem? > because if lgwr, it already write in sync mode ... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, April 15, 2002 5:33 PM > > > We have implemented a Sun Solaris Cluster (4 machines), connected to > > an EMC storage array. The migration began last fall, and we now have 15 > > Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We > > recently have had 2 occurances of asynchronous I/O wait times exceeded. > > When this occurs, every database crashes at the same time. The solution > > from EMC is to turn asynchronous I/O off in all of the Oracle instances > > (disk_async_io = false) and to increase the database writer slaves > > (dbwr_io_slaves = ) to emulate asynchronous I/O. > > Has anyone run into this problem before? If so, how did you > > "correct" it? My feeling is that EMC is trying to give us a bandage to > > cover up the real problem, by trying to get Oracle to ignore it. > > > > Thank you. > > > > -- > > Scott Canaan ([EMAIL PROTECTED]) > > (585) 475-7886 > > "Life is like a sewer, what you get out of it depends on what you put > > into it" - Tom Lehrer > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Scott Canaan > > INET: [EMAIL PROTECTED] > > > > 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: [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). > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: claudio cutelli > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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).
EMC Storage Array Issue
We have implemented a Sun Solaris Cluster (4 machines), connected to an EMC storage array. The migration began last fall, and we now have 15 Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there. We recently have had 2 occurances of asynchronous I/O wait times exceeded. When this occurs, every database crashes at the same time. The solution from EMC is to turn asynchronous I/O off in all of the Oracle instances (disk_async_io = false) and to increase the database writer slaves (dbwr_io_slaves = ) to emulate asynchronous I/O. Has anyone run into this problem before? If so, how did you "correct" it? My feeling is that EMC is trying to give us a bandage to cover up the real problem, by trying to get Oracle to ignore it. Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: DB Link Problem
I always set the global_name manually, with an update statement. It does have to match, or it won't work. Denham Eva wrote: Hello List, Have a problem, Oracle 817 Win3K sp6 Trying to create a DB link between the production and the test dbs. The db_link creates fine ( so it appears). However when you try to run a script to reference the other, I get select count(*) from workorder@maxie * ERROR at line 1: ORA-02085: database link MAXIE connects to MAXTEST.TFMC.CO.ZA I checked out the manual, but it seems as thou I have created the link correctly. I also checked out metalink, which suggested changing the global_name with ALTER DATABASE RENAME global_name TO MAXTEST But this causes the following error: ORA-02019: connection description for remote database not found. Has anyone got any ideas? Is this a bug? TIA Denham This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer
Re: Oracle Hungry for Money
at 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: [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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: MacGregor, Ian A. > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Oracle Hungry for Money
That's what we thought, too. Apparently, it isn't. Actually, what Cameron told me was that our license pre-dates the option, so by default it isn't included. The license was purchased on version 7.2. James Howerton wrote: > Scott, > > We also have a higher ed site liscense, isn't partitioning included in > the "Enterprise Edition"??? > > ...JIM... > > >>> [EMAIL PROTECTED] 3/13/02 1:02:33 PM >>> > Watch out! I just got off the phone with our Oracle "sales rep". He > was asking me if I needed information on Partitioning or OLAP for our > data warehouse project. I told him that we are on 8.1.7, so the OLAP > option isn't available. To keep him from going into a long speil on > Partitioning, I told him that I have already implemented that, which > is > true. > He jumped on that and told me that we aren't licensed for it. He > followed up with sending me a quote for $23,800 to cover the fact that > we are using the option, which we didn't pay for. I was always told > that we have a "site" license (higher ed), and he said that our > license > was purchased prior to Partioning being available, so that doesn't > count. > > I'm telling everyone about this as a heads-up. It appears that Oracle > is digging for money, and I feel that the approach that was used was > done to trick me into admitting that I had implemented the feature. > > -- > Scott Canaan ([EMAIL PROTECTED]) > (585) 475-7886 > "Life is like a sewer, what you get out of it depends on what you put > into it" - Tom Lehrer > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Scott Canaan > INET: [EMAIL PROTECTED] > > 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: [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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: James Howerton > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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).
Oracle Hungry for Money
Watch out! I just got off the phone with our Oracle "sales rep". He was asking me if I needed information on Partitioning or OLAP for our data warehouse project. I told him that we are on 8.1.7, so the OLAP option isn't available. To keep him from going into a long speil on Partitioning, I told him that I have already implemented that, which is true. He jumped on that and told me that we aren't licensed for it. He followed up with sending me a quote for $23,800 to cover the fact that we are using the option, which we didn't pay for. I was always told that we have a "site" license (higher ed), and he said that our license was purchased prior to Partioning being available, so that doesn't count. I'm telling everyone about this as a heads-up. It appears that Oracle is digging for money, and I feel that the approach that was used was done to trick me into admitting that I had implemented the feature. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Riddle me this Oracle riddle...
I believe that varchar2 is a null-terminated string (like in C). Varchar is the string with the byte count at the beginning (like Pascal). "Jamadagni, Rajendra" wrote: > Initially is will be nothing unless test.col2 has a default value as > varchar2 structures are data_length followrd by actual string. The maximum > that p_in_one can have is 200 bytes thought due to its anchored definition. > > The answer, none initially as it will be initializes to NULl value, then > whatever you assign ti it plus 2 bytes to store the length of the actual > string, max size is 200+2 bytes (assuming standard characterset). > > This has no baring on max size of varchar2 because by definition of > p_in-one, its max length is limited to 200. > > Raj > __ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion is an art! > > > Name: ESPN_Disclaimer.txt >ESPN_Disclaimer.txt Type: Plain Text (text/plain) > Encoding: 7BIT -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: using dbms_output.put_line to write out a blank line
You could try:
dbms_output.put_line(chr(13));
"Magaliff, Bill" wrote:
> anyone know how to use dbms_output.put_line to write out a blank line?
>
> tried this: dbms_output.put_line (' '); -- single space between the two
> single quotes
>
> but it doesn't work.
>
> thx
>
> Bill Magaliff
> Framework, Inc.
> 914-631-2322
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Magaliff, Bill
> INET: [EMAIL PROTECTED]
>
> 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: [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).
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it"
- Tom Lehrer
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Canaan
INET: [EMAIL PROTECTED]
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: [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: Dropping table space where name is lower case
Put the tablespace name in double quotes: drop tablespace "spatial"; "Browett, Darren" wrote: > I am unable to drop a tablespace that I created. > > I created the tablespace with a lower case name, when I do a select * from > dba_tablespaces the name > is lowercase as opposed to uppercase. > > When I "drop tablespace spatial" oracle gives the following error message : > > ORA-00959: tablespace 'SPATIAL' does not exist > > This is oracle 8.1.7.2.? > > Thanks > > Darren > > > -- > Darren Browett P.EngThis message > was transmitted > Data Administrator using 100% > recycled electrons > Information and Communication Technology > City of Coquitlam > P:(604)927 - 3614 > E:[EMAIL PROTECTED] > > --- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Browett, Darren > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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 Kernel Memory Parameters Recommendations?
This is what I use: SHMMAX = ½ of physical memory SHMMIN = 1 SHMMNI = 100 SHMSEG = 10 SEMMNI = 100 SEMMSL = 10 + SUM(initsid.ora PROCESSES parameters) SEMMNS = SUM(initsid.ora PROCESSES parameters) + largest initsid.ora PROCESSES parameter + (10 * number of instances) SEMOPM = 100 SEMVMX = 32767 I got the formulas for SEMMSL and SEMMNS from Oracle, via a tar. They aren't the same as the ones in the manual. Also remember to add in semaphore numbers for other applications that may be running on the machine (like Patrol). David Wagoner wrote: Ive read a couple of brief passages about setting the kernel memory parameters in UNIX that are required for an Oracle installation.The information found on MetaLink and in the Oracle 9i installation guide are brief at best and somewhat confusing for a non-UNIX-sys admin. like myself.Would some of you more experienced UNIX/Oracle DBAs please provide a plain English explanation describing your strategy in setting the following 7 parameters in the /etc/system file: SEMMNI SEMMNS SEMMSL SHMMAX SHMMIN SHMMNI SHMSEG To use a simple example, lets say the server has 1 GB of RAM to work with. Thanks in advance for sharing, david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Tel. (919) 466-6723 Fax (919) 466-6783 Mobile (919) 225-4962 [EMAIL PROTECTED] http://www.arsenaldigital.com/ ***NOTICE*** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, work product or exempt from disclosure under applicable law.If you have received this message in error, or are not the named recipient(s), please immediately notify the sender by phone or email and delete this e-mail message from your computer.Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer
Re: wrong result from select
It works fine in 8.1.6.0.0, Sun Solaris 2.6: SQL*Plus: Release 8.1.7.0.0 - Production on Tue Feb 12 09:01:22 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Release 8.1.6.0.0 - Production JServer Release 8.1.6.0.0 - Production SQL> set echo on SQL> alter session set optimizer_mode=choose; Session altered. SQL> alter session set cursor_sharing=force; Session altered. SQL> create table tb1 (f1 number(4)); Table created. SQL> insert into tb1 values (1999); 1 row created. SQL> insert into tb1 values (2000); 1 row created. SQL> insert into tb1 values (2001); 1 row created. SQL> insert into tb1 values (2002); 1 row created. SQL> commit; Commit complete. SQL> select * from tb1; F1 -- 1999 2000 2001 2002 SQL> analyze table tb1 compute statistics; Table analyzed. SQL> select f1 from tb1 where f1 between 2000 and 2000; F1 -- 2000 SQL> select f1 from tb1 where f1 between 2000 and 2001; F1 -- 2000 2001 SQL> select f1 from tb1 where f1 between 2001 and 2000; no rows selected SQL> drop table tb1; Table dropped. SQL> This is the output on 8.1.7.0.0, Sun Solaris 2.6: SQL*Plus: Release 8.1.7.0.0 - Production on Tue Feb 12 09:03:48 2002 (c) Copyright 2000 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL> set echo on SQL> alter session set optimizer_mode=choose; Session altered. SQL> alter session set cursor_sharing=force; Session altered. SQL> create table tb1 (f1 number(4)); Table created. SQL> insert into tb1 values (1999); 1 row created. SQL> insert into tb1 values (2000); 1 row created. SQL> insert into tb1 values (2001); 1 row created. SQL> insert into tb1 values (2002); 1 row created. SQL> commit; Commit complete. SQL> select * from tb1; F1 -- 1999 2000 2001 2002 SQL> analyze table tb1 compute statistics; Table analyzed. SQL> select f1 from tb1 where f1 between 2000 and 2000; F1 -- 2000 SQL> select f1 from tb1 where f1 between 2000 and 2001; F1 -- 2000 2001 SQL> select f1 from tb1 where f1 between 2001 and 2000; no rows selected SQL> drop table tb1; Table dropped. SQL> "Jesse, Rich" wrote: > Same result on 8.1.7.2 32bit on HP 11.0. The good news is that the correct > result is obtained using "...where f1 >= 2000 and f1 <= 2001". > > Is anyone using 8.1.7.3 on HP/UX 11 to test this? > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 08, 2002 4:58 PM > To: Multiple recipients of list ORACLE-L > > Hi, > Can anybody try this on 9i? > set echo on > alter session set optimizer_mode=choose; > alter session set cursor_sharing=force; > create table tb1 (f1 number(4)); > insert into tb1 values (1999); > insert into tb1 values (2000); > insert into tb1 values (2001); > insert into tb1 values (2002); > commit; > select * from tb1; > analyze table tb1 compute statistics; > select f1 from tb1 where f1 between 2000 and 2000; > select f1 from tb1 where f1 between 2000 and 2001; > select f1 from tb1 where f1 between 2001 and 2000; > drop table tb1; > Here is what I got on 8.1.7.2.1 64bit on HP-UX 11.0: > SQL> select * from tb1; > F1 > -- > 1999 > 2000 > 2001 > 2002 > SQL> select f1 from tb1 where f1 between 2000 and 2000; > F1 > -- > 2000 > SQL> select f1 from tb1 where f1 between 2000 and 2001; > F1 > -- > 2000 > SQL> select f1 from tb1 where f1 between 2001 and 2000; > F1 > -- > 2001 > TIA > Alex. > PS. What about cursor_sharing=similar ? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > 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: [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 su
Re: UNION
Try: select a,b,c from tableabc union select d,e,f from tabledef order by 1; Hamid Alavi wrote: > Hi, > > I try to use union and order by first column of first select statment and > also first column of second select statment but get error, Any Idea how to > do this?? > > SELECT A,B,C FROM TABLEABC > UNION > SELECT D,E,F FROM TABLEDEF > ORDER BY A,D > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any attachments is intended > only for the use of the individual or entity to which it is addressed, and > may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from > disclosure under applicable law. If you have received this message in error, > you are prohibited from copying, distributing, or using the information. > Please contact the sender immediately by return e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hamid Alavi > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: index hint
Jeroen, You need to reference the table in the hint with the alias that you gave it in the from clause (oa), then the hint should work. Jeroen van Sluisdam wrote: > > -Oorspronkelijk bericht- > > Van: Jeroen van Sluisdam > > Verzonden:donderdag 17 januari 2002 14:40 > > Aan: '[EMAIL PROTECTED]' > > Onderwerp:index hint > > > > Hi, > > > > I'm on Oracle 7.3.4 HP-UX 10.20 and trying to get some queries working > > again > > on same performance after an index has been added in order to get around > > possible > > deadlocks because of use of a foreign key relation. > > I tried adding an hint but this doesn't work, am I making typos? > > DB is on choose optimizer > > > > delete from plan_table; > > explain plan > > set statement_id = 'test' for > > SELECT /*+ INDEX(OPTION_ALLOTMENTS I_OPTION_ALLOTMENTS_2) */ > > oa.pu_id , oa.contract_id , oa.so_id , oa.medium_id , oa.datetime , > > oa.total_inventory , oa.is_blocked_flag , oa.full , oa.null_is_full , > > oa.option_type > > FROM > > bedfinder_published_objects bo, > > option_allotments oa > > WHERE > > bo.contract_id = oa.contract_id > > AND > > bo.so_id = oa.so_id > > AND > >datetime >= trunc(sysdate) > > ORDER BY 2,3,4,5 > > > > Tia, > > > > Jeroen > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jeroen van Sluisdam > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Sql not exists
Try the minus set operator: select id from table_1 minus select id from table_2; Kimberly Smith wrote: > > Read up on outer joins. > > -Original Message- > Sent: Thursday, October 25, 2001 1:35 AM > To: Multiple recipients of list ORACLE-L > > Hallo you DBA' > > Can anyone give me a good example on a sql select statement checking which > ids exists in table one but not in table two? Table two also contains the > corresponding id field but with other field names besides. Like this > > Table 1: Id Name Year > Table 2: :Id City Country > > Thanks in advance > > Roland Sköldblom > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kimberly Smith > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: QUERY PROBLEM
It depends on what you want to do with this. You need to have an into clause, so declare a variable and put one in. If you want to see the output, then use the dbms_ouput package to display it. Harvinder Singh wrote: > > Hi, > > We need to write a query like this: > > declare > dd number; > begin > select * from t_acc where id_acc=dd; > end; > / > > we r getting obvious error that INTO clause is missing > but we only need to run the query and get the result back. > How can we accomplish this. > > Thanks > -Harvinder > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Harvinder Singh > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Datatype
Ken, The date datatype includes time, down to the second. Ken Janusz wrote: > Is there an Oracle datatype of DATETIME? I can only find DATE in my > documentation. > > Thanks, > > Ken Janusz, CPIM > Database Conversion Lead > Sufficient Systems, Inc. > Minneapolis, MN > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ken Janusz > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Renaming GLOBAL_NAME
I always issue an update statement to change it, when I clone instances: update global_name set global_name = 'SIMSNT7B'; commit; This works every time. [EMAIL PROTECTED] wrote: > Hi All, > > I am trying to rename the global_name from SIMSNT7B.WORLD to SIMSNT7B. > > I issued the following command to change the global_name. > > ALTER DATABASE RENAME GLOBAL_NAME TO SIMSNT7B; > > Still it is showing SIMSNT7B.WORLD when I query the global_name view. > SQL> select * from global_name; > > GLOBAL_NAME > -- > SIMSNT7B.WORLD > > Values for the following parameters in v$parameter view, > GLOBAL_NAMES parameter value is FALSE and DB_DOMAIN parameter value is > NULL. > We are not using Oracle Names server. I renamed SQLNET.ORA file in > network\admin location. > Init.ora file has global_names set to false. > > How do I change to SIMSNT7B? This database is on Windows NT and it is > 8.1.6. > > Thanks in advance for your help. > > Best regards > Prasad > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Subtract 1 month from current date
select add_months(sysdate,-1) from dual; Check the sql and pl/sql manuals. You should have a cd with them on that you can load onto your pc. "Smith, Ron L." wrote: > Can someone tell me how to subtract 1 month from the current date? Also, > where can I find answers and examples to this type of coding question? > > Thanks! > Ron Smith > Database Administrator > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: What happens if you lose the alert log?
!! Please do not post Off Topic to this List !! There is no problem with this. Oracle will just create a new one on the next write. I have a script that moves the alert.log to a backup file every Sunday. "Carle, William T (Bill), NLCIO" wrote: > !! Please do not post Off Topic to this List !! > > Hi, > > I had a situation yesterday where a rogue process wrote millions of > error messages into the alert log. I was able to get rid of the process, > then delete the error messages out. But it would have been quicker to just > blow it away and create a new, empty one. I was concerned as to the effect > that would have on Oracle. Would it bring Oracle down? What is the best way > to handle this? > > Bill Carle > AT&T > Database Administrator > 816-995-3922 > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Carle, William T (Bill), NLCIO > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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).
How to find Procs run?
First, I will say that I will contribute something to keep this list alive. I have benefitted way more from the list than I have given. With that said, I have a request from a customer to do a weekly report on which stored procedures are run and by whom. I have been looking in v_$sql, v_$sqlarea, v_$session, etc. and am having some limited success. The problem is that Oracle doesn't seem to keep any history of what happened in the past, only what the system looks like now. I also tried to create a table to hold the information and have a trigger on one of these views (I also tried the underlying tables), but Oracle won't let me create a trigger on any of these. I don't know where else to go, and I hate to tell a customer that I can't do it, but I'm out of ideas. Anyone here have any? Thank you, -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: OT: Cobol Copybook format
Lisa, These are usually file layouts, in COBOLese. FILLER is usually unused space, as in: first-name pic x(20). filler pic x value space. last-name pic x(30). This is the first name, a space, and the last name. FILLERs usually have a value associated with them, unless they are truly not used, since COBOL does not do a good job of initializing fields (some programmers do it manually by moving spaces to the entire record). If you have any further questions, don't hesitate to ask... "Koivu, Lisa" wrote: Good morning everyone, I have this messy document that is known as a copybook. I've been searching the web to help me understand what the appropriate way to translate this into a table is. If anyone has a link they are willing to share, or is willing to answer questions (like what the heck is FILLER?) please email me directly. Thank you! Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: startup time v7
The julian date is the year plus the day number of the year. Today (Aug. 24, 2001) is 2001236 or 01236, since today is the 236th day of 2001. "Adams, Matthew (GEA, 088130)" wrote: The v$instance table has the following two entries in Oracle7. STARTUP TIME - Julian 2452043 STARTUP TIME - SECONDS 9476 Doing the obligitory RTFM, I find all it says is that STARTUP TIME - Julian is the startup date and time in Julian format. (Thanks oracle, that's big help.) What is the Julian calender? How do you translate this number? Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: OT: cryptography speech
When I was in college, we had a Pascal compiler that would insert code for you. If you left off a semi-colon (the most common mistake), the compiler would issue a warning stating "Missing semi-colon, assumed" and go on its way. This was on a DEC VAX/VMS system in the late 1980's (1985 - 1988). Guy Hammond wrote: > Very dangerous. Like, Captain Kirk might say, "Mr. Spock, cancel the > self destruct sequence" so Mr. Spock goes to his SQL*Plus terminal and > types: > > SQL> ALTER STARSHIP SET AUTODESTRUCT > > But at that moment, Dr McCoy walks in, slips in a puddle of Romulan Ale > and grabs Mr. Spock for support, whose finger slips on to the ENTER key. > The Enterprise replies: > > ERROR at line 1: > ORA-435334: keyword not found where expected, substituting ON to > continue... > > :0) > > g > > -Original Message- > Sent: Thursday, August 16, 2001 3:46 PM > To: Multiple recipients of list ORACLE-L > > Funny. I liked the self-referential acronym bit. I don't like > computers > (or computer languages or OSs) that "know" what I want to do but refuse > to > do it. An example from our own wonderful SQLPlus: > > SQL> select table_name sys.dba_tables; > select table_name sys.dba_tables > * > ERROR at line 1: > ORA-00923: FROM keyword not found where expected > > Now why doesn't it just put the "FROM" in and get on with it? It > "knows" > what's missing!! Is it doing this to embarrass and annoy me or am I > just > being paranoid (and if I'm going to be "nuts" I'd rather be paranoid > than a > single-noid). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Guy Hammond > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: 8.1.6 support cut off?
The desupport notice states 10/31/2001, with extended support until 10/31/2004. It's on metallink. If you are an Oracle Applications customer, then support is extended until 3/1/2002. Mark Leith wrote: > Hi list, > > Does anyone have the "word" on when Oracle plans to "discontinue" support > for Oracle 8.1.6? > > Cheers > > Mark > > === > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > === >http://www.cool-tools.co.uk >Maximising throughput & performance > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: SQL Question
To add to this thread, you can make it only return the second record by changing the statement to: select table_name from dba_tables where table_name like 'EDL\_WORK\_%' escape '\'; This will force the _ character to be used as a literal. Yosi Greenfield wrote: > Darren, > > Just as the % character is a wildcard that matches any number of characters, > the _ character is a wildcard that matches any single character. So it matches > the S in WORKSTATION, and then the % sign matches TATION_LOCATION. > > hth, > > Yosi > > "Browett, Darren" wrote: > > > I have a simple query, but the results are somewhat puzzling > > > > select table_name from dba_tables where table_name like 'EDL_WORK_%' > > and I received the following > > > > TABLE_NAME > > - > > EDL_WORKSTATION_LOCATION > > EDL_WORK_AR_ENTITIES > > > > Why would I be receiving the first record (EDL_WORKSTATION) if I > > try EDL_WORK_A% I get the correct result. > > > > Is there something about the _% combination ? > > > > To solve the problem I used the substr command as part of the where clause. > > > > Darren > > > > > > - > > Darren Browett P.EngThis message was > > transmitted > > Systems Admin/DBA using 100% recycled > > electrons > > Information and Communications Technology. > > City of Coquitlam > > P:(604) 927 - 3614 > > E:[EMAIL PROTECTED] > > > > - > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Browett, Darren > > INET: [EMAIL PROTECTED] > > > > 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: [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). > > -- > Thanks, > > Yosi > > - > Yosi Greenfield > Oracle Certified DBA > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yosi Greenfield > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: OT -- suggestions to ensure nerdiness in potential IT staff
5051 > San Diego, California-- Public Internet access / Mailing Lists > -------- > 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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: SQL*Loader question- Transforming Data
You could try: when (9:12) <> 'UNIX' However, this will only work if you have fixed field lengths in the input file. Jonathan Gennick wrote: > David, > > SQL*Loader probably can't help here, because, unfortunatly, > the WHEN clause is not nearly as flexible as a SQL WHERE > clause. If no other solution presents itself, you could load > the data into a work table and write some PL/SQL code to > filter out the records that you don't want. You're better > of, though, if you can preprocess the file and remove the > records you don't want before you even load the data into > the database. > > Best regards, > > Jonathan Gennick > mailto:[EMAIL PROTECTED] * 906.387.1698 > http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org > > Monday, July 30, 2001, 6:30:51 PM, you wrote: > DW> Thanks for the tips on the 'when' clause. I guess my dilemma is that my > DW> "FLAG_TEXT" is not the only part of the field I want to filter on. For > DW> example, let's say I want to filter out all the transactions containing the > DW> word UNIX. > > DW> aaa,bbb,UNIX45689-2,ccc,ddd > > DW> In this case, I cannot use the 'when' clause like: > > DW> when (field <> 'UNIX') > > DW> I would need something equivalent to the SQL convention of "not like 'UNIX%' > DW> " with the % wildcard. It appears that the 'when' clause is very limited in > DW> this respect. Any suggestions on filtering out part of the text string? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jonathan Gennick > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Date / Time
Sajid, Unfortunately, I ran into the same problem. I didn't find anything to do it for me, either, so I had to write the pl/sql code. It is very long and messy, but can be done. When I did it, I didn't even attempt the days notation. Here is the code that I wrote: date_diff := trans_cur.modified_date - last_date; date_diff_tot := trans_cur.modified_date - first_date; SELECT decode( trunc( date_diff * 24),0, to_char( trunc( date_diff * 1440), 'FM90') || ':' || to_char( round( date_diff * 86400) - trunc( date_diff * 1440) * 60,'FM00'), to_char( trunc( date_diff * 24),'FM90') || ':' || to_char( trunc( date_diff * 1440 - trunc( date_diff * 24) * 60),'FM00') || ':' || to_char( round( date_diff * 86400 - trunc( date_diff * 1440) * 60), 'FM00')), decode( trunc( date_diff_tot * 24), 0, to_char( trunc( date_diff_tot * 1440),'FM90') || ':' || to_char( round( date_diff_tot * 86400) - trunc( date_diff_tot * 1440) * 60,'FM00'), to_char( trunc( date_diff_tot * 24),'FM90') || ':' || to_char( trunc( date_diff_tot * 1440 - trunc( date_diff_tot * 24) * 60),'FM00') || ':' || to_char( round( date_diff_tot * 86400 - trunc( date_diff_tot * 1440) * 60), 'FM00')) INTO elapsed_1, elapsed_2 FROM dual; I hope this helps. Sajid Iqbal wrote: > Hello All > > I want to display the "time elapsed" between two dates - in days, hours, > minutes and seconds. > > If I do "select date1 - date2", the result is : 12.0194907 > > Is there a function that will turn the number of days into something more > legible? Ideally i'd like to do ; > > "to_char(12.0194907,'DD:HH:MI:SS')" but obviously that won't work. Is > there a solution other than writing a complex function myself which will > have to * by 24, / by 60 and substr etc to get the different bits of the > number? > > Please CC any replies directly to me at [EMAIL PROTECTED] > > Thanks in advance, > Saj. > > -- > Sajid Iqbal > Database Team Leader > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sajid Iqbal > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Deadlock Detection
Tom, You should have 2 of these traces, one for each process involved. In this case, the processes are 22, 18 and 24, 27. If you run them through tkprof, they will be more readable, but the information is there. You need to look up the table, based on the resource id that was given under the heading Resource Name. "Mercadante, Thomas F" wrote: > All, > > My current application (still under development) is experiencing Oracle > deadlock problems. The applications people are performing stress testing > where the application is being repeatedly called simulating actual users > hitting the database. > > The application is written using VB thru ADO and COM, Oracle 816 on NT. > > My problem is that, while I can review the trace file produced, I can't > figure out what the actual deadlock is occurring on. I have seen deadlock > trace files that clearly state "table blah", but in this case, I get: > > *** 2001-06-21 14:32:03.841 > *** SESSION ID:(27.31211) 2001-06-21 14:32:03.810 > DEADLOCK DETECTED > Deadlock graph: >-Blocker(s) > -Waiter(s)- > Resource Name process session holds waits process session holds > waits > DX-003b-22 18 X 24 27 > X > session 18: DID 0001-0018-003C session 27: DID 0001-0018-003C > Rows waited on: > Session 27: no row > *** 2001-06-21 14:32:03.857 > ksedmp: internal or fatal error > ORA-00060: deadlock detected while waiting for resource > > Is there something like TKPROF that will process the trace file and give me > more info on what is happening? It looks like I am waiting for a resource > to be freed, but which one is the question. > > thanks for any help. > > Tom Mercadante > Oracle Certified Professional > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: SUMMARY: Thanks everyone - tru64
M INET: [EMAIL PROTECTED] 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: connecting problems: "ORA-12154: Could not resolve servicename"
Mikael, Did you set up the tnsnames.ora on the server? You need that in order to use the @mtipdb_tcp when you connect. If you can connect to the database without the @ clause, then I'd check the tnsnames.ora. Mikael Granhed wrote: > Hi! > > I have just installed Oracle8.06 on SUN/Solaris server. The installation of > the database was successfull. But when I´m checking the connection with the > listener with the command "sqlplus system/manager@mtipdb_tcp". I got the > following error: "ORA-12154: Could not resolve servicename". > > I have also tried to connect to the server from a NT-client and that works > fine. > > It seems to be some problem with the internal connection on the server. > Maybe it is a parameter that is not set correctly? > > Does anybody know what the problem can be? > > Thanks in advance! > > Best regards > Mikael > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mikael Granhed > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: digital tru64 unix
Lisa, We are running Oracle 7.3.4 and 8.1.6 on Compaq (Digital) Tru64 Unix. However, we are in the process of migrating to Sun Solaris. I can try to answer your questions, though. Lisa Koivu wrote: Hello everyone, Anyone out there running Oracle on this flavor of Unix? If so can you please email me directly? I don't have a Unix box to play with and I have a few simple performance questions. I'm also looking in the online doco and I don't see what I'm looking for (yet). Thanks in advance Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: backspace in Oracle.
stty erase ^H The ^H is your backspace key. Ron Rogers wrote: > List, > I have created a test server using Linux 7.1 and Oracle 8.1.7.3 and it works great. >The major problem I am having is "I am NOT a typist" and make errors at the SQL >prompt. What do I set or define in the glogin to allow backspace to work as a >backspace in Oracle? It has been a while since I had the privilege of UNIX ( in any >flavor) > Any info would be appreciated. > Thanks, > ROR mª¿ªm > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ron Rogers > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: SQLLDR Question
Thank you to everyone who responded to my request. I guess it's just a limitation of sqlldr that it can't handle this without modifying the data. Unfortunately, I can't have the source change their download, so I have to deal with the data as I get it. I did come up with a way to get around the problem. I created a text field for the time and created an on-insert trigger that appends the time to the date field and puts it back into the date field. That works at the minimal cost of a few extra bytes per record and a small amount of extra processing time. Here is the trigger that I came up with: TRIGGER rit_cyber_hist_i before insert on rit_cyber_hist for each row begin :new.trans_date := to_date(to_char(:new.trans_date,'mm/dd/yy ') || :new.time_char,'mm/dd/yy hh24:mi'); end; > -Original Message- > Sent: 23 May 2001 22:41 > To: Multiple recipients of list ORACLE-L > > I am trying to load a file that has the fields comma-delimited, > variable length. A sample line from the file looks like this: > > 503,414081660,Success,Auth,AH9042,z,4555,-,-,-,0,05/01/01,14:21 > > The problem I am having is putting the date and time together. The > control file looks like this: > > load data > infile 'cyber_real.dat' > append > into table rit_cyber_hist > when order_id <> 'Order ID' and order_id <> '' > fields terminated by ',' > (order_id, > trans_nbr, > cyber_status, > trans_type, > auth_code, > avs_code, > trans_amt, > cic_resp, > po_nbr, > ship_to_zip, > tax_amt, > trans_date date(14) "mm/dd/yy,hh:mi") > > It ignores the time portion of the file, I presume because it has a > comma before it and it assumes that it is a different field. I can't > figure out any way to get this loaded with the trans_date field > containing both the date and time. > > This is on Oracle 8.1.6.0 on Sun Solaris. > > Any suggestions? Thank you. > > -- > Scott Canaan ([EMAIL PROTECTED]) > (716) 475-7886 > "Life is like a sewer, what you get out of it depends on what you put > into it" - Tom Lehrer > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Scott Canaan > INET: [EMAIL PROTECTED] > > 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: [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). > > ___ > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented are > solely those of the author and do not necessarily represent those of > Sema. > If you are not the intended recipient, be advised that you have received this > email in error and that any use, dissemination, forwarding, printing, or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the Sema UK > Helpdesk by telephone on +44 (0) 121 627 5600. > ___ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: FOX, Simon > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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).
SQLLDR Question
I am trying to load a file that has the fields comma-delimited, variable length. A sample line from the file looks like this: 503,414081660,Success,Auth,AH9042,z,4555,-,-,-,0,05/01/01,14:21 The problem I am having is putting the date and time together. The control file looks like this: load data infile 'cyber_real.dat' append into table rit_cyber_hist when order_id <> 'Order ID' and order_id <> '' fields terminated by ',' (order_id, trans_nbr, cyber_status, trans_type, auth_code, avs_code, trans_amt, cic_resp, po_nbr, ship_to_zip, tax_amt, trans_date date(14) "mm/dd/yy,hh:mi") It ignores the time portion of the file, I presume because it has a comma before it and it assumes that it is a different field. I can't figure out any way to get this loaded with the trans_date field containing both the date and time. This is on Oracle 8.1.6.0 on Sun Solaris. Any suggestions? Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: does oracle supports oracle 8.1.7. on sun solaris 8 (64bit) - pro
According to a presentation by an Oracle "salesperson" at the last Upstate New York Oracle User's Group meeting (held at Oracle in Rochester), Oracle no longer develops on Sun. They have changed their development platform to HP-UX. "Boivin, Patrice J" wrote: > I am confused again... I thought Oracle was developed on solaris, then > ported to the other UNIX flavours? > > I would have expected them to have the latest version available for solaris > before any other OS. > > Although lately they seem to be putting the emphasis on development for NT, > which confuses me even more. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services| Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > -Original Message- > From: paquette stephane [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, May 15, 2001 2:20 PM > To: Multiple recipients of list ORACLE-L > Subject:Re: does oracle supports oracle 8.1.7. on sun > solaris 8 (64bit) - pro > > Oracle 817 is not available yet on Solaris. > I asked Oracle support a while ago and they told me it > would be for the beginning of may. > > I check yesterday at Oracle store and it was not > available. > > I'll probably go for the 817 32bit. > > --- Narender Akula <[EMAIL PROTECTED]> a > écrit : > > > hi Gurus, > > > > I would like know wheather oracle supports oracle > > 8.1.7. on sun solaris 8 > > (64bit) ? Where do i find more info.I searched in > > product life cycle in > > metalink.. i could not find much info.. > > can some body tell or where to look. > > what are the pros and cons ? does any body had > > problems or issues after > > upgrade the OS from 7 to 8 ? > > > > > narender.akula > > > http://www.terralinkltd.com > > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Narender Akula > > INET: [EMAIL PROTECTED] > > > > 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: [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). > > = > Stéphane Paquette > DBA Oracle, consultant entrepôt de données > Oracle DBA, datawarehouse consultant > [EMAIL PROTECTED] > > ___ > Do You Yahoo!? -- Pour faire vos courses sur le Net, > Yahoo! Shopping : http://fr.shopping.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?paquette=20stephane?= > INET: [EMAIL PROTECTED] > > 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: [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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (85
Re: Drop schema and all related objects
Try drop user cascade; Mujeeb Chowdhry wrote: > Hi DBA's, > > How can I drop schema (user and all it's objects). I have one main user in the >application and wants to drop user and all related objects. Can anyone help me in >this regard. > Thanks > Mujeeb Chowdhry > Oracle DBA > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mujeeb Chowdhry > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Why is there air?
Actually, the way Bill Cosby says it is: Any phys ed major knows why there's air: to blow up basketballs, footballs, and soccer balls. Ron Rogers wrote: > To fill a Basket Ball!!! > > >>> [EMAIL PROTECTED] 03/22/01 06:35PM >>> > Jared, > I am still waiting/hoping for an answer... > Why IS there air? > - Donna > > - > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ron Rogers > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Offtopic: Canada and America
If you are going to visit Rochester and Buffalo, then you should make the short trip to Jamestown and Chautauqua, especially during the summer when the season is in full swing at Chautauqua. Lucy fans can visit the Lucy-Desi Museum in Jamestown. "Thater, William" wrote: > Ari D Kaplan wrote: > > > > Upstate NY is great - Buffalo, Niagara Falls, Syracuse, and the best place > > in the world: COOPERSTOWN. > > > > (For those not familiar with baseball, this is the Baseball Hall of Fame). > > > > -Ari > > and the Kodak museum in rochester, and the eversion museum [housed in an > award wining building by I.M.Pei] in syracuse, and the finger lakse > wineries and > > damn i've lived here too long.;-) > > -- > > Bill Thater Certifiable ORACLE DBA > Telergy, Inc [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work! > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Can Oracle7 and Oracle8 co-exist?
Ben, This is no problem. They don't need to have different owners. If you are running Oracle Applications 10.7, and you want to use an Oracle 8i instance to house it, then you must do this type of install. You will have 2 Oracle homes, each with it's own database listener and all associated files. They will be installed in separate directories, by default. You will need to have a way to setup your environment when you login to pick the Oracle home you want to use and setup all of the environment variables correctly. Ben Poels wrote: > Hi, > > I want to install Oracle 8.1.7 on the same > AIX 4.3.2 box which is already running > Oracle 7.3.4.5. I will use a separate Oracle > owner and Oracle home for the new 8.1.7 software. > > Has anybody had any problems with these two > versions co-existing on the same platform? > I have them both installed now but before > I spend a lot of time trying to break it I > thought I'd check to see whether or not this > has worked out at other sites. > > Thanks, > > Ben Poels > Queen's University > Kingston, Ontario > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ben Poels > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Last Fri. of the Month ?
Didn't we just do this one? select next_day(last_day(sysdate) - 7, 'fri') from dual; VIVEK_SHARMA wrote: > Given Any Date , How to Deduce the Date for the Last Fri. of the SAME Month > ? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > 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: [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). -- Scott Canaan ([EMAIL PROTECTED]) "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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: Doubt about charecter
Use 'AAA_#989', the _ means any 1 character substitution. Eriovaldo do Carmo Andrietta wrote: I have a problem where in a statment of sql the DB Oracle doesn´t get the line in the follow situation : select name from table1 where field = 'AAA #989'; I think that between A and # exist some strange character that i can´t identify it .. How can I do it ? Regards Eriovaldo -- Scott Canaan ([EMAIL PROTECTED]) "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [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).
