RE: How to select data from a LONG datatype
I hope the question is pertaining to using long column in where clause.
Try this
-
declare
cursor c0 is
select view_name,text
from user_views;
Cview_name varchar2(30);
Ltextlong;
begin
open c0;
loop
fetch c0 into Cview_name,Ltext;
exit when c0%notfound;
if Ltext like '%/*%' then
dbms_output.put_line('View Name : '||Cview_name);
end if;
end loop;
close c0;
end;
/
-
U can use this in SQL, One way is PL/SQL.
This PL/SQL can be used to insert all such view names into a temp table
then u can display text for these views using a select command.
Don't forget to set the size of long using
set long 1000
I hope this answers ur question.
Bye
- Harsh
-Original Message-
Sent: Friday, July 20, 2001 1:41 AM
To: Multiple recipients of list ORACLE-L
How do I get past the inconsistent datatypes error on the following?
select *
from dba_views
where owner = 'SA'
andtext like '%/*%';
We have some views that were migrated from 7.3.4 to 8.0.5 and
we suspect
that we
lost our hints in the migration and upgrade. I want to find which views
had hints in the old system so that I can bring them forward.
Rodd Holman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rodd Holman
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: Harsh Agrawal
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: Backup script giving error when run by cron
Manivannan, I would still put into your script (shutdown.sh) alongwith your ORACLE_SID variable etc. the following lines. ORACLE_HOME=/absolute_path_name_of Oracle_home export ORACLE_HOME PATH=$PATH:$ORACLE_HOME/bin export PATH Give it a try !! Lee -Original Message- Sent: 20 July 2001 07:25 To: Multiple recipients of list ORACLE-L Hi Gurus, Posting again.. Actually the .profile runs thro okay.. But the svrmgrl command given in the shutdown script doesn't run.. It says svrmgrl - not found. I'm running the cron from the dba user. But still the environment is not set. What should I do?? thanks in advance, Manivannan.M Begin Included Message Sent: Wed, 18 Jul 2001 23:40:30 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Hi gurus, Our database is running on Dynix in a Sequent machine. I tried to put the startup/shutdown script we use in crontab and schedule it. I call a script shut.sh which in turn will call the shutdown.sh script. But it gives me an error saying svrmgrl- not found. I've given here those scripts.. What am I missing?? This shut.sh is called by the cron shut.sh /data23/tbms/.profile /data21/app/oracle/admin/TBMS/dba/shutdown.sh /data21/app/oracle/admin/TBMS/db a/shut.log 2/data21/app/oracle/admin/TBMS/dba/shut.err - shutdown.sh --- ORACLE_SID=TBMS export ORACLE_SID INITIAL_STATUS=`ps -ef|grep ora_[a-z]*_TBMS|wc -l` echo $INITIAL_STATUS if [ $INITIAL_STATUS != 0 ]; then svrmgrl EOF connect internal alter system switch logfile; shutdown immediate; exit EOF DB_STATUS=`ps -ef|grep oracleTBMS` if [ -n $DB_STATUS ]; then echo Starting up the database in restrict mode svrmgrl EOF connect internal startup restrict; shutdown ; exit EOF echo Database TBMS shutdown else echo Error in shutting down database exit fi else echo Database is already shutdown..exiting exit fi - regards, Manivannan.M Enjoy being an Indyan at http://www.indya.com -- 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). End Included Message Enjoy being an Indyan at http://www.indya.com -- 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: procedure error
You need in the stored procedure this stmt: pragma restrict_references (name of function, WNDS [, WNPS] [, RNDS] [, RNPS]); where: WNDS means writes no database state (does not modify database tables) WNPS means writes no package state (does not change the values of packaged variables) RNDS means reads no database state (does not query database tables) RNPS means reads no package state (does not reference the values of packaged variables) Regards. PS:This is since 7.X. --- Steve Sapovits [EMAIL PROTECTED] wrote: I have a DB instance (B) that's a snapshot of another (A). Taking a stored procedure that runs fine on A to B as part of a query (a function really I guess?) produces this error: DBD::Oracle::db prepare failed: ORA-06571: Function GET_EVENT does not guarantee not to update database Any idea what causes this and how to fix it? B may be a version behind A. A is 8i. Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Sapovits 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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).
Upgrading from 10.7 to 11.x
Hi All, What are the pre-requisites to be taken , when upgrading from Oracle applications 10.7sc to 11.x. suggest some points or links (url's) pl. Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi 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: RE: Backup script giving error when run by cron - Solved
Hi list, Lee's suggestion worked... Thanks to all the guys who gave suggestions. regards, Manivannan Muthukrishnan. Enjoy being an Indyan at http://www.indya.com -- 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).
Fw: Upgrading from 10.7 to 11.x
Hi All, What are the pre-requisites to be taken , when upgrading from Oracle applications 10.7sc to 11.x. suggest some points or links (url's) pl. Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi 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: Error conecting by svrmgrl
For deleting a services: first, just in case, you should export the registry, then erase the entry related with the name of the service from HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/ About your problem, why don't you set the ORACLE_SID on the HOME of the version you are using and on the MS-DOS screen try with a set LOCAL=ORACLE_SID. Regards. --- Eca Eca [EMAIL PROTECTED] wrote: Friends : I have a database Oracle installed in NT. I have deleted the service and rebuild it again. Now, when I try to connect in the database using svrmgrl i received a error message. Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors.For further details, turn on tracing and re-execute the operation. Turn off tracing when the operation is complete. What can i do for correct it ? Where is this address ? and What can I do for delete the services that aren't being used in NT ? Regards Eriovaldo _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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 8 Question
If it's / or /tmp, then yes, your machine could well become unusable until it gets some free space. If your archive log disk fills, Oracle will refuse transactions until there is free space. Read the man page for 'quota' to help you limit the possibility of this. And think about switching autoextend off. Cheers, g -Original Message- Sent: Thursday, July 19, 2001 4:10 PM To: Multiple recipients of list ORACLE-L Hi all, A friend of mine is having a problem so I thought I would ask all of you experts a quick question. On a Solaris 8 box running 8.1.7, if a partition fills up, will it crash the box? I know that on NT this is very possible depending on pagefile and what file is filling up the partition. But I don't know anything about Sun. Thanks alot:) Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: 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).
RE: Another programming standard falls
See, I don't get it. Microsoft bundle a bunch of stuff with their OS, and the anti-MS camp complain about Microsoft's so-called monopoly (or monopolistic practices, which aren't the same thing). And then Microsoft don't bundle some stuff with their OS, and the exact same people start complaining again... about what exactly? You can still download Java onto Windows easily, it's no big deal, what is the problem here? g -Original Message- Sent: Wednesday, July 18, 2001 8:23 PM To: Multiple recipients of list ORACLE-L Microsoft dropping Java code from Windows XP In the wake of a January legal settlement with Java owner Sun Microsystems, Microsoft plans to ship its Windows XP operating system without the code needed to run Java applications. http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62358_NLTAM%2C00.html -- 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: 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).
Re: [Q] does Personal ORACLE 8.1.7 support Win98?
the problem are: 1. it did not create DB. 2. no "lsnrctl.exe" Thanks. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: [Q] does Personal ORACLE 8.1.7 support Win98? Date: Thu, 19 Jul 2001 05:40:43 -0800 Yes it is. I have it installed and it works fine. What problems are you havging Rick -- 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). Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 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 make PL/SQL wait for 60 seconds
I want to put a sleep or wait in my PL/SQL function Is there an easy way to do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Quest s/w
Well, we use Toad - great - and SQLab Vision - not so great - the version we got on CD didn't cover 8.1.7 so we had to download the latest version; it still doesn't really understand 'new' features like function-based indexes; it has a tendency to fall over on really serious SQL; and the 'advice' is often irrelevant (and its GUI, but thats probably my unix/dba predudices coming out). Regards David Lord -Original Message- Sent: 19 July 2001 23:53 To: Multiple recipients of list ORACLE-L Wow. Doesn't ANYBODY out there use Quest's Live Reorg? I haven't heard from anyone except folks asking me to share what I hear. If nobody uses this software, that sounds like a ringing anti-endorsement! Comments? And no I'm not flame-baiting. I wanna hear what people have to say about this product. Thanx, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Lord, David - CS 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).
pls help..
hi list, can anyone pls explain it. i've found a datafile related to a new tablespace TABSPACE_2 ( not created by me) in v$datafile view. the path of datafile is also ambiguous.. i.e. something like.. DISKA:TABSPACE_FILE2.DAT no full path is shown.. and also i could'nt find the file on my system. this is surprising me a lot.. the TS is shown created on yesterday and is of 20 mb in size. how do i figure out, why is it so. how do it came here with such file location. i've 815 on NT pls suggest. thanks. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Re: Locally managed tablespaces
consider this also.. if u make a tablespace as LMT, the SMON process is not going to coalesce it automatically.. as it in the case of dictionary managed TS. if i'm wrong.. pls correct. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 5:16 AM Yes, you can make any tablespace a locally-managed tablespace except SYSTEM. What they're saying, I think, is that you can't set up temporary tablespaces and shouldn't set up rollback segments with the AUTOALLOCATE allocation management. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 4:32 PM I was pretty sure you could use it for any TS but SYSTEM. Is this documented? Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Thu, 19 Jul 2001 09:32:27 Hillman, Alex wrote: You canuse any storage parameters you like but oracle will ignore them exept for initial for LMT with autoallocate. I would personally do not use autoallocate. Also you cannot use autoallocate for temporary tablespace and shouldn't use it for rollback. Alex Hillman -Original Message- Sent: Thursday, July 19, 2001 12:43 PM To: Multiple recipients of list ORACLE-L HPUX 11i 64 bit Oracle 8.1.7.1 32 bit I am creating a new database and decided to go with locally managed tablespaces. I was going to go with autoallocate because the best I can tell the only possible drawback with this is a little wasted space. However, I was under the impression that you could not specify a next in the storage clause of a table creation. Yet you can. So what happens if I have a next defined? Do they pretty much just throw that away or should I really not define it? Kimberly Smith Database Administrator IT Dept. - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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: Jon Walthour 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: Saurabh Sharma
RE: some thing strange with user_tables vs real table
or even on 7.X or 8.X if you are logged as the owner: rename old table to new table --- Mark Leith [EMAIL PROTECTED] wrote: Just a note - SQLServer 7 also uses this extremley poor feature! The easiest way to get around it - if you are on 8i - is just to: alter table table_name rename to TABLE_NAME; Mark -Original Message- Sent: Thursday, July 19, 2001 10:41 To: Multiple recipients of list ORACLE-L Welcome to the joy of Access. Access will import into Oracle non sql-compliant objects such as this. If you query select count(*) from tmp_april; you should get a result. To fix this, create your objects in Oracle first. Then attach the Oracle objects to your Access database. Use a copy append to select all the records from the Access table into the Oracle table. Then go slap your developers and tell them NEVER EXPORT ACCESS OBJECTS DIRECTLY TO ORACLE Rodd Holman Original Message On 7/19/01, 3:32:25 PM, Ari, Rama [EMAIL PROTECTED] wrote regarding some thing strange with user_tables vs real table: One of our programmer had imported a table from ACESS database. When I query user_tables I get following result. SQL select table_name from user_tables where table_name= 'TMP_APRIL' no rows selected SQL select table_name from user_tables where table_name= 'tmp_april' TABLE_NAME -- tmp_april When I query tmp_april table I get following result. SQL select count(*) from tmp_april; select count(*) from tmp_april * ERROR at line 1: ORA-00942: table or view does not exist SQL select count(*) from TMP_APRIL; select count(*) from tmp_april * ERROR at line 1: ORA-00942: table or view does not exist For some reason, table name has been stored as tmp_april (lower case). When we create table it supposed to store table name with upper case. Did any one had similar kind of problem? Thanks in Advance, Rama Ari Database Administrator [EMAIL PROTECTED] 610.964.5128 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ari, Rama 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: Rodd Holman 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: 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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
Re: Locally managed tablespaces
That's kind of the point -- in an LMT the free space is managed by bitmap. If it's contiguous in the bitmap it's contiguous, so if you free two adjacent blocks then they're already coalesced, nothing for SMON to do. That's their advantage -- no overhead for coalesce and no overhead for creating dictionary rows to manage free space. Saurabh Sharma wrote: consider this also.. if u make a tablespace as LMT, the SMON process is not going to coalesce it automatically.. as it in the case of dictionary managed TS. if i'm wrong.. pls correct. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 5:16 AM Yes, you can make any tablespace a locally-managed tablespace except SYSTEM. What they're saying, I think, is that you can't set up temporary tablespaces and shouldn't set up rollback segments with the AUTOALLOCATE allocation management. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 4:32 PM I was pretty sure you could use it for any TS but SYSTEM. Is this documented? Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Thu, 19 Jul 2001 09:32:27 Hillman, Alex wrote: You canuse any storage parameters you like but oracle will ignore them exept for initial for LMT with autoallocate. I would personally do not use autoallocate. Also you cannot use autoallocate for temporary tablespace and shouldn't use it for rollback. Alex Hillman -Original Message- Sent: Thursday, July 19, 2001 12:43 PM To: Multiple recipients of list ORACLE-L HPUX 11i 64 bit Oracle 8.1.7.1 32 bit I am creating a new database and decided to go with locally managed tablespaces. I was going to go with autoallocate because the best I can tell the only possible drawback with this is a little wasted space. However, I was under the impression that you could not specify a next in the storage clause of a table creation. Yet you can. So what happens if I have a next defined? Do they pretty much just throw that away or should I really not define it? Kimberly Smith Database Administrator IT Dept. - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing
Re: pls help..
It sounds like someone made a datafile on a raw disk. [EMAIL PROTECTED] 07/20/01 08:46AM hi list, can anyone pls explain it. i've found a datafile related to a new tablespace TABSPACE_2 ( not created by me) in v$datafile view. the path of datafile is also ambiguous.. i.e. something like.. DISKA:TABSPACE_FILE2.DAT no full path is shown.. and also i could'nt find the file on my system. this is surprising me a lot.. the TS is shown created on yesterday and is of 20 mb in size. how do i figure out, why is it so. how do it came here with such file location. i've 815 on NT pls suggest. thanks. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html This electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] It is O'Brien Gere's policy to respect the privacy of its employees and third parties communicating with O'Brien Gere via e-mail. However, the O'Brien Gere e-mail system may not be used for any illegal purposes or for the transmission of material that is libelous, vulgar, obscene, invasive of another's privacy, unlawful, harassing, abusive, threatening, harmful, or otherwise objectionable [objectionable material]. This includes anything that may infringe on the intellectual property or rights of another. O'Brien Gere may monitor communications but is under no obligation to do so. O'Brien Gere may, in our absolute discretion, remove, block or filter any material if in our view it is objectionable material or otherwise inappropriate. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein 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: how to make PL/SQL wait for 60 seconds
The following code would sleep for 60 seconds. declare val number; begin val := 60; DBMS_LOCK.sleep(t); end; [EMAIL PROTECTED] 07/20/01 08:46AM I want to put a sleep or wait in my PL/SQL function Is there an easy way to do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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 electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] It is O'Brien Gere's policy to respect the privacy of its employees and third parties communicating with O'Brien Gere via e-mail. However, the O'Brien Gere e-mail system may not be used for any illegal purposes or for the transmission of material that is libelous, vulgar, obscene, invasive of another's privacy, unlawful, harassing, abusive, threatening, harmful, or otherwise objectionable [objectionable material]. This includes anything that may infringe on the intellectual property or rights of another. O'Brien Gere may monitor communications but is under no obligation to do so. O'Brien Gere may, in our absolute discretion, remove, block or filter any material if in our view it is objectionable material or otherwise inappropriate. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein 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[2]:re: [Questions about Oracle World Wide Support] / Re:
Rachel, Wasn't talking about you. Let's just say it's a Financial firm with offices in Merrimack NH. Almost went to work for them, glad I did not!! Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 7/19/2001 1:55 PM nah, this was a LONG time ago... and we had all sorts of other fun to deal with with the licenses too. but it's a thought From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:re: [Questions about Oracle World Wide Support] / Re: ORA Date: Thu, 19 Jul 2001 13:01:07 -0800 Rachel, You can always do as a local firm around here does, namely byt a server license, enjoy the year of support. And then some years later when you decide to upgrade to the next version, buy that license, in the new version, all over again. Seems rather foolish and costly, but then they have money to burn. Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 7/19/2001 12:21 PM Eric, Where you been Welcome back. Be aware that if you do not pay for continuing support, and then you later (years later) decide you need a suport contract again *for the platform you started on*, Oracle has been known to retroactively charge (at a percentage at least 50%?) for the years of missed support. nasty surprise. try 100%... you have to pay for the support as if you had had it. If you work for a big enough company, it's possible to negotiate a settlement and pay less (I did it, but it took me 6 months to work it out). Oh, and if you don't have support, you can always just pay for an Oracle Consultant to come in and help you -- at a VERY high rate. Rachel _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
urgent pls...PL/SQL problem..
hi list, i'm conerting my old db structure into a new one with entirely different constraints, references, etc.. the new structure holds many new tables some splitted from old ones with few new columns. and like. now i want to move my old data into this new one. i 'm doing it through pl/sql, writing procedures, etc. now my problem is i've a master table for skills. and a detailed table referencing it. previously the detailed table stores the values with no ref. to the master, now it is storing the code corresponding the master value. i want to compare the old detailed table and old master table's values to fetch the code from the master table. when i try to fetch this through cursor, the values containing null in detailed tableare returning error.. while rest going fine. how do i treat the nulls, the nvl(col,'0') to convert nulls to 0 is also not working. any idea. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
RE: Exp/Imp - suppress screen output?
run the script in background export.sh import.sh -Original Message- Sent: 20 July 2001 14:15 To: Multiple recipients of list ORACLE-L Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: Ramasamy, Baskar 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: Locally managed tablespaces
It does not need to do it. Also SMON will coalesce only if pctincrease0 and this is not a good idea. Alex Hillman -Original Message- Sent: Friday, July 20, 2001 8:41 AM To: Multiple recipients of list ORACLE-L consider this also.. if u make a tablespace as LMT, the SMON process is not going to coalesce it automatically.. as it in the case of dictionary managed TS. if i'm wrong.. pls correct. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 5:16 AM Yes, you can make any tablespace a locally-managed tablespace except SYSTEM. What they're saying, I think, is that you can't set up temporary tablespaces and shouldn't set up rollback segments with the AUTOALLOCATE allocation management. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 4:32 PM I was pretty sure you could use it for any TS but SYSTEM. Is this documented? Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Thu, 19 Jul 2001 09:32:27 Hillman, Alex wrote: You canuse any storage parameters you like but oracle will ignore them exept for initial for LMT with autoallocate. I would personally do not use autoallocate. Also you cannot use autoallocate for temporary tablespace and shouldn't use it for rollback. Alex Hillman -Original Message- Sent: Thursday, July 19, 2001 12:43 PM To: Multiple recipients of list ORACLE-L HPUX 11i 64 bit Oracle 8.1.7.1 32 bit I am creating a new database and decided to go with locally managed tablespaces. I was going to go with autoallocate because the best I can tell the only possible drawback with this is a little wasted space. However, I was under the impression that you could not specify a next in the storage clause of a table creation. Yet you can. So what happens if I have a next defined? Do they pretty much just throw that away or should I really not define it? Kimberly Smith Database Administrator IT Dept. - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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: Jon Walthour 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
Re: how to make PL/SQL wait for 60 seconds
use procedure dbms_lock.sleep Gints Plivna John Dunn john.dunn@seTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] fas.co.uk cc: Sent by: Subject: how to make PL/SQL wait for 60 seconds root@fatcity. com 2001.07.20 14:46 Please respond to ORACLE-L I want to put a sleep or wait in my PL/SQL function Is there an easy way to do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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).
Re: how to make PL/SQL wait for 60 seconds
Hi John, SQL desc dbms_lock [snip] PROCEDURE SLEEP Argument Name TypeIn/Out Default? -- --- -- SECONDSNUMBER IN Hope this helps, Paul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 8:46 AM I want to put a sleep or wait in my PL/SQL function Is there an easy way to do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Paul Vallee 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: Exp/Imp - suppress screen output?
Why 1 /dev/null 2dev/null and not just /dev/null -Original Message- Surendra Sent: Friday, July 20, 2001 10:15 AM To: Multiple recipients of list ORACLE-L use this.. exp usn/pwd all your other parameters 1/dev/null 2dev/null Suren -Original Message- Sent: Friday, July 20, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: Tirumala, Surendra 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: Michael E. Cupp, Jr. 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: [Q] does Personal ORACLE 8.1.7 support Win98?
I had the same problem- my Personal Oracle 8.1.7 installation hung up during creation of the test database on Win98. David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0695 Email mailto:[EMAIL PROTECTED] Web 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 at (919) 941-4645 and delete this e-mail message from your computer. Thank you. -Original Message- From: ef 8454 [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 8:11 AM To: Multiple recipients of list ORACLE-L Subject: Re: [Q] does Personal ORACLE 8.1.7 support Win98? the problem are: 1. it did not create DB. 2. no lsnrctl.exe Thanks. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: [Q] does Personal ORACLE 8.1.7 support Win98? Date: Thu, 19 Jul 2001 05:40:43 -0800 Yes it is. I have it installed and it works fine. What problems are you havging Rick -- 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). Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 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: How to select data from a LONG datatype
Title: RE: How to select data from a LONG datatype Ketan, CONTAINS() is an Intermedia operator and will blow an error if no Intermedia index exists on the column that is indexed. Rodd, unfortunately I think you'll have to resort to PL/SQL. You'd have to split the LONG field into the 32K varchar2 chunk and substr() it. We are making the (possibly wrong) assumption that any view definition is less than 32K long. Metalink goes on to say that you can manipulate the full length of a long via JDBC (note 123009.1) and Pro*C (1007848.6). I claim ignorance on both I know this isn't good news and it's possible that others on the list have a better idea. Lisa Koivu Lawn Maintenance Technician (and DBA) Ft. Lauderdale, FL, USA -Original Message- From: Ketan Patel [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 2:01 AM To: Multiple recipients of list ORACLE-L Subject: Re: How to select data from a LONG datatype Hi, For long data type in selection use contains instead of like. Before this set environment for sql*plus like set long 5000 . --- Rodd Holman [EMAIL PROTECTED] wrote: How do I get past the inconsistent datatypes error on the following? select * from dba_views where owner = 'SA' and text like '%/*%'; We have some views that were migrated from 7.3.4 to 8.0.5 and we suspect that we lost our hints in the migration and upgrade. I want to find which views had hints in the old system so that I can bring them forward. Rodd Holman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ketan Patel 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: Connectivity problems through IIS server.
hi while connecting to oracle thro' ASP, u need to specify the TNSname. as far as i know the tnsname is case sensative(when using with ASP) so plz check the tnsname entry. also check the same with dsn entries.. hope this helps .. thanks and regards ! Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -Original Message- Behalf Of Naik, Sandesh S Sent: Thursday, July 19, 2001 8:10 PM To: Multiple recipients of list ORACLE-L Dear List, One of our developers is getting following error while trying to connect using IIS Server (4.0) to oracle Database 8.1.6.2.0. I think he is using ASP program to connect to database. I am able to connect though sqlplus.exe from that machine but not through the IIS Server connection. Is there anything else you have to set in IIS server to get right tnsnames.ora Can you help? The error message: Microsoft OLE DB Provider for Oracle error '80004005' ORA-12154: TNS:could not resolve service name /getdate.asp, line 33 Thanks Sandesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naik, Sandesh S 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: shirish 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).
Long running Analyze
I still don't have a good idea how long an Analyze compute should take on a 35gig database. This is a 7.3.4 database with no activity other than the Analyze. The full Analyze is taking about 9 hours to complete. If I use estimate at 25% on the data and compute on the indexes it takes about 6 hours. Does this seem normal? Is there any way to speed it up? Thanks! Ron -- 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).
Re:RE: Another programming standard falls
Guy, Must be because your in the UK where it has not been front page news like here. The problem with Jave and Sun revolves around MicroSoft creating language extensions for their Visual J++ that would only work on Windows and Internet Explorer. That was why Sun went after MicroSoft since the original intent was to create a programming language that would be platform independent but MS was making things platform dependent. A VERY old MicroSoft thing. Now they have been slapped, so like any other spoiled kid they've decided to take their ball and go home, namely they are not shipping/installing a JVM in XP and Visual J++ is now history. With any luck they'll stay there too. BTW: Any of you heard about MS's .net strategy? I've a letter from the Gates on my desk about it. Seems according to that letter you guys will be able to create XML based services that I can include in my applications. Now I wonder how long you'll let me do that without paying you a royalty?? According to the Gates, forever. Dick Goulet Reply Separator Author: Guy Hammond [EMAIL PROTECTED] Date: 7/20/2001 2:00 AM See, I don't get it. Microsoft bundle a bunch of stuff with their OS, and the anti-MS camp complain about Microsoft's so-called monopoly (or monopolistic practices, which aren't the same thing). And then Microsoft don't bundle some stuff with their OS, and the exact same people start complaining again... about what exactly? You can still download Java onto Windows easily, it's no big deal, what is the problem here? g -Original Message- Sent: Wednesday, July 18, 2001 8:23 PM To: Multiple recipients of list ORACLE-L Microsoft dropping Java code from Windows XP In the wake of a January legal settlement with Java owner Sun Microsystems, Microsoft plans to ship its Windows XP operating system without the code needed to run Java applications. http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62358_NLTAM%2C00.html -- 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: 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). -- 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).
Re: ora-1031 when connect internal or / as sysdba locally
Check your $ORACLE_HOME/rdbms/audit directory. If it is full, you will get this error, as every time you try to login to svrmgrl connect connect internal, a .aud file is created here. Terry Chuan Zhang wrote: Dear all,I have this problem. When connect internal or connect /as sysdba in svrmgrl, it gives me insufficient priviledge. I connect it locally instead of remotly. I have not set up any password file or os authentication. It works well last week and suddenly happens today when I want to shutdown the db. The unix account I log into is in dba group which was created when Oracle software was installed. I already asked everybody related. Nobody touched any system stuff. Has anyone experienced this before? It's on Sun Solaris 2.7 and oracle EE8.0.6. Thanks for your advice. Chuan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball 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: Exp/Imp - suppress screen output?
W, Run the export with 'nohup' and optionally redirecting the 'standard error' and 'standard out' to another file. nohup exp ... or nohup exp ... 21 junk.log In the first case screen output will be redirected (default) to 'nohup.out' file. In the second case it is redirected to the junk.log file. HTH.. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Walter K [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 8:15 AM To: Multiple recipients of list ORACLE-L Subject: Exp/Imp - suppress screen output? Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: Deshpande, Kirti 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: [Q] does Personal ORACLE 8.1.7 support Win98?
Search your Personal Oracle CD and look for the readme file. Follow the instructions and it should work fine. The reason I say look at the readme is, I had problems initially and I was able to resolve them through the readme. Hope this helps. Rick -- 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).
RE: Quest s/w
and I've worked with StorageXpert and it's great... easy to use, understand and install. And damagement really likes the equalizers -- immediately visual image of what is happening From: Lord, David - CS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Quest s/w Date: Fri, 20 Jul 2001 04:15:45 -0800 Well, we use Toad - great - and SQLab Vision - not so great - the version we got on CD didn't cover 8.1.7 so we had to download the latest version; it still doesn't really understand 'new' features like function-based indexes; it has a tendency to fall over on really serious SQL; and the 'advice' is often irrelevant (and its GUI, but thats probably my unix/dba predudices coming out). Regards David Lord -Original Message- Sent: 19 July 2001 23:53 To: Multiple recipients of list ORACLE-L Wow. Doesn't ANYBODY out there use Quest's Live Reorg? I haven't heard from anyone except folks asking me to share what I hear. If nobody uses this software, that sounds like a ringing anti-endorsement! Comments? And no I'm not flame-baiting. I wanna hear what people have to say about this product. Thanx, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Lord, David - CS 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: how to make PL/SQL wait for 60 seconds
Sounds like you need to be using MS SQL Server, it has plenty of wait functions. Especially random waits. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 20, 2001 8:46 AM To: Multiple recipients of list ORACLE-L I want to put a sleep or wait in my PL/SQL function Is there an easy way to do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Christopher Spence 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: Quest s/w
I am not a big fan of Toad, it is expensive and has a bunch of pretty things, but not much pratical. PL/SQL Developer is a great product, much more pratical and a lot cheaper. As low as $50/user compared to $750. The company is great, I have dealt with their support very closely over the last 3 years and they have proved to be one of the best I have seen. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 20, 2001 8:16 AM To: Multiple recipients of list ORACLE-L Well, we use Toad - great - and SQLab Vision - not so great - the version we got on CD didn't cover 8.1.7 so we had to download the latest version; it still doesn't really understand 'new' features like function-based indexes; it has a tendency to fall over on really serious SQL; and the 'advice' is often irrelevant (and its GUI, but thats probably my unix/dba predudices coming out). Regards David Lord -Original Message- Sent: 19 July 2001 23:53 To: Multiple recipients of list ORACLE-L Wow. Doesn't ANYBODY out there use Quest's Live Reorg? I haven't heard from anyone except folks asking me to share what I hear. If nobody uses this software, that sounds like a ringing anti-endorsement! Comments? And no I'm not flame-baiting. I wanna hear what people have to say about this product. Thanx, Mike --- === Michael P. Vergara | I've got a PBS mind in an MTV world Oracle DBA | Guidant Corporation | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: Lord, David - CS 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: Christopher Spence 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: Exp/Imp - suppress screen output?
1 is standard output 2 is standard error -Original Message- From: Michael E. Cupp, Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 10:41 AM To: Multiple recipients of list ORACLE-L Subject: RE: Exp/Imp - suppress screen output? Why 1 /dev/null 2dev/null and not just /dev/null -Original Message- Surendra Sent: Friday, July 20, 2001 10:15 AM To: Multiple recipients of list ORACLE-L use this.. exp usn/pwd all your other parameters 1/dev/null 2dev/null Suren -Original Message- Sent: Friday, July 20, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: Tirumala, Surendra 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: Michael E. Cupp, Jr. 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: Anderson, Brian 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: Locally managed tablespaces
SMON only coalesces tablespaces with a non-zero percent increase. And current philosophy is to make all extents in a tablespace the same size anyway, so coalescing becomes a non-issue. From: Saurabh Sharma [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Locally managed tablespaces Date: Fri, 20 Jul 2001 04:40:49 -0800 consider this also.. if u make a tablespace as LMT, the SMON process is not going to coalesce it automatically.. as it in the case of dictionary managed TS. if i'm wrong.. pls correct. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 5:16 AM Yes, you can make any tablespace a locally-managed tablespace except SYSTEM. What they're saying, I think, is that you can't set up temporary tablespaces and shouldn't set up rollback segments with the AUTOALLOCATE allocation management. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 4:32 PM I was pretty sure you could use it for any TS but SYSTEM. Is this documented? Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Thu, 19 Jul 2001 09:32:27 Hillman, Alex wrote: You canuse any storage parameters you like but oracle will ignore them exept for initial for LMT with autoallocate. I would personally do not use autoallocate. Also you cannot use autoallocate for temporary tablespace and shouldn't use it for rollback. Alex Hillman -Original Message- Sent: Thursday, July 19, 2001 12:43 PM To: Multiple recipients of list ORACLE-L HPUX 11i 64 bit Oracle 8.1.7.1 32 bit I am creating a new database and decided to go with locally managed tablespaces. I was going to go with autoallocate because the best I can tell the only possible drawback with this is a little wasted space. However, I was under the impression that you could not specify a next in the storage clause of a table creation. Yet you can. So what happens if I have a next defined? Do they pretty much just throw that away or should I really not define it? Kimberly Smith Database Administrator IT Dept. - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA 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: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
Re: how to make PL/SQL wait for 60 seconds
On Jul 20, 2001 at 04:46:13AM, John Dunn wrote: I want to put a sleep or wait in my PL/SQL function Is there an easy way to do this? dbms_lock procedure sleep(seconds in number); -- Suspend the session for the specified period of time. -- Input parameters: --seconds -- In seconds, currently the maximum resolution is in hundreths of -- a second (e.g., 1.00, 1.01, .99 are all legal and distinct values). -- Vladimir Begun | Falling in love is a lot like dying. You http://vbegun.net/ | never get to do it enough to become good at http://vbegun.net/wap/ | it. [EMAIL PROTECTED]| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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: Exp/Imp - suppress screen output?
You can code it like this: exp / tables=mike mike.log 21 output is in mike.log -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth 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: Scripts for tuning in 8.1.6
si, todo listo Ramón Estévez *809-565-3121 x 225 * [EMAIL PROTECTED] -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Christopher Spence Enviado el: Thursday, 19 July, 2001 9:22 AM Para: Multiple recipients of list ORACLE-L Asunto: RE: Scripts for tuning in 8.1.6 www.ixora.com.au has many many scripts for such tasks. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 17, 2001 10:05 PM To: Multiple recipients of list ORACLE-L Hi Friends : Does anyone have some good prepared scripts for tuning in database. And how to use it in Linux ? I know that it is necessary to run several times and to calculate some statistics using the result of the queries. Regards Eriovaldo _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: Christopher Spence 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: Ramon Estevez 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: Exp/Imp - suppress screen output?
Why 1 /dev/null 2dev/null and not just /dev/null -Original Message- Surendra Sent: Friday, July 20, 2001 10:15 AM To: Multiple recipients of list ORACLE-L use this.. exp usn/pwd all your other parameters 1/dev/null 2dev/null Suren -Original Message- Sent: Friday, July 20, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: Tirumala, Surendra 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: Michael E. Cupp, Jr. 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: Michael E. Cupp, Jr. 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: BaanIVc with Oracle
Raghu, We're on 8.0.6. with BaanIVc4. Baan does support 8i (They don't seem to care much about release numbers. If 8.1 is supported, then 8.1.5, 8.1.6 and 8.1.7 are supported). I haven't heard anything on 9.* yet. But IIRC they were rather late with 8i, so don't expect anything soon. Greetings, Frank -Original Message- From: Raghu Kota [mailto:[EMAIL PROTECTED]] Sent: dinsdag 17 juli 2001 21:30 To: Multiple recipients of list ORACLE-L Subject: BaanIVc with Oracle Hi Friends What is highest version of Oracle with BaanIVc4?? Any ideas? We are thinking to upgrade our Baan and Oracle7 on AIX v4.3 Thanks Raghu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kuijten, F. (Frank) 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).
Extent allocation
Hi All, Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files and each file is on a different disk, can extents be allocated from each file in sequence ? As I understand, Oracle will fill one file and then go onto the next file. Cheers, Ade -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe 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: Long running Analyze
Title: RE: Long running Analyze Ron, I don't know what your goal is here so my suggestions may be incorrect. Why are you analyzing the entire db? Aren't there any static tables (and associated indexes) that you can omit from the analyze? It will be more analyze statements instead of just one to accomplish the task, but it may reduce the time you spend doing it. Maybe a full analyze once a week on the weekend or something will cut it along with daily less accurate analyzes for non-static tables. How big is your host? Remember, analyze is pretty cpu intensive. Have you tried manually analyzing in parallel (analyze 3 tables at a time, or write three scripts to run simultaneously)? If you are after the big question, WHY... I'm sorry. All I can say is BECAUSE. hth Lisa Koivu Mrs. Captain Morgan (and DBA) Ft. Lauderdale, FL, USA -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 10:22 AM To: Multiple recipients of list ORACLE-L Subject: Long running Analyze I still don't have a good idea how long an Analyze compute should take on a 35gig database. This is a 7.3.4 database with no activity other than the Analyze. The full Analyze is taking about 9 hours to complete. If I use estimate at 25% on the data and compute on the indexes it takes about 6 hours. Does this seem normal? Is there any way to speed it up? Thanks! Ron -- 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).
RE: Instance down
Seema, A casual search on Metalink for the quoted error text found an answer as below: Subject: Re : Database crashed with message :CKPT: terminating instance due to error 1110 Can you determine what operation(s) where ongoing at the time of the error? Perhaps changing a tablespace to read-write from read-only? There is bug 1486630 where you can get this error sequence when changing a tablespace back to read-write. It may help to add the following event in your init file to dump a more detailed trace file when the error occurs again event = 1110 trace name errorstack level 10 Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 11:01 AM To: Multiple recipients of list ORACLE-L Subject: Instance down Hi My instance is down and I found the following error message in alert log file CKPT:terminating instance due to error 1110 Let me know what could be reason. Thanks -Seema _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
lsnrctl options
Where can I find out what syntax options there are for lsnrctl? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Exp/Imp - suppress screen output?
Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null 1 is stdout and 2 is stderr. you need to redirect both to clear it off the screen. -- Bill Shrek 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).
Re: AutoExtend
One of the alternatives: sys.filext$. You could find the others in sys.dba_data_files, with increment_by, etc... Regards. --- Michael E. Cupp, Jr. [EMAIL PROTECTED] wrote: How can I determine if tablespaces are set up in autoextend? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael E. Cupp, Jr. 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Instance down
It could be a hardware (disk) error. Check with the sys admin to see if all your filesystems are ok. -Original Message- Sent: Friday, July 20, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Hi My instance is down and I found the following error message in alert log file CKPT:terminating instance due to error 1110 Let me know what could be reason. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo 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: AutoExtend
You mean the datafiles within the tablespaces are set up with autoextend. In version 8, there will be a view sys.filext$ created to show what files are set up with autoextend. View will not exist (or return 0 rows) if none set with autoextend. In version = 8 check column 'autoextensible' in the view dba_data_files. It will have 'NO' or 'YES' to tell you. HTH, Regards. - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Michael E. Cupp, Jr. [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 10:51 AM To: Multiple recipients of list ORACLE-L Subject: AutoExtend How can I determine if tablespaces are set up in autoextend? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael E. Cupp, Jr. INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
Update question - a little newbie
Hi, I have several tables in a tablespace. Every real (used) table has a clone table in another tablespace with the same field structure. What I have to do periodically, with example: Real Table: cNumcName -- 1 First 2 Second 3 Third 4 Forth 5 Fifth Clone Table: cNumcName -- 1 First 2 Second 4 Forth 5 Fifth 6 Sixth 1.Delete all rows that are in real tables that are not in the clone tables ( delete Third) 2.Update the real tables with the rows of the clone tables ( update First,Second,Forth,Fifth) 3.Insert into real tables the valus that are in clone tables but not in real tables ( insert Sixth) Unfortunatelly I can't use Truncate and then Insert Into RealTable(Select * from CloneTable); due to database charteristics ( there are tables that overlappes each other) so I have to use Update to do this. For there are many real and clone tables I'd like to make an efficient procedure that can do the whole thing. Can you send me some sample code how to make the update? I have tried to make Cursors with 'for update' but it seems too rigid for me: 1. in Update statement I have to fill the Set colums e.g. I can't use Set RealTable.* = 'values' 2. If I have a cursor: CURSOR MyCursor IS SELECT * FROM RealTable,CloneTable Where RealTable.Column1 = CloneTable.Column1 FOR UPDATE ; I get the error: PLS-00402 alias required in SELECT list of cursor to avoid duplicate column names. That's correct since the two tables has the same structure. Thank you for your help Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: I still can't install Oracle on Linux - help
Hi, Thank you for your help. The problem is I can't download the 1.1.8 Java from www.blackdown.org because every link responds with 'Server not available' or something like this. Can you send it to my e-mail address? ( [EMAIL PROTECTED]) Thank you very much Zsolt Csillag, Hungary At 09:56 2001.07.18. -0800, you wrote: The Java that comes with Oracle is broke. Sorry. Here's how you can make it work, at least it did for me using SuSE 7.1 and Oracle 8.1.7. Get the 1.1.8 Java from www.blackdown.org Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: lsnrctl options
John Dunn wrote: Where can I find out what syntax options there are for lsnrctl? John lsnrctl help or am i missing something obvious here?;-) -- Bill Shrek 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).
RE: Instance down due to error 1242
Ora-1242 is a media error, I would check the checkpoint process trace file for other symptons. Also look for other process id's in the trace file. Can you restart the database? I suspect you are going to have to do a restore. I am going to guess you are not in archive log mode due to the error message. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 20, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi My database is down with following error. CKPT:terminating instance due to error 1242 What could be reason let me know.I am using 8.1.7 on solaris Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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: Exp/Imp - suppress screen output?
Or also 1/dev/null 21 That says direct stdout to /dev/null and make stderr the same as stdout. That's Bourne/Korn shell syntax. csh is different. -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: Exp/Imp - suppress screen output? Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null 1 is stdout and 2 is stderr. you need to redirect both to clear it off the screen. -- Bill Shrek 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Sapovits 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: lsnrctl options
Start lsnrctl and then type help that will show you the command that are available. Also from the lsnrctl prompt type the command you have in question and type help. ROR mª¿ªm [EMAIL PROTECTED] 07/20/01 01:07PM Where can I find out what syntax options there are for lsnrctl? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: 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).
RE: Long running Analyze
Lisa, Your 'BECAUSE' is really a practical issue. I was also thinking same way since this issue is being discussed for a week now. In practice, we must know what tables are being changed or having activities like inserts/deletes and make a script(s) for such tables to analyze in parallel from different time specailly off-peak time and when those tables are not in use leaving aside all such static tables or inactive tables reducing time to analyze and CPU usage... If you don't mind can I ask one question. What about your name change to Mrs. Captain Morgan (and DBA)?. I think Lisa Rutland(if I am not wrong) was more beautiful. MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 20 Jul 2001 08:50:29 -0800 Ron, I don't know what your goal is here so my suggestions may be incorrect. Why are you analyzing the entire db? Aren't there any static tables (and associated indexes) that you can omit from the analyze? It will be more analyze statements instead of just one to accomplish the task, but it may reduce the time you spend doing it. Maybe a full analyze once a week on the weekend or something will cut it along with daily less accurate analyzes for non-static tables. How big is your host? Remember, analyze is pretty cpu intensive. Have you tried manually analyzing in parallel (analyze 3 tables at a time, or write three scripts to run simultaneously)? If you are after the big question, WHY... I'm sorry. All I can say is BECAUSE. hth Lisa Koivu Mrs. Captain Morgan (and DBA) Ft. Lauderdale, FL, USA -Original Message- From:Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent:Friday, July 20, 2001 10:22 AM To: Multiple recipients of list ORACLE-L Subject: Long running Analyze I still don't have a good idea how long an Analyze compute should take on a 35gig database. This is a 7.3.4 database with no activity other than the Analyze. The full Analyze is taking about 9 hours to complete. If I use estimate at 25% on the data and compute on the indexes it takes about 6 hours. Does this seem normal? Is there any way to speed it up? Thanks! Ron -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: AutoExtend
Michael, Login as a dba user and execute the following query. select tablespace_name, file_name, autoextensible from dba_data_files order by tablespace_name; You will see either - YES or NO under autoextensible column. Rao [EMAIL PROTECTED] -Original Message- Sent: Friday, July 20, 2001 11:51 AM To: Multiple recipients of list ORACLE-L How can I determine if tablespaces are set up in autoextend? -- Author: Michael E. Cupp, Jr. INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara 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: Instance down
Check bug note: bug 1486630 and Note 1063607.6 for possible causes. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 20, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Hi My instance is down and I found the following error message in alert log file CKPT:terminating instance due to error 1110 Let me know what could be reason. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence 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: lsnrctl options
type 'lsnrctl' on prompt and then type help and you will see all available option of your version of listener... MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 20 Jul 2001 09:07:50 -0800 Where can I find out what syntax options there are for lsnrctl? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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 Long running Analyze
Lisa, I'm glad to see that you have traded the lawn mower for the spiced rum... 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).
RE: Instance down
The other error you got, 1110, is also media related. It should be point to the bad file in question. $ oerr ora 1110 01110, 0, data file %s: '%s' // *Cause: Reporting file name for details of another error // *Action: See associated error message $ -Original Message- Sent: Friday, July 20, 2001 12:13 PM To: Multiple recipients of list ORACLE-L It could be a hardware (disk) error. Check with the sys admin to see if all your filesystems are ok. -Original Message- Sent: Friday, July 20, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Hi My instance is down and I found the following error message in alert log file CKPT:terminating instance due to error 1110 Let me know what could be reason. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo 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: Kevin Lange 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).
setting DbName in SQL*PLUS
Has anyone ever worked on setting the DbName as the sqlprompt in SQL*PLUS thru glogin.sql? Shailesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yadav, Shailesh 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: lsnrctl options
The Net8 Administrators Guide may help some too... From: Mohammad Rafiq [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: lsnrctl options Date: Fri, 20 Jul 2001 09:26:22 -0800 type 'lsnrctl' on prompt and then type help and you will see all available option of your version of listener... MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 20 Jul 2001 09:07:50 -0800 Where can I find out what syntax options there are for lsnrctl? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough 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).
WinNT / 8.0.5 / Import anomaly, or is it?
From out of nowhere, I started getting the 'ORA-01658: unable to create INITIAL extent for segment ...' error for only SOME indexes on my index tablespace when doing a simple import. Export was done without compression. I rechecked INITIAL extent sizes and true to my expectations they were small 665K. I didn't want to go through precreating the tables with appropriate sizes because I felt it was not the issue in the first place. As a last resort I restarted the database and everything went back to normal again. Can anybody have an explanation for this? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: Extent allocation
On Jul 20, 2001 at 07:50:44AM, Adrian Roe wrote: Hi All, Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files and each file is on a different disk, can extents be allocated from each file in sequence ? As I understand, Oracle will fill one file and then go onto the next file. Try this http://vbegun.net/oramag/extents_allocation/round_robin.sql Inform me please if it's helpful. Thanks. Have a nice weekend. -- Vladimir Begun | I think $[ is more like a coelacanth than a http://vbegun.net/ | mastadon. http://vbegun.net/wap/ | -- Larry Wall in [EMAIL PROTECTED]| [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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: Long running Analyze
It takes me 1hr for a 10gb data index schema using analyze compute. It takes 3mins for a 270gb blob schema using anayze compute. OS AIX 4.3.3 Oracle 8.1.7 EE. [EMAIL PROTECTED] 07/20/01 10:21AM I still don't have a good idea how long an Analyze compute should take on a 35gig database. This is a 7.3.4 database with no activity other than the Analyze. The full Analyze is taking about 9 hours to complete. If I use estimate at 25% on the data and compute on the indexes it takes about 6 hours. Does this seem normal? Is there any way to speed it up? Thanks! Ron -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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).
Moving table with interMedia datatype
Title: Moving table with interMedia datatype Hi - I have a table that contains 1 column with an interMedia datatype (ordsys.ordimage) and a blob column. I want to move the data from the table in our test server to our production server. I don't think an exp and imp will work on these datatypes. Does anyone know how I can accomplish this? Thanks in advance, Lisa
OT - toxic carpet glue fun, etc / (Fwd) RE: [Questions ...-- Volume 2001, Number 200-- Welcome b
Rachel folks, fyi: --- Forwarded message follows --- ... This is the summer of Win2000 and Developer6i/Oracle8i training I went nomail for vacation a while ago (and then family sick leave when my kids, 3 years and 7 years old, got summer colds/asthma), and didn't go back on the list since it was a zoo around here when I came back. We had construction and an office move, including moving/upgrading PCLAN stuff, that got ugly for a while (users having multiple moves to temporary locations when they got sick from exposure to toxic carpet glue, etc.) We drove telecom the campus network engineer crazy with wiring problems, subnetting, DHCP and all that. Next is reinstalling everything that we just did on new PCs! But, the PC/Win/LAN RD guys are having big problems with NT printer drivers and the new IBM NetVistas! After being away, it *is* hard to go back to trying to read all the Oracle-L list, too much stuff. ... --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: AutoExtend
You look in the table sys.file$. -Original Message- From: Michael E. Cupp, Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Subject: AutoExtend How can I determine if tablespaces are set up in autoextend? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael E. Cupp, Jr. 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: Gogala, Mladen 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: WinNT / 8.0.5 / Import anomaly, or is it?
The tablespace was fragmented. Restarting the database caused it to coalesce your tablespaces. You could have issued 'alter tablespace mytbs coalesce;' for each tablespace before running the import. Jay [EMAIL PROTECTED] 07/20/01 02:55PM From out of nowhere, I started getting the 'ORA-01658: unable to create INITIAL extent for segment ...' error for only SOME indexes on my index tablespace when doing a simple import. Export was done without compression. I rechecked INITIAL extent sizes and true to my expectations they were small 665K. I didn't want to go through precreating the tables with appropriate sizes because I felt it was not the issue in the first place. As a last resort I restarted the database and everything went back to normal again. Can anybody have an explanation for this? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: Jay Hostetter 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: Exp/Imp - suppress screen output?
Or 21 /dev/null (One less character to type) -Original Message- Sent: July 20, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Or also 1/dev/null 21 That says direct stdout to /dev/null and make stderr the same as stdout. That's Bourne/Korn shell syntax. csh is different. -Original Message- From: Thater, William [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: Exp/Imp - suppress screen output? Michael E. Cupp, Jr. wrote: Why 1 /dev/null 2dev/null and not just /dev/null 1 is stdout and 2 is stderr. you need to redirect both to clear it off the screen. -- Bill Shrek 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Sapovits 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: 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).
Vulnerability Discovered in OID
Dam the buffers, another overflow! http://otn.oracle.com/deploy/security/pdf/oid_cert_bof.pdf === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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 do I control NEXT parameter in the table....
Hi All, My database report says that for couple of tables (in the same tablespace) The NEXT (storage parameter) is greater than the available space in the tablespace. Actually I have more free space in the tablespace (may be they are not continues). I don't want to add another datafile to the tablespace. By simply reducing the NEXT and PCTINCREASE storage parameter value can I solve this problem? or do I have to recreate the table?. Can anyone tell me how do I resolve this problem by not adding new datafile.. Thanks in advance Uday winmail.dat
RE: OT Long running Analyze
Title: RE: OT Long running Analyze Ron, I do those together :) -Original Message- From: Ron Rogers [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 1:36 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT Long running Analyze Lisa, I'm glad to see that you have traded the lawn mower for the spiced rum... 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).
sql help --urgent
I have a table with a number column(Col A).I want to display A-1.There could be some negative values in this A-1 column.But I want to display 0 whereever negative value appears.I can use the ROUND(A-1) but this will round the other positive value to the next positve integer which I don't want to happen. select a,a-1,round(a-1) from t; AA-1 ROUND(A-1) - -- -- 3 2 2 1 0 0 .6-.4 0 .8-.2 0 6 5 5 3.52.5 3 .69 -.31 0 2.71.7 2 sum 10.29--this value is the sum of all the negative and positive numbers I want the o/p to be like this.The decimal numbers should not be rounded off to the next number. select a,a-1,round(a-1) from t; AA-1 MY REQUIREMENT - -- -- 3 2 2 1 0 0 .6-.4 0 .8-.2 0 6 5 5 3.52.5 2.5 .69 -.31 0 2.71.7 1.7 Sum 11.2(My REQUIREMENT) My requirement is to compute the sum of the columns for exact value i.e I want the sum of only the positive numbers(negative numbers should not be counted for the sum that's why I want to display 0 for negative value as the sum function adds all the positive and negative numbers) How can I do this Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja 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: AutoExtend
Select distinct tablespace_name from dba_data_files where autoextensible = 'YES'; Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 20, 2001 11:51 AM To: Multiple recipients of list ORACLE-L How can I determine if tablespaces are set up in autoextend? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael E. Cupp, Jr. 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: Christopher Spence 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: private/public rollbacks
They are the same without using Parallel server. But public ones will auto matically be brought online without specifying in the INIT.ORA Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, July 16, 2001 2:06 PM To: Multiple recipients of list ORACLE-L Hi List, Who can tell me what advantages/disadvantages of having private rollback segments versus public rollback segments? Thank you. Lyuda Hoska -- 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: Christopher Spence 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: Extent allocation
Adrian, As Vladimir showed in the sql script using the ALTER TABLE ... ALLOCATE EXTENT... works great. I have tablespaces across multiple datafiles and of course they are not used up completely before a table's next will not fit in the free space of the datafile. You have to change the next extent size to fit the free space and then ALLOCATE the extend to the table before you do the dataload. You end up with datafiles used to the max and no wasted free space at the end of the datafile. The method described in the round_robin.sql is a method of loading different data loads into different datafiles. Works great. ROR mª¿ªm [EMAIL PROTECTED] 07/20/01 03:06PM On Jul 20, 2001 at 07:50:44AM, Adrian Roe wrote: Hi All, Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files and each file is on a different disk, can extents be allocated from each file in sequence ? As I understand, Oracle will fill one file and then go onto the next file. Try this http://vbegun.net/oramag/extents_allocation/round_robin.sql Inform me please if it's helpful. Thanks. Have a nice weekend. -- Vladimir Begun | I think $[ is more like a coelacanth than a http://vbegun.net/ | mastadon. http://vbegun.net/wap/ | -- Larry Wall in [EMAIL PROTECTED]| [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun 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: 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).
RE: Extent allocation
Manual allocation of extents, it is called Oracle Striping. It is generally rarely used and most people tend to use raid to handle it. But is a very plausable techinique, as long as you can keep up with the extent allocation. I don't know of any way that automates this process. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 20, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Hi All, Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files and each file is on a different disk, can extents be allocated from each file in sequence ? As I understand, Oracle will fill one file and then go onto the next file. Cheers, Ade -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe 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: Christopher Spence 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: Extent allocation
Manual allocation of extents, it is called Oracle Striping. It is generally rarely used and most people tend to use raid to handle it. But is a very plausable techinique, as long as you can keep up with the extent allocation. I don't know of any way that automates this process. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 20, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Hi All, Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files and each file is on a different disk, can extents be allocated from each file in sequence ? As I understand, Oracle will fill one file and then go onto the next file. Cheers, Ade -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe 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: Christopher Spence 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: How do I control NEXT parameter in the table....
number 1, make pctincrease 0 number 2. alter table tablename storage(next some other number); joe Uday C Basavaraj wrote: Hi All, My database report says that for couple of tables (in the same tablespace) The NEXT (storage parameter) is greater than the available space in the tablespace. Actually I have more free space in the tablespace (may be they are not continues). I don't want to add another datafile to the tablespace. By simply reducing the NEXT and PCTINCREASE storage parameter value can I solve this problem? or do I have to recreate the table?. Can anyone tell me how do I resolve this problem by not adding new datafile.. Thanks in advance Uday Name: winmail.dat winmail.datType: application/ms-tnef Encoding: 7bit -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: AutoExtend
Here is a very good script to show you alot about your datafiles. If Max Auto Extend is 0, then autoextend is on. (All due credit to the author of the script, as it is unknown to me). -start script set linesize 132 set pagesize 59 column filename for a55 column tablespace for a15 column cur heading Data|File|Size justify right column used heading Tot|Used|Space justify right column max heading Max|Auto|Extend justify right column inc heading Auto|Extend|Increm justify right column ext heading No Of|Free|Extnts justify right column hifre heading High|Free|Extent justify right column totfre heading Tot|Free|Space justify right select d.tablespace_name tablespace, d.file_name filename, to_char((d.blocks * 8192) /1048576,'9,999')||'M' cur, to_char( ((d.blocks * 8192)/1048576)-(sum(s.bytes/1048576)),'9,999' )||'M' used, to_char((decode(f.maxextend,null,0,f.maxextend) * 8192) /1048576,'999,999')||'M' max, to_char((decode(f.inc,null,0,f.inc) * 8192) /1048576,'9,999')||'M' inc, to_char(count(*),'9,999') ext, to_char(max(s.bytes)/1048576,'9,999')||'M' hifre, to_char(sum(s.bytes)/1048576,'9,999')||'M' totfre from sys.dba_data_files d,sys.filext$ f,sys.dba_free_space s where (d.file_id = f.file#(+) and s.file_id = d.file_id) and not (d.blocks = f.maxextend(+)) group by d.tablespace_name,d.file_name,d.blocks,f.maxextend,f.inc / quit -end script -Original Message- Cupp, Jr. Sent: Friday, July 20, 2001 11:51 AM To: Multiple recipients of list ORACLE-L How can I determine if tablespaces are set up in autoextend? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael E. Cupp, Jr. 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: Glenn Travis 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 help --urgent
decode(sign(a), -1, 0, a) Ron Thomas Hypercom, Inc [EMAIL PROTECTED] I'm too sexy for my code. - Awk Sed Fred ravindra@sent ica.com To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: sql help --urgent com 07/20/01 12:40 PM Please respond to ORACLE-L I have a table with a number column(Col A).I want to display A-1.There could be some negative values in this A-1 column.But I want to display 0 whereever negative value appears.I can use the ROUND(A-1) but this will round the other positive value to the next positve integer which I don't want to happen. select a,a-1,round(a-1) from t; AA-1 ROUND(A-1) - -- -- 3 2 2 1 0 0 .6-.4 0 .8-.2 0 6 5 5 3.52.5 3 .69 -.31 0 2.71.7 2 sum 10.29--this value is the sum of all the negative and positive numbers I want the o/p to be like this.The decimal numbers should not be rounded off to the next number. select a,a-1,round(a-1) from t; AA-1 MY REQUIREMENT - -- -- 3 2 2 1 0 0 .6-.4 0 .8-.2 0 6 5 5 3.52.5 2.5 .69 -.31 0 2.71.7 1.7 Sum 11.2(My REQUIREMENT) My requirement is to compute the sum of the columns for exact value i.e I want the sum of only the positive numbers(negative numbers should not be counted for the sum that's why I want to display 0 for negative value as the sum function adds all the positive and negative numbers) How can I do this Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja 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: Ron Thomas 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 help --urgent
select sum(column) where column 0 or try a decode -Original Message- Basavaraja Sent: Friday, July 20, 2001 3:41 PM To: Multiple recipients of list ORACLE-L I have a table with a number column(Col A).I want to display A-1.There could be some negative values in this A-1 column.But I want to display 0 whereever negative value appears.I can use the ROUND(A-1) but this will round the other positive value to the next positve integer which I don't want to happen. select a,a-1,round(a-1) from t; AA-1 ROUND(A-1) - -- -- 3 2 2 1 0 0 .6-.4 0 .8-.2 0 6 5 5 3.52.5 3 .69 -.31 0 2.71.7 2 sum 10.29--this value is the sum of all the negative and positive numbers I want the o/p to be like this.The decimal numbers should not be rounded off to the next number. select a,a-1,round(a-1) from t; AA-1 MY REQUIREMENT - -- -- 3 2 2 1 0 0 .6-.4 0 .8-.2 0 6 5 5 3.52.5 2.5 .69 -.31 0 2.71.7 1.7 Sum 11.2(My REQUIREMENT) My requirement is to compute the sum of the columns for exact value i.e I want the sum of only the positive numbers(negative numbers should not be counted for the sum that's why I want to display 0 for negative value as the sum function adds all the positive and negative numbers) How can I do this Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja 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: Michael E. Cupp, Jr. 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).
SDU and TDU in SQL*NET
I have recently run various statspack reports and ult report against my 8.1.6 database. It suggests that I am sending more data on the client side than will fit into one SQL*NET package. I have been looking for documentation and/or samples and have only found: - The SDU size should be set as a multiple of the normal transport frame size. Since the normal Ethernet frame size is 1500, the most efficient SDU size over an Ethernet protocol should be a multiple of 1500. If you are using either connection pooling or connection concentration, keep in mind that these features require an additional 16 bytes per transport. For more information about the protocol frame size, refer to your operating-system-specific documentation. I am not sure how to set this parameter or how to find out the protocol frame size you are using. Anybody have any experience using this? Is it worth the effort? Any samples of how to set? Thanks, Kathy Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret 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: WinNT / 8.0.5 / Import anomaly, or is it?
I actually did. That didn't help. George -Original Message- Sent: Friday, July 20, 2001 11:34 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] The tablespace was fragmented. Restarting the database caused it to coalesce your tablespaces. You could have issued 'alter tablespace mytbs coalesce;' for each tablespace before running the import. Jay [EMAIL PROTECTED] 07/20/01 02:55PM From out of nowhere, I started getting the 'ORA-01658: unable to create INITIAL extent for segment ...' error for only SOME indexes on my index tablespace when doing a simple import. Export was done without compression. I rechecked INITIAL extent sizes and true to my expectations they were small 665K. I didn't want to go through precreating the tables with appropriate sizes because I felt it was not the issue in the first place. As a last resort I restarted the database and everything went back to normal again. Can anybody have an explanation for this? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: George Hofilena 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: How do I control NEXT parameter in the table....
try 'alter tablespace tablespace_name coalesce;'. On Fri, 20 Jul 2001, Uday C Basavaraj wrote: Hi All, My database report says that for couple of tables (in the same tablespace) The NEXT (storage parameter) is greater than the available space in the tablespace. Actually I have more free space in the tablespace (may be they are not continues). I don't want to add another datafile to the tablespace. By simply reducing the NEXT and PCTINCREASE storage parameter value can I solve this problem? or do I have to recreate the table?. Can anyone tell me how do I resolve this problem by not adding new datafile.. Thanks in advance Uday -- Lucy Lin Oracle DBA condenet.com 212-286-3852 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lucy Lin 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).
SMS and Net8 Client Deployment
Title: SMS and Net8 Client Deployment Any shops out there using SMS to deploy Net8 clients? If so, could you give me the gist of the mechanics? Thanks, Jeff T [EMAIL PROTECTED]
OEM: init, Tuning Pack question ???
Hi all, Me again :-( :-). Thank you all those anwering my previous questions, I made lots of progress! Here are some question/problem I still have :-(: OEM 2.0.4 on NT 4.0, Oracle 815 on Sun 5.6 Tuning Pack Connection Question: I can login to any tool under DBA Managment Pack with no problem. However in Tuning Pack, Tablespace manager, I always got TNS could not resolve service name. The service name was already configured. In Oracle Expert, I tried to create a new session, the db name was pre loaded in a combo box and it's read only, I picked one, and got TNS could not resolve service name. Where did that combo box got loaded?? The db name I picked is already configured, do I need to do some other configuration??? Local Init file Question: In Instance Manager, the DB State is read-only. I saw in the document that: If connected directly to a remote database, you must have a local copy of the INITSID.ORA file to startup the database. May I know where to put this file in my local machine? Once I place this file, can the DB state be editable? Thank you so much!!! Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: SDU and TDU in SQL*NET
Here's a sample from tnsnames.ora: . . . yourlabel = (DESCRIPTION = (SDU=1500) (TDU=1500) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = yourhost.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = your_service) (SID = your_ORACLE_SID) ) ) Here's a sample from listener.ora: . . . (SID_DESC = (SDU=1500) (TDU=1500) (GLOBAL_DBNAME = yourDB.yourhost.com) (ORACLE_HOME = your_ORACLE_HOME) (SID_NAME = your_ORACLE_SID) ) The MTU on Ethernet is 1500 and MTU=SDU=TDU is a recommendation I've seen. No comments on worth... Steve Orr -Original Message- Sent: Friday, July 20, 2001 3:51 PM To: Multiple recipients of list ORACLE-L I have recently run various statspack reports and ult report against my 8.1.6 database. It suggests that I am sending more data on the client side than will fit into one SQL*NET package. I have been looking for documentation and/or samples and have only found: - The SDU size should be set as a multiple of the normal transport frame size. Since the normal Ethernet frame size is 1500, the most efficient SDU size over an Ethernet protocol should be a multiple of 1500. If you are using either connection pooling or connection concentration, keep in mind that these features require an additional 16 bytes per transport. For more information about the protocol frame size, refer to your operating-system-specific documentation. I am not sure how to set this parameter or how to find out the protocol frame size you are using. Anybody have any experience using this? Is it worth the effort? Any samples of how to set? Thanks, Kathy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: Extent allocation
Jeremiah is right. Depending on the version of the database this is an imaginary problem. I have been using this 'auto round robin' feature since 8.0.6 (HP-UX 32-bit). Just did quite a bit of re-organization involving partitioning a large table and used this auto round robin extent allocation feature to spread out I/O... Anyone seen this in any lower versions ?? Cheers! - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 4:57 PM To: Multiple recipients of list ORACLE-L Subject: Re: Extent allocation On Fri, 20 Jul 2001, Adrian Roe wrote: Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files and each file is on a different disk, can extents be allocated from each file in sequence ? As I understand, Oracle will fill one file and then go onto the next file. It appears we may be discussing an imaginary problem. At least on the version I am using (8.1.6.2 HP-UX 64 bit), Oracle round robins among files with available space automatically. It does not just fill up one datafile and move on to the next. I did a little experiment: SQL create tablespace jeremiah_temp1 1 datafile '/tmp/jeremiah_temp-01.dbf' size 10m, 2 '/tmp/jeremiah_temp-02.dbf' size 10m, 3 '/tmp/jeremiah_temp-03.dbf' size 10m, 4 '/tmp/jeremiah_temp-04.dbf' size 10m; Tablespace created. SQL create table foobar 1 (baz varchar2(10)) 2 storage (initial 32k next 32k pctincrease 0 maxextents 4) 3 tablespace jeremiah_temp1; Table created. SQL insert into foobar (baz) 1 select substr(trash,1,10) from garbage where rownum = 6000; 6000 rows created. SQL commit; Commit complete. SQL select segment_name, e.bytes/1024 kb, file_name 1 from dba_extents e, dba_data_files d 2 where e.file_id = d.file_id 3 and e.segment_name = 'FOOBAR'; SEGMENT_NAME KB FILE_NAME -- -- -- FOOBAR 32 /tmp/jeremiah_temp-01.dbf FOOBAR 32 /tmp/jeremiah_temp-02.dbf FOOBAR 32 /tmp/jeremiah_temp-03.dbf FOOBAR 32 /tmp/jeremiah_temp-04.dbf So, it looks like it round robins automatically, and there is no need to do so manually. I don't know which version of Oracle was the first to do this. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: SDU and TDU in SQL*NET
Title: RE: SDU and TDU in SQL*NET I believe the TDU parameter is now ignored in Net8. Our tests seems to indicate that it's fixed at 32K. Jeff T. [EMAIL PROTECTED] -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 5:23 PM To: Multiple recipients of list ORACLE-L Subject: RE: SDU and TDU in SQL*NET Here's a sample from tnsnames.ora: . . . yourlabel = (DESCRIPTION = (SDU=1500) (TDU=1500) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = yourhost.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = your_service) (SID = your_ORACLE_SID) ) ) Here's a sample from listener.ora: . . . (SID_DESC = (SDU=1500) (TDU=1500) (GLOBAL_DBNAME = yourDB.yourhost.com) (ORACLE_HOME = your_ORACLE_HOME) (SID_NAME = your_ORACLE_SID) ) The MTU on Ethernet is 1500 and MTU=SDU=TDU is a recommendation I've seen. No comments on worth... Steve Orr -Original Message- Sent: Friday, July 20, 2001 3:51 PM To: Multiple recipients of list ORACLE-L I have recently run various statspack reports and ult report against my 8.1.6 database. It suggests that I am sending more data on the client side than will fit into one SQL*NET package. I have been looking for documentation and/or samples and have only found: - The SDU size should be set as a multiple of the normal transport frame size. Since the normal Ethernet frame size is 1500, the most efficient SDU size over an Ethernet protocol should be a multiple of 1500. If you are using either connection pooling or connection concentration, keep in mind that these features require an additional 16 bytes per transport. For more information about the protocol frame size, refer to your operating-system-specific documentation. I am not sure how to set this parameter or how to find out the protocol frame size you are using. Anybody have any experience using this? Is it worth the effort? Any samples of how to set? Thanks, Kathy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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: SDU and TDU in SQL*NET
Kathy, Check out a paper titled SQL*Net PERFORMANCE TUNING UTILIZING UNDERLYING NETWORK PROTOCOL at http://www.fors.com/eoug97/papers/0285.htm It might be of help to you. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Kathy Duret [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 4:51 PM To: Multiple recipients of list ORACLE-L Subject: SDU and TDU in SQL*NET I have recently run various statspack reports and ult report against my 8.1.6 database. It suggests that I am sending more data on the client side than will fit into one SQL*NET package. I have been looking for documentation and/or samples and have only found: -- -- - The SDU size should be set as a multiple of the normal transport frame size. Since the normal Ethernet frame size is 1500, the most efficient SDU size over an Ethernet protocol should be a multiple of 1500. If you are using either connection pooling or connection concentration, keep in mind that these features require an additional 16 bytes per transport. For more information about the protocol frame size, refer to your operating-system-specific documentation. -- -- I am not sure how to set this parameter or how to find out the protocol frame size you are using. Anybody have any experience using this? Is it worth the effort? Any samples of how to set? Thanks, Kathy Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret 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: Deshpande, Kirti 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: SDU and TDU in SQL*NET
Title: RE: SDU and TDU in SQL*NET As I understand, you have to run with SQL*NET of version 2.3 and above. I will let you know what I find out when I get into testing and down the road. Kathy -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]]Sent: Friday, July 20, 2001 3:41 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SDU and TDU in SQL*NET I believe the TDU parameter is now ignored in Net8. Our tests seems to indicate that it's fixed at 32K. Jeff T. [EMAIL PROTECTED] -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 5:23 PM To: Multiple recipients of list ORACLE-L Subject: RE: SDU and TDU in SQL*NET Here's a sample from tnsnames.ora: . . . yourlabel = (DESCRIPTION = (SDU=1500) (TDU=1500) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = yourhost.com)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = your_service) (SID = your_ORACLE_SID) ) ) Here's a sample from listener.ora: . . . (SID_DESC = (SDU=1500) (TDU=1500) (GLOBAL_DBNAME = yourDB.yourhost.com) (ORACLE_HOME = your_ORACLE_HOME) (SID_NAME = your_ORACLE_SID) ) The MTU on Ethernet is 1500 and MTU=SDU=TDU is a recommendation I've seen. No comments on worth... Steve Orr -Original Message- Sent: Friday, July 20, 2001 3:51 PM To: Multiple recipients of list ORACLE-L I have recently run various statspack reports and ult report against my 8.1.6 database. It suggests that I am sending more data on the client side than will fit into one SQL*NET package. I have been looking for documentation and/or samples and have only found: - The SDU size should be set as a multiple of the normal transport frame size. Since the normal Ethernet frame size is 1500, the most efficient SDU size over an Ethernet protocol should be a multiple of 1500. If you are using either connection pooling or connection concentration, keep in mind that these features require an additional 16 bytes per transport. For more information about the protocol frame size, refer to your operating-system-specific documentation. I am not sure how to set this parameter or how to find out the protocol frame size you are using. Anybody have any experience using this? Is it worth the effort? Any samples of how to set? Thanks, Kathy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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). ConfidentialThis e-mail and any files transmitted with it are the propertyof Belkin Components and/or its affiliates, are confidential,and are intended solely for the use of the individual orentity to whom this e-mail is addressed. If you are not oneof the named recipients or otherwise have reason to believethat you have received this e-mail in error, please notify thesender and delete this message immediately from your computer.Any other use, retention, dissemination, forwarding, printingor copying of this e-mail is strictly prohibited.
RE: Another programming standard falls
See, I don't get it. Microsoft bundle a bunch of stuff with their OS, and the anti-MS camp complain about Microsoft's so-called monopoly (or monopolistic practices, which aren't the same thing). And then Microsoft don't bundle some stuff with their OS, and the exact same people start complaining again... about what exactly? You can still download Java onto Windows easily, it's no big deal, what is the problem here? Any time a vendor with such a huge market share includes or excludes something from their OS, it has a huge impact. IF MS had stopped including Internet Explorer in their OS, and the user had to go download something to get a web browser, it's likely Navigator might still have a good chunk of the browser market. But MS made it easy for users to get to a browser (bundling IE), and most users will take the path of least resistance. A JVM download is what 5+ MEG? Most of the world is still connecting via modem. Tell the average person he's going to have to do a 5 MEG download over a modem, and then some sort of installation that might screw up his machine, and he's going to say Forget it, I'll do without my scrolling stock ticker. Or he'll switch to one that doesn't use Java. If a good percentage of the users of an OS that constitutes most of the total consumer market will not take the time to download and install JVM, developers are going to assume Java may not be available on a lot of the machines out there. Most developers want to reach the broadest possible audience with their products. So they might decide to pick a different, more universally available language to code with. One that can be run on a Windows user's machine without requiring a big download and installation of a virtual machine. Quite possibly a Microsoft language like C# or VB. And since C# is pretty similar to Java, the transition from one to the other might not be that tough. So yes, MS dropping the bundling of Java is a big deal. Everything they do at the OS level is a big deal. It makes it that much more likely that Java will be a niche language, and that much more likely that something like C# will gain in popularity. Whether that's good or bad will depend on your own viewpoints. Dave -- 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).
Unix problem HELP me please....!
Hi all, In my Solaris 7 I have . In server site todaydate=`date '. /data/$todaydate/myfile1.tar /data/$todaydate/myfile2.tar Because this file is created daily so I create a softlink to this file (to make the ftp user essayer) $ ln -s /data/$todaydate /data/todayfile $ chmod 777 /data/todayfile In client site when the user (ftp user) ftp cd /data/todayfile ...Permission denied Do I have to copy all those files into a physical directory ? Can I go to my softlink and what is the permission required? Thank you guys, regards, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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: AutoExtend
You can use following query to see your tablespace has autoextend on or off. select TABLESPACE_NAME,AUTOEXTENSIBLE from dba_data_files; Regards, Anand. -Original Message- Mladen Sent: Saturday, July 21, 2001 12:41 AM To: Multiple recipients of list ORACLE-L You look in the table sys.file$. -Original Message- From: Michael E. Cupp, Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Subject: AutoExtend How can I determine if tablespaces are set up in autoextend? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael E. Cupp, Jr. 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: Gogala, Mladen 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: Anand 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: Unix problem HELP me please....!
Sinardy wrote: Hi all, In my Solaris 7 I have . In server site todaydate=`date '. /data/$todaydate/myfile1.tar /data/$todaydate/myfile2.tar Because this file is created daily so I create a softlink to this file (to make the ftp user essayer) $ ln -s /data/$todaydate /data/todayfile $ chmod 777 /data/todayfile In client site when the user (ftp user) ftp cd /data/todayfile ...Permission denied Do I have to copy all those files into a physical directory ? Can I go to my softlink and what is the permission required? Thank you guys, regards, Sinardy Check permissions on /data, it may not be readable by the ftp user. Also, your chmod changes permissions on the file, not the link itself. Some Unixes do not use link permissions, Solaris 7 may. 'man chmod' will tell you whether there is a flag to specifically change permissions on the link (if there is one, it is likely to be -h). HTH, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax:+44 (0) 7050-696-449 Performance Tools Free Scripts -- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
