OT: Oracle to DB2 books?
I checked bookpool and amazon and can't seem to find any decent books for experienced DBA's who need to learn UDB/DB2. Has anyone found a decent book for Oracle DBA's needing to learn UDB? Since my company has chosen UDB for 'strategic' reasons on an upcoming project I need to learn this product. I'm about to download IBM's CBT but would like to have a book to read also. Thanks - Brian __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Fav. Urban Legend...
message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in |the message BODY, include a line containing: UNSUB ORACLE-L |(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: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle sites 1/30/2002 ?
Can anyone get to the oracle sites this morning? I've tried since 7:30 EST and haven't been able to get on. oracle.com technet.oracle.com metalink Hope this isn't the Unbreakable claim being seriously broken by hackers. - Brian __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 -: SQL BackTrack info
containing: UNSUB ORACLE-L (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). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: unused blocks BELOW HWM - Thanks
-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: executing unix commands from PL/SQL
Larry's link to asktom is where I got started however I made the
mistake of telling the developers about this before I realized the
implications and major security hole.
This grants tissd privs to execute ksh scripts from within
/gw/prodn/tissd/code/ksh/
begin
dbms_java.grant_permission
('TISSD',
'java.io.FilePermission',
'/usr/bin/ksh',
'execute');
--
dbms_java.grant_permission
('TISSD',
'java.io.FilePermission',
'/gw/prodn/tissd/code/ksh/-',
'execute');
--
dbms_java.grant_permission
('TISSD',
'java.lang.RuntimePermission',
'-',
'writeFileDescriptor');
--
end;
/
Now your favorite developer is pissed about you not giving him dba
privs within the database so he's gonna mess with you by creating the
following shell script within the dir mentioned above.
#!/usr/bin/ksh
rm -rf /u01/app/oracle/*
Now if he tried to execute this from the OS it wouldn't allow him to
remove anything from /u01/ since he's not oracle or part of the dba
group.
However, he creates a simple java stored proc (see asktom) to call out
to the OS to execute this script. When you call out to the OS from
within java guess who it is executing as ??? That's right - ORACLE!
Hasta la vista database files. I yelled at Oracle about this and they
were going to write up an informational note! This is such a security
hazard, at least within 8.1.7 (I doubt it is changed in 9i), that it
isn't even funny what someone could do.
Be careful what you grant to whom!
I think execute on /usr/bin/ls is ok but other than that...
- Brian
--- John Dunn [EMAIL PROTECTED] wrote:
is there anyway to do this other than external procedures or
DBMS_PIPE?
Like using java?
Anyone got a very simple java example?(for someone unfamiliar with
java in
stored procedures)
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).
__
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian Wisniewski
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: What is Quorum device ? (not Oracle)
Sindary, I didn't see a reply from anyone else your question so I'll take a stab at it but I have very limited knowledge about this so don't take it as doctrine. A quorum device is a disk that is shared between clustered servers to keep cluster configuration information current. I also think it is dependent upon the servers O/S as to how it is implemented and if the quorum device can be used for user data or not. From Sun. quorum device A disk shared by two or more nodes that contributes votes used to establish a quorum for the cluster to run. The cluster can operate only when a quorum of votes is available. The quorum device is used when a cluster becomes partitioned into separate sets of nodes to establish which set of nodes constitutes the new cluster. Cluster Members FAQ Is the order in which nodes are booted significant? In most cases, no. However, the boot order is important to prevent amnesia (refer to Quorum and Quorum Devices for details on amnesia). For example, if node two was the owner of the quorum device and node one is down, and then you bring node two down, you must bring up node two before bringing back node one. This prevents you from accidentally bringing up a node with out of date cluster configuration information. Take a look at this link for more in-depth information. http://docs.sun.com/ab2/coll.572.7/CLUSTCONCEPTS/@Ab2PageView/2025?DwebQuery=Quorum+OR+deviceoqt=Quorum+deviceAb2Lang=CAb2Enc=iso-8859-1 - Brian --- Sinardy Xing [EMAIL PROTECTED] wrote: Date: Thu, 07 Jun 2001 04:10:54 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] From: Sinardy Xing [EMAIL PROTECTED] Subject: What is Quorum device ? (not Oracle) Organization: Fat City Network Services, San Diego, California Hi all, Can someone explain what is Quorum device, what it is the different from disk and quorum device ? Thank you, Sinardy __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SOLVED: dbms_java and file permissions
For those of you interested in this thread.
Here is my conclusion.
Some of my initial tests were flawed with files not existing that I
thought existed and strange results from executing the procedure.
While this is valid from the O/S /usr/bin/ls /u20/app/oracle/* , it
doesn't work from within the procedure exec rc('/usr/bin/ls
/u20/app/oracle/*') (return code 2). So I thought access was being
limited and I had to grant permissions in one case and try to restrict
them in another when it is just a caveat that was throwing me off.
I re-read the security section from the Java Developers Guide. What I
was getting hung up on was Example 5-2 Limiting Permissions on page
5-10. For example, if you want to allow access to all files within
the /tmp directory - except for your password file that exists in that
directory - you would grant permission for read and write to all files
within /tmp and limit read and write access to the password file
I didn't realize this was for Java access to files, I thought this was
limiting all access. When I granted execute on /usr/bin/* the call to
the O/S operates under the execute permissions for the /usr/bin pgm and
since the files are just parameters to the executables (ls,mv,etc) file
security is subverted.
I still think this is a major issue that could be better communicated
(Like in an Oracle Note) versus being found out by trial and error.
Given this I would never grant execute permission on mv, cp, rm, etc
from /usr/bin to anyone other than to a dba.
- Brian
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian Wisniewski
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(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: dbms_java and file permissions
Thanks for taking a shot Jared. I'm just starting with Java, learnin' as I go.
Sorry I didn't post the query initially. It was basically a select * from dba_java_policy wheregrantee = 'TISSD'.
External calls to the OS will be as the oracle user which would be hard to limit however it is happening in certain situations and I don't know this for a fact but I believe these calls shouldn't make it to the OS if there are restrictions. I may be off on that but /export/home/oracle is also owned by Oracle and I wasn't allowed to do an ls on that directory unless I had explicitely granted permission to it. Also I can't do an ls on /u20/app/oracle/testjunk.file which is explictly restricted (still owned by Oracle on OS) but I can still ls the directory (even though I tried to restrict access) or even move the file. Strange.
Here's the response I got from Metalink forums.
Hi. This issue must be handled by an analyst in the Internet Languages group. Unfortunately at this time we do not have technical forum support for Internet Languages within MetaLink. For assistance from Oracle Support on this issue, you will need to log an iTAR. iTAR functionality is accessible via the TARs option on MetaLink Home.
I'lltry the TAR approach and see if I get anywhere.
Thanks again - Brian
Jared Still [EMAIL PROTECTED] wrote:
Brian,I've still gotta lot to learn about Java, but I'll takea stab at this.First off, what query did you use to produce the outputbelow?Do external processes run via Java run as Oracle? I'm guessing that they do, but I could be wrong, and don'thave time to test this right now.If so, this will likely put a limit on your abilities to restrict access to directories owned by Oracle.Hope some of this helps.JaredOn Tuesday 05 June 2001 07:41, Brian Wisniewski wrote: 8.1.7.1 on Solaris 7 I created a small java procedure to be able to call O/S commands from within the database (using Ask Tom's example). Works a little too well because I can't seem to restrict access to the oracle directories which is obviously a major concern. Here are the list of !
!
privileges I granted/restricted to the owner of the java procedure. KIND GRANTE TYPE_ TYPE_NAME NAME ACTION -- - -- -- - GRANT TISSD SYS java.io.FilePermission /export/home/oracle/bsw/scripts/java read RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/ read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/* read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/- read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/test* read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/testjunk.file read,write,execute,delete GRANT TISSD SYS java.io.FilePermission /usr!
!
/bin/* execute GRANT TISSD SYS java.lang.RuntimePermission * writeFileDescriptor 9 rows selected. As you can see I tried numerous ways to restrict access to /u20/app/oracle files and had very limited luck. Each time I added a new restriction I logged out of the tissd account and back in. On the flip side I had to grant access to /export/home/oracle/bsw/scripts/java to allow files to be read there. I don't understand why unlimited access is being allowed to the files which should be the most restricted. The tissd user was NOT granted DBA privs nor the JAVASYSPRIV or JAVAUSERPRIV roles. I've read the 8.1.7 Java Developers Guide Chapter 5 on security and haven't found the answer there either. This worked, which I didn't think it should. SQL exec rc('/usr/bin/ls /u20/app/oracle'); admin jre oraInventory oradata oui product testjunk.file Return code is 0 And this failed. SQL exec rc('/usr/bin/ls /u20/app/oracle/*'); Return code is 2 Doing an ls on the file failed SQL exec rc('/usr/bin/ls /u20/app/oracle/testjunk.file'); Return code is 2 But moving it worked fine. AAUUUGGGHHH!!! SQL exec rc('/usr/bin/mv /u20/app/oracle/testjunk.file /u20/app/oracle/testfile.junk'); Return code is 0 Just your regular ol' IDIOT asking for HELP. Thanks - BrianDo You Yahoo!?
Yahoo! Mail Personal Address -
Get email at your own domain with Yahoo! Mail.
dbms_java and file permissions
8.1.7.1 on Solaris 7 I created a small java procedure to be able to call O/S commands from within the database (using Ask Tom's example). Works a little too well because I can't seem to restrict access to the oracle directories which is obviously a major concern. Here are the list of privileges I granted/restricted to the owner of the java procedure. KIND GRANTE TYPE_ TYPE_NAME NAME ACTION -- - -- -- - GRANT TISSD SYS java.io.FilePermission /export/home/oracle/bsw/scripts/java read RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/ read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/* read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/- read,writ!
!
e,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/test* read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/testjunk.file read,write,execute,delete GRANT TISSD SYS java.io.FilePermission /usr/bin/* execute GRANT TISSD SYS java.lang.RuntimePermission * writeFileDescriptor 9 rows selected.
As you can see I tried numerous ways to restrict access to /u20/app/oracle files and had very limited luck. Each time I added a new restriction I logged out of the tissd account and back in. On the flip side I had to grant access to /export/home/oracle/bsw/scripts/java to allow files to be read there. I don't understand why unlimited access is being allowed to the files which should be the most restricted. The tissd user was NOT granted DBA privs nor the JAVASYSPRIV or JAVAUSERPRIV roles.I've read the 8.1.7 Java Developers Guide Chapter 5 on security and haven't found the answer there either.
This worked, which I didn't think it should.
SQL exec rc('/usr/bin/ls /u20/app/oracle');adminjreoraInventoryoradataouiproducttestfile.junkReturn code is 0
And this failed.
SQL exec rc('/usr/bin/ls /u20/app/oracle/*');Return code is 2
Doing an ls on the file failed
SQL exec rc('/usr/bin/ls /u20/app/oracle/testjunk.file');Return code is 2
But moving it worked fine. AAUUUGGGHHH!!!
SQL exec rc('/usr/bin/mv /u20/app/oracle/testjunk.file /u20/app/oracle/testfile.junk');Return code is 0
Just your regular ol' IDIOT asking for HELP.
Thanks - Brian
Do You Yahoo!?
Yahoo! Mail Personal Address -
Get email at your own domain with Yahoo! Mail.
App/web login - how do you handle?
How do you handle logins for applications that log into the database using a common login? I've seen it handled through hard-coded username/pass in the app, password file in 'secure' directories and ops$ account with remote_os_authent set to true on a server being accessed from a 3rd tier web app. Mgmt didn't seemed too thrilled when I showed them in about 2 minutes how to break into the db when remote_os_authent=true. Just curious how you handle this. I haven't seen any particularly great way and am looking for a better solution. V7.3.4 - 8.1.7 databases. Thanks - Brian __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Default user accounts
I'm working on a database security audit at a new place and was trying to get a list together of all the default accounts Oracle may create so I can make sure their passwords have been changed. I've heard there are 15 or more accounts now. Does anyone have a list they would care to share? I'm working on 7.3.4 - 8.1.7 This is what I have so far. SYS SYSTEM OUTLN TRACESVR AURORA$ORB$UNAUTHENTICATED ORDSYS ORDPLUGINS MDSYS DBSNMP Thanks - Brian __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Default user accounts
Ignore my prior post about default accounts. I saw the list on orafaq but wasn't counting the 5 training accounts (scott/tiger) in my list as defaults and kept coming up short on the 15 or 16 'defaults'. Once I added them in it makes more sense with a post I saw on MetaLink from Oracle Support. - Brian __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nothing to do with Oracle : But is is very important : Your reaction please
Sorry for the last post. I meant to forward that to the original poster not to the Oracle list. Just as I hit the Send button I saw the TO: ORACLE-L and thought N that is not what I meant to do. Sorry again. - Brian --- palestine Qods [EMAIL PROTECTED] wrote: Hello, Please take a look at this and give your reaction : http://www.humanityonhold.com/intifada.html YOUR REACTION PLEASE THANKS A LOT __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nothing to do with Oracle : But is is very important : Your reaction please
I suppose this is an invalid address but keep this crap off of the Oracle-L list. You will likely find little sympathy using this spam approach. Both sides in this conflict have a significant amount of blame to accept. Violence breeds violence. Throwing rocks, blowing up innocent civilians, shooting babies will solve nothing but neither side seems to understand this. - Brian --- palestine Qods [EMAIL PROTECTED] wrote: Hello, Please take a look at this and give your reaction : http://www.humanityonhold.com/intifada.html YOUR REACTION PLEASE THANKS A LOT Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: palestine Qods INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: job offer from SAUDI ARABIA
of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like || subscribing). || || || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
OT: Heard of Peregrine Power Enterprise?
Anyone out there had experience with Peregrine Software's Power Enterprise? I just started at a new client and got thrown onto a project which will be using this on Oracle. They chose this package, don't have technical details about it, don't have the software but the developers plan on installing it as 'just another schema' into a database. I hate to crush them so early on but if I must. Anyhow Peregrine's web site was a useless bunch of mumbo-jumbo about pragmatic B2B CRM e-commerce e-procurement e-marketplace software. Please email me offline if you have any info. Thanks - Brian __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Metalink rant
I know Ross was a bit overwhelmed with Metalink earlier today but I'm going to hold off on my applause until they can figure out their shared pool problems. I think this will be fixed in V9.1.4 of the database. I've received this at least once every day this week when visiting Metalink. Thu, 3 May 2001 18:44:11 GMT ORA-04031: unable to allocate 2550012 bytes of shared memory (large pool,unknown object,session heap,bind var buf) DAD name: plsql PROCEDURE : per_hom.startup USER : bwisniewski URL: http://metalink.oracle.com:80/metalink/plsql/per_hom.startup PARAMETERS : - Brian __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle/Sybase NT/Unix
I deleted the message from the person wanting to know about Oracle V Sybase and NT V Unix. It appears the answer is Linux on the mainframe (running Oracle of course) http://dailynews.yahoo.com/h/cn/20010503/tc/venezuela_banks_on_ibm_linux_mainframe_1.html - Brian __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs DB2 - Oracle lost on cost
The client I work for (for the next 2 weeks at least) just made the decision to use UDB over Oracle due to the price of licenses from Oracle. And this is a startup with a big ol' pile of capital. Go figure, I thought startup's always picked the most expensive stuff. They must be saving on the DB for the skating rink. - Brian --- Henry Poras [EMAIL PROTECTED] wrote: I guess they can make their money by targeting the high end and having a few high paying customers, or be more reasonable and have a broader base. I get the feeling that Larry's ego (psychoanalysis from a distance, ain't it wonderful) would drive him to both the $ and the broad base. If you are competing against Bill Gates, you not only need the money, but also the exposure. Everyone knows Windows, you can't have just the elite knowing about Oracle. So where does that put us in 6 months? Henry __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 when creating a base
See what happens when my mailbox fills up and I get flustered. I get my gig and meg mixed up! 1gig attachment - now that would have been something! - Brian --- Brian Wisniewski [EMAIL PROTECTED] wrote: Next time do you think you might be able to send a 2gig attachment to over 1500 people since this one was a mere 1gig? - Brian --- [EMAIL PROTECTED] wrote: while running the script cr0_base_ADX.sql, we get the error : cre_base_ADX.log... Any idea ??? AIX Version : 4.3.2.0 Oracle version : 7.2.3 Thanks !! L.A. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 For you stock hounds out there
Actually there was a correction to the story where this note was taken from. Leisure Suit Larry lost $36 billion, not the mere $16 billion as originally stated. So I guess that would be closer to 3 million VW's. http://cbs.marketwatch.com/tools/quotes/newsarticle.asp?siteid=mktwsymb=guid=%7BEEF4505F%2D79FC%2D46CA%2DAC85%2D6233B453221E%7D - Brian --- [EMAIL PROTECTED] wrote: ** A Moment Of Sympathy For Those Much More Fortunate Investors have had a hard time lately, as the stock markets wallow at a fraction of the value they were a year ago, and the Nasdaq regularly hits new lows. Fortunately, there's a little solace for those who blew their vacation fund on a now-worthless IPO or who passed out after checking their 401(k) balance. An examination of some high-profile losers by the Reuters news service and Thompson Financial analyst Kevin Schwenger may give them company, if not sympathy. Take, for instance, Microsoft chairman Bill Gates. His 700 million shares in Microsoft halved in value during 2000--he lost around $39 billion. That's enough to buy a 13-inch television for every man, woman, and child in the United States. Or to buy more than a thousand F-18E Super Hornet fighter jets. "It used to be that if a hundred-dollar bill dropped on the ground, Bill Gates made so much money that it would not be financially wise for him to take the time to pick it up," says Wit Soundview analyst Arnie Berman. "That's now changed to where he should pick up hundreds, but not fifties." Microsoft CEO Steven Ballmer has been a little more fortunate, losing only $12 billion. You could have bought 48 million copies of Windows 2000 with that, Steve. But it wasn't just Microsoft execs who took it in the wallet. Oracle CEO Larry Ellison could own 1 million brand-new VW Beetles with the $16 billion he lost. Theodore Waitt, CEO of Gateway, would have to work 900 million hours at minimum wage to earn back his $4.7 billion loss. And Amazon.com CEO Jeff Bezos saw his 117 million shares in the online retail giant drop in value more than 84%, to a trifling $1.2 billion, killing his ability to buy everyone in Mexico a Razor scooter. But temper your schadenfreude. Berman reminds us that sinking stock values mean more than just reduced personal wealth. He points out that when a stock becomes less valued, it can make it harder for a company to make acquisitions and attract strong employees through stock offers. - David M. Ewalt -- 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). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Load LOB's w/ SQL*Loader problem
8.1.7/Win2000 While loading a table with small tiff images (6k - 15K, out of line Blob) and supporting data using SQL*loader we experienced a problem that some of the images getting loaded aren't matching up with the supporting data. Row 95 has the images from Row 1985, etc. Appears to be random problem. Some images are correct, others are not. Got rid of the readsize and bindsize and let them default and a test load of 5000 images looked like everything loaded OK. Now testing full load of 200,000 to see if that fixes the problem. Went from commit point of 5000 records down to 23 now that the read and bindsize are defaulting. Any ideas as to why this might be happening? I'm offsite and working with them over the phone but will be heading in tonight so any ideas or thoughts you have I can try out tonight. Thanks - Brian __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anyone used Fail Safe for NT?
This was for a single database on a Compaq cluster (active/passive) but I don't see any problems with multiple databases.. I didn't do the install of failsafe, but it looks pretty straightforward. I got called in because the database wasn't failing over to the other server in the cluster. I had to copy some of the .ora files and such to the other server and had to muck around in the registery a little to set up the failover machine but it was pretty easy. The sysadmins had the hardware failing over by the time I got there so that wasn't an issue but I had to have them make sure the shared drives were available in the failover machine before the database was restarted. email me if you want any specifics. - Brian --- The Oracle DBA [EMAIL PROTECTED] wrote: Anyone use Oracle Fail Safe for NT? Compaq just finished a tech/mkt presentation and made it seem oh so easy (for the right $). I am wondering if anyone has done it and in a multi DB env. Cheers, Earl Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- 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). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: process parameter
Raman, this isn't a settable parameter within AIX. The post-wait kernel extension takes care of this. Taken from the installation guide.. Oracle Post-Wait Kernel Extension The Oracle post-wait kernel extension implements an optimized mechanism of inter-process communications without the overhead of signal handlers or semaphores. The Oracle post-wait kernel extension is loaded into the kernel at system startup and remains loaded as long as the system is running. It is used by all Oracle instances running on the system. This section explains how to install and debug the kernel extension. As long as you run rootpre.sh from the latest version of the Oracle RDBMS available to you, there is no need to worry about these details, because rootpre.sh will take care of them. - Brian --- [EMAIL PROTECTED] wrote: Hi, Sorry for unix related question Software Installation and Maintenance Software License Management Devices System Storage Management (Physical Logical Storage) Security Users Communications Applications and Services Print Spooling Problem Determination Performance Resource Scheduling System Environments Processes Subsystems Applications RS/6000 SP System Management AIX System Backup Recovery/6000 Using SMIT (information only) Under which option can i find about semaphores and where this information will be stored.( file ) Regards, Raman __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: exsessive paging, which ora process ?
Rahul, I cut this from a MetaLink forum response. The entire conversation can found at http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FORp_id=41122.999 Your question may be able to be found if you have root access and the time to search through each procees or you can take the time to put this into a shell and loop through the oracle processes to find out who is being a hog. - Brian -- As root, you can type the command svmon -Pa where pid is the pid of an oracle process (say dbwr). You will see something like: Pid Command Inuse Pin Pgspace 92044 oracle 14757 3766 11448 Pid: 92044 Command: oracle Segid Type Description Inuse Pin Pgspace Address Range 13693 pers /dev/u13lv:2820 0 0 0 0..256 f12c pers /dev/u13lv:2819 10 0 0 0..6400 7546 pers /dev/u13lv:2818 0 0 0 0..138 2081 pers /dev/u13lv:2817 6 0 0 0..3840 7e27 pers /dev/u13lv:2816 125 0 0 0..20480 1e37f pers /dev/u13lv:2812 9 0 0 0..246 14d74 pers /dev/u13lv:2811 9 0 0 0..246 a709 pers /dev/u13lv:2810 9 0 0 0..246 11e30 pers /dev/u13lv:2809 0 0 0 0..-1 efaf pers /dev/u13lv:176129 6 0 0 0..65 19ddb pers /dev/u13lv:45505 0 0 0 0..0 5141 pers /dev/u13lv:51037 2 0 0 0..15 4004 work kernel extension 323 322 1 0..24603 : 65339..65535 2146 work lib data 47 0 23 0..5573 11011 work shared library text 1416 0 428 0..65535 10e1 work sreg[3] 762 0 763 0..1356 1e07a work private 217 1 218 0..722 : 65296..65535 f9af pers code,/dev/u13lv:164005 1718 0 0 0..5284 0 work kernel 10098 3443 10015 0..24429 : 39487..65535 Type refers to persistent pages (i.e. files) or work pages. The SGA consists of work segments of description sreg[?], with sreg[3] being the first one. The number of SGA pages that are paged out can be calculated by substracting Inuse pages from PGspace. In this example, we have 763 total SGA pages (4KB each), and 763-762=1 page that is paged out. Regards Tom Villane Metalink Analyst -- --- Rahul [EMAIL PROTECTED] wrote: List, our AIX suddenly stpped responding... and we had to kill some of the oracle (LOCAL=NO) processes to return the system back to normal... apparently the paging space filled up..and OS was unable to create any more proceses is there any way to know which oracle process is responsible for exsessive paging ? regards rahul __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Conversion of datatype
I threw this together and it works fine. I had to have the char field be 7 when the number was set to 6 otherwise I received ORA-06502: PL/SQL: numeric or value error: character string buffer too small SQL declare 2 test_int number(6) := 1; 3 test_char char(7); 4 5 begin 6 test_char := to_char(test_int, '09'); 7 dbms_output.put_line(test_char); 8 test_int := 33; 9 test_char := to_char(test_int, '09'); 10 dbms_output.put_line(test_char); 11 end; 12 / 01 33 - Brian --- Eriovaldo do Carmo Andrietta [EMAIL PROTECTED] wrote: I have this sentence in a pl/sql block : w_nseqline := w_seqline; select lpad(to_char(w_seqline, '9'), '0') into w_nseqline from dual; w_nseqline := w_seqline; w_nseqline is char(6); w_seqline is number(6). I want the result '1' but the code above is giving me '1 ' How can I solve it ? Thanks Eriovaldo do Carmo Andrietta ICQ #102604225 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What is limit on Search Condition in DBA_CONSTRAINTS table
I don't know what version you are on and I only have access to an 8.1.7 database right now but the search_condition column is a long so a set long ... would fix this problem in 8.1.7. To answer your question about underlying tables dba_constraints joins user$, con$, cdef$ (where the actual condition is stored) and obj$ - Brian --- [EMAIL PROTECTED] wrote: One of our developers is wondering why they can't see all of their check constraint options when they query from DBA_CONSTRAINTS, USER_CONSTRAINTS, ALL_CONSTRAINTS. The Search Condition column only shows about 60 characters, no matter what you set your output string to in SQL*Plus. How can we see the rest of the Search Condition? Is there an underlying table that this view is based on? Cherie Machler Gelco Information Network -- 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). __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: MetaStink, Redux
Whew, for a minute there I thought 'The page cannot be displayed' was the new homepage for MetaLink but I guess others are having problems also. :) - Brian --- "Mohan, Ross" [EMAIL PROTECTED] wrote: Is it me, or is MetaBlink on the fritz again? I get truly odd refresh times and behavior.. __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Degree of Parallelism: 0?
Lisa, are the servers actually running or are the idle? If you have parallel_min_servers set to something other than 0 then you will still see the servers in v$pq_sysstat they will just remain idle. I'm not sure about the degree 0, I was thinking it was the same as 1 (no parallelism) but I tried setting it in 8.1.7 and 8.0.5.2.1 to 0 and I received an error message. - Brian --- "Koivu, Lisa" [EMAIL PROTECTED] wrote: Hello all, I've purposely got PQO off. But I was shocked to see I've got some parallel query slaves out there. I checked to see which objects they are, listed below. I'm not concerned about the sys/system stuff, I"m worried about CTX (my intermedia text stuff.) Can anyone tell me exactly what DEGREE = 0 is?? I don't see it in the doco. Thanks 1 select owner, index_name, table_name, degree 2 from dba_indexes 3* where degree 1 SQL / OWNER INDEX_NAME TABLE_NAME DEGREE -- -- -- --- SYSSYS_IL000261C2$$ KOTTD$ 0 SYSSYS_IL000265C2$$ KOTTB$ 0 SYSSYS_IL000269C2$$ KOTAD$ 0 SYSSYS_IL000273C2$$ KOTMD$ 0 SYSTEM SYS_IL002316C00012$$ AQ$_QUEUES 0 SYSTEM SYS_IL002462C00025$$ DEF$_AQCALL 0 SYSTEM SYS_IL002472C00025$$ DEF$_AQERROR 0 SYSTEM SYS_IL002490C5$$ DEF$_LOB 0 SYSTEM SYS_IL002490C4$$ DEF$_LOB 0 SYSTEM SYS_IL002490C3$$ DEF$_LOB 0 SYSTEM SYS_IL002499C3$$ DEF$_TEMP$LOB 0 SYSTEM SYS_IL002499C2$$ DEF$_TEMP$LOB 0 SYSTEM SYS_IL002499C1$$ DEF$_TEMP$LOB 0 SYSTEM SYS_IL003112C5$$ REPCAT$_TEMPLATE_OBJECTS 0 SYSTEM SYS_IL003125C4$$ REPCAT$_TEMPLATE_PARMS 0 SYSTEM SYS_IL003139C4$$ REPCAT$_USER_PARM_VALUES 0 SYSTEM SYS_IL003162C3$$ REPCAT$_RUNTIME_PARMS 0 CTXSYS SYS_IL076392C2$$ DR$STATS 0 QODE_APP SYS_IL014135C2$$ CREATE$JAVA$LOB$TABLE 0 SYSSYS_IL056091C3$$ AURORA$SNS$ATTRIBUTES$ 0 QODE_BCSYS_IL093690C6$$ DR$CTX_MFG_SEARCH$I0 QODE_BCSYS_IL093695C2$$ DR$CTX_MFG_SEARCH$R0 QODE_BCSYS_IL140689C6$$ DR$CTX_CAT_SEARCH$I0 QODE_BCSYS_IL140694C2$$ DR$CTX_CAT_SEARCH$R0 QODE_BCSYS_IL143153C6$$ DR$CTX_PRODUCT_SEARCH$I0 QODE_BCSYS_IL143158C2$$ DR$CTX_PRODUCT_SEARCH$R0 26 rows selected. SQL 26 rows selected. Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Primary Keys
I don't know if my prior email made it out to the list or not. In 99% of the rows the Primary key will be a combination of 2 fields however they cannot be 100% sure this concatenated key will always be unique therefore the need for the surrogate key. From what I've gathered the PK will usually be columns 1 and 2 but at other times it will be 2 and 3 and somehow they've got this all figured out. It is possible if I add the date field to the other two fields it will always be a unique key but I need to talk to those who are familiar with the data to discuss. They just wanted me to come in and set up Oracle, fail safe, backup and recovery, partitioning, database layout etc. The question about the need for the PK was just something that came up and I didn't see a need for it based upon how they will be storing and querying data. They will never be querying off of the surrogate key, the table won't be partitioned off of it, there are no children tables hanging off of this, no snapshots, etc. - Brian --- Tony Johnson [EMAIL PROTECTED] wrote: How are you going to retrieve the data in these tables for your application. A surrogate key as you are describing is valid in many instances if for no other reason that to make the model much cleaner. There are many occasions where the 'live-and-die' relational rules have to be bent to meet real world problems. -- Tony Johnson Email : [EMAIL PROTECTED] Senior Database Administrator Voice : ( 480 ) 682 - 0849 GRID DATA, INC. Cell : ( 602 ) 363 - 7328 7408 W. Detroit #100 Fax: ( 480 ) 961 - 8801 Chandler, AZ 85226 -- Murphy's Data Constant:Data will be damaged in direct proportion to its value -Original Message- Wisniewski Sent: Thursday, February 01, 2001 12:08 PM To: Multiple recipients of list ORACLE-L I know this violates the most basic data modeling techniques but tell me what you think. I'm working on creating a new database which will be fairly small in number of tables ~8 but large in storage size ~4 terabytes with millions of records eventually. The 3 large tables will hold small images along with supporting data and the only reason I can see to have a primary key is to have a primary key. There is not a natural key for the tables so it would be a sequence which would never be selected against. Given the number of records all I can see it doing is taking up space, increase the time of the imports, generate more redo logs, etc and I can't see the benefits. There won't be any tables hanging off of these, I won't be using snapshots, replication or anything else I can think of that would require a PK but the voice 'YOU MUST HAVE A PRIMARY KEY' is resounding loudly in my head so I must ask why? Tell me what you think. Thanks - Brian __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: brian_wisniewski@ya#ff face=3D"Comic Sans MS" = size=3D4SPAN=20 class=3D240110416-01022001STRONGThis premiere party event=20 features/STRONG/SPAN/FONT/DIV DIV align=3DcenterFONT face=3D"Comic Sans MS" size=3D4SPAN=20 class=3D240110416-01022001/SPAN/FONTnbsp;/DIV DIV align=3DcenterFONT color=3D#ff face=3D"Comic Sans MS" = size=3D4SPAN=20 class=3D240110416-01022001STRONGDJ amp; = Dancing/STRONG/SPAN/FONT/DIV DIV align=3DcenterFONT color=3D#ff face=3D"Comic Sans MS" = size=3D4SPAN=20 class=3D240110416-01022001STRONGHors = D'oeuvres/STRONG/SPAN/FONT/DIV DIV align=3DcenterFONT color=3D#ff face=3D"Comic Sans MS" = size=3D4SPAN=20 class=3D240110416-01022001STRONGCash bar/STRONG/SPAN/FONT/DIV DIV align=3DcenterFONT color=3D#ff face=3D"Comic Sans MS" = size=3D4SPAN=20 class=3D240110416-01022001STRONGand/STRONG/SPAN/FONT/DIV DIV align=3DcenterFONT color=3D#ff face=3D"Comic Sans MS" = size=3D4SPAN=20 class=3D240110416-01022001STRONGA blizzard of SpeedDating=20 sessions/STRONG/SPAN/FONT/DIV DIV align=3DcenterFONT face=3D"Comic Sans MS" size=3D4SPAN=20 class=3D240110416-01022001/SPAN __ Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Wisniewski INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --
