Re: DBMS_SHARED_POOL.KEEP
Bunyamin, I've done something similar.
I have a table with a flag to determine whether to pin objects or not
at database startup.
I have a startup trigger owned by sys which is simply this.
begin
sys.db_startup_proc;
end;
CREATE OR REPLACE PROCEDURE "SYS"."DB_STARTUP_PROC"
as
--
cursor pin_cur is select * from sys.pin_objs;
--
pin_rec pin_cur%ROWTYPE;
--
begin
open pin_cur;
<>
loop
fetch pin_cur into pin_rec;
exit pin_loop when pin_cur%NOTFOUND;
--
if (upper(pin_rec.pin) = 'Y') then
if (pin_rec.type in ('PROCEDURE','FUNCTION','PACKAGE')) then
dbms_shared_pool.keep(''|| pin_rec.owner ||'.'||
pin_rec.name
||'');
elsif (pin_rec.type in ('TRIGGER')) then
dbms_shared_pool.keep(''||pin_rec.owner||'.'||pin_rec.name||'',''||'R'||'');
elsif (pin_rec.type in ('SEQUENCE')) then
dbms_shared_pool.keep(''||pin_rec.owner||'.'||pin_rec.name||'',''||'Q'||'');
end if;
end if;
--
end loop pin_loop;
close pin_cur;
end;
I also have a shutdown trigger and proc but that is outside of what you
are trying to accomplish. If you want the rest of the code let me know
and I'll send it to you.
- Brian
--- "Bunyamin K. Karadeniz" <[EMAIL PROTECTED]> wrote:
> Tried and does not work ..
>
>
> Bunyamin K. Karadeniz
> Oracle DBA / Developer
> Civilian IT Department
> Havelsan A.S. Eskisehir yolu
> 7.km Ankara Turkey
> Phone: +90 312 2873565 / 1217
> Mobile : +90 535 3357729
>
> The degree of normality in a database
> is inversely proportional to that of its DBA.
>
> - Original Message -
> From: Mercadante, Thomas F
> To: Multiple recipients of list ORACLE-L
> Sent: Thursday, April 18, 2002 4:18 PM
> Subject: RE: DBMS_SHARED_POOL.KEEP
>
>
> Bunyamin,
>
> Either try removing the 'EXEC' or try putting a begin and end
> around the call?
>
> EXECUTE IMMEDIATE
>
'SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')';
>
> or
>
> EXECUTE IMMEDIATE 'BEGIN
>
SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')'
> || '; END';
> This is a great idea, by the way! Let us know how it works!
>
> Tom Mercadante
> Oracle Certified Professional
>
> -Original Message-
> From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 18, 2002 4:28 AM
> To: Multiple recipients of list ORACLE-L
> Subject: DBMS_SHARED_POOL.KEEP
>
>
> I want to pin most run packages , I have loeded them into a
> table. For this I have written ,
>
> create or replace procedure pin_packages_defined as
> sql_sentence varchar2(200);
> cursor_name INTEGER;
> rows_processed INTEGER;
> CURSOR tab_cur IS SELECT owner,object_name FROM
> arsiv.pin_aday_objeler;
> tab_row tab_cur%ROWTYPE;
> BEGIN
> FOR tab_row IN tab_cur LOOP
> --EXECUTE IMMEDIATE 'EXEC
>
SYS.DBMS_SHARED_POOL.KEEP('||tab_row.owner||'.'||tab_row.object_name||')';
>
> cursor_name := dbms_sql.open_cursor;
> sql_sentence
>
:='SYS.DBMS_SHARED_POOL.KEEP('''||tab_row.owner||'.'||tab_row.object_name||''')';
>
> dbms_output.put_line(sql_sentence);
> dbms_sql.parse(cursor_name,sql_sentence, dbms_sql.native);
> rows_processed := dbms_sql.execute(cursor_name);
> dbms_sql.close_cursor(cursor_name);
> END LOOP;
> END;
>
> But , It does not execute , Is it impossible to execute
> DBMS_SHARED_POOL.KEEP dynamically ...I tried DBMS_JOB , It did not
> work too.
>
> How can I do this?
>
>
>
>
> Bunyamin K. Karadeniz
> Oracle DBA / Developer
> Civilian IT Department
> Havelsan A.S. Eskisehir yolu
> 7.km Ankara Turkey
> Phone: +90 312 2873565 / 1217
> Mobile : +90 535 3357729
>
> The degree of normality in a database
> is inversely proportional to that of its DBA.
>
>
__
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).
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...
; |-- > |Author: =?iso-8859-1?q?Connor=20McDonald?= > | INET: [EMAIL PROTECTED] > | > |Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > |San Diego, California-- Public Internet access / Mailing > Lists > | > |To REMOVE yourself from this mailing list, send an E-Mail message > |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > |the message BODY, include a line containing: UNSUB ORACLE-L > |(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: Freeman, Robert > | INET: [EMAIL PROTECTED] > | > |Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > |San Diego, California-- Public Internet access / Mailing > Lists > | > |To REMOVE yourself from this mailing list, send an E-Mail message > |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > |the message BODY, include a line containing: UNSUB ORACLE-L > |(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
Q: 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: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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
FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (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+device&oqt=Quorum+device&Ab2Lang=C&Ab2Enc=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 where grantee = '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'll try 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 - Brian>Do 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).
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).
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: 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: 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: job offer from SAUDI ARABIA
and in > > > || the message BODY, include a line containing: UNSUB ORACLE-L > > > || (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 of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
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).
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).
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: ERWIN HELP
Data Modeling with ErWin http://www.amazon.com/exec/obidos/ASIN/0672318687/o/qid=987780072/sr=2-1/104-4669291-3583155 This book doesn't cover the latest release (4.0) but is good for beginners. It is pretty easy to use though so you could probably figure it out without a book. You can also check out http://www.infoadvisors.com/userlists.htm they have a discussion forum about ErWin. - Brian --- ora dba <[EMAIL PROTECTED]> wrote: > Hi: > I am trying to document and reverse engineer an Oracle > 8i database. Could you please let me know where I can > find documentation on HOW TO use the ERWIN tool to do > the same. Any books available in market that you can > recommend would also help. > Thank you > > __ > 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: ora 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!? 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: Entity Relationship diagrams
We just went through the purchasing process with CA over ErWin. It is definitley not free! But at least it isn't based on the Power Unit matrix. :) I don't know of any free ones. Visio has very basic capabilities, ErWin is still King of the market, Embaracadero is up and coming but as of yet doesn't have a repository, Sybase's PowerDesignor is very nice also, and there is also Oracle's Designor but when the documentation told me it would take several hours to install I didn't take that as a good sign just to use as a modeling tool. All of these have eval's available from their websites. I have another client which is creating a small database (10 tables or so) and they are using Access to show the relationships and such. Very crude but it works for them. - Brian --- Saurabh Sharma <[EMAIL PROTECTED]> wrote: > hi, > ya there are tools which can do this work for you. one such tool i > know is > Platinum ERwin, but i don't know whether it's free or not. but what i > feel > is u can get some trial version of it. > try getting some more info about how to get it. > but one thing i tell u, it's really a good tool. i've used it, it's > handy > and easy to use. it has tools for reverse and forward engineering. > > bye, > saurabh > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Tuesday, April 17, 2001 2:20 PM > > > > Dear DBA Gurus, > > > >I have around 30 tables for which the columns, > datatypes, size > of > > each datatype, referential integrity constraints is decided. I > need to > draw > > E-R diagram linking each table with one or many tables. I am > looking for > a > > tool which will draw the diagram for me if I provide the column > names, its > > datatypes, referential integrity constraints etc. Is there any > free tool > > which will do this for me? If not, how do I do this? Any URLs or > links > or > > documents will be very much helpful. Any help in this regard will > be very > > much appreciated. > > > > TIA and Regards, > > > > Ranganath > > __ 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: error when creating a base
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).
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=mktw&symb=&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).
Re: Is terminal release of 8.0.x still supported?
I checked yesterday and 8.0.6 which is the terminal 8.0.X release is still supported on Solaris. Freakin' vendor won't certify their product for anything above 8.0.5 which hasn't been supported for nearly a year now. mumble, mumble... - Brian --- [EMAIL PROTECTED] wrote: > > We have some 8.0.4 databases running on Sun Solaris. > I believe that 8.0.4 has been desupported as of December 31, 2000. > We are unable to upgrade one of our apps at this time that is > running on an 8.0.4 database. > > Is the terminal release of 8.0.x still supported? If yes, what is > that terminal release? Is it 8.0.7? How long before that terminal > release will be desupported (if it is currently supported)? > > Thanks, > > 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!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- 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).
Somewhat OT: Db2 Vs Oracle
Due to price only (ANYONE FROM ORACLE LISTENING) my current client is considering moving to DB2(UDB?) from Oracle. They really don't have much of an investment, if any in Oracle (startup using licenses from parent co.). Now that they see how expensive Oracle will be they are reconsidering their initial thoughts of DB vendor. The employee DBA is freaking out, I'm looking for a new assignment anyhow so I'm really not bothered by this at all :) He is looking for completly biased opinions about why Oracle is a better choice than DB2 and I don't have any experience to say one way or the other. My answer of "I've heard UDB is a pretty good product" didn't seem to do much for him. If you would care to respond off the list to me I'll gather the responses and give them to him. 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).
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: Fwd:Oracle Upgrade DBA Wanted
It must be another person who's swiped names off of the oracle-l list because I had it in my email box this morning also. I've never posted my resume online so I know they didn't get it off of some job board. Maybe we can send out the oracle-l email mercenaries to hunt this guy down and send him the doggie doo warning package to his front step! - Brian --- [EMAIL PROTECTED] wrote: > OK Folks, > > I got this in the old inbox this morning. Most likely it came > from one of > the job search services like Monster.com. Funny how those services > just can't > forget you. Anyway it is of no interest to me, I like the New > England area and > am not interested in moving, but there may be one or more of you who > are > interested as has been said in the past. So don't shoot the > messenger & do make > appropriate use of the delete key if needed. > > > Dick Goulet > > Forward Header_ > Author: Mike Green <[EMAIL PROTECTED]> > Date: 3/1/2001 7:39 PM > > > > Hi Dick > > My company is currently looking to hire a full-time Senior Oracle DBA > with > technical, and some functional, experience supporting Oracle > Financial > apps. > > Ideally, we're hoping to find someone who has been through a few > backend > and application upgrades because we need to begin immediately. > > The initial project involves upgrading from Oracle 7x to 8i on the > RDBMS > side then phasing out 10.7 smart client and moving to Oracle 11i / > 11.5.2. We're also hoping to phase out many of the customizations > that > have been made to the financial modules such as HR, OM, GL, AR, AP > and > Payroll. > > We're located in the Glendale/Pasadena area which is a great place to > > live. > > If you or somebody you know is interested in becoming part of our > Oracle > team, send me a resume. If you're not interested in this job or > don't > want to be bothered, send me an email and let me know. > > Thanks, > > Michael Green > > Triad Project Management > 3452 E Foothill Blvd Suite 530 > Pasadena, CA 91107 > [EMAIL PROTECTED] > 626-793-7314 > > -- > 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).
Re: Conversion of datatype
I don't know what your problem is because I just threw it into a proc and executed it from sql*plus and sqlplus worksheet and it came back with the correct results. create or replace procedure test_proc as test_intnumber(6) := 1; test_char char(7); ... SQL> exec test_proc 01 33 Sorry but it works for me. - Brian --- Eriovaldo do Carmo Andrietta <[EMAIL PROTECTED]> wrote: > Right, but > in pl/sql it does not work correcty ... > > Why ? > > I also did it in sql plus. It works correct but in procedure , no. > > > Eriovaldo do Carmo Andrietta > ICQ #102604225 > > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Tuesday, February 27, 2001 1:32 PM > > > > 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). > > -- > 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 messag
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: 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=FOR&p_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: 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: Anyone using ...
The similiarities in your comments between CA and Oracle are scary. I'm working part-time for a client to get Oracle installed and configured for a new service they are going to provide to their clients. This is their first Oracle experience. They spent around $300K on software and licenses and that was for the server and partitioning option. They waited for a few weeks to get the CD's and kept calling and was always told it was on the way. They received the CD's, too bad they were for Solaris and they are running on Win 2000. They sent the Solaris CD's back and asked for the correct ones and then they finally received 2 CD's which the sales person had BURNT ON HIS CD BURNER from his personal collection because according to him there is a 3 month back log on NT/2000 CD's! They didn't receive the documentation or fail safe cd's which they need. Needless to say their experiences with Oracle Corporation so far has not ingrained in them a very high level of confidence in the company. It probably didn't help the situation any when I brought it an original 8.1.7 cd for NT/2000 that I had received for FREE weeks ago from Technet. :) - Brian --- "Malkuns, Skip" <[EMAIL PROTECTED]> wrote: > CA is also a 4 letter word around here also. The support is very poor > and > they have so much big company > paperwork/politic issues it is tough to get anything from them. I > have been > waiting for months to get product upgrades. > Sign this, fill out this, call here, go there. We finally dropped a > number > of their products. > Our sales rep turn over is heavy, so it seems you have to start over > everytime a new rep shows up. > And of course their new pricing structure has gone thru the roof... > > Skip > __ 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: MetaLink
Yup, got their new homepage titled 'The page cannot be displayed'. I was in at 7am EST and couldn't get in then either. I almost got the entire page up at 10:30 EST but couldn't get the buttons sidebar up. Now it is just sitting there thinking after the latest refresh. Imagine if MetaLink was served by some other technology and was 3X slower. Now that would be something to see. I would love to call in a TAR right now and get asked by the support person if I've visited MetaLink to submit it there. - Brian --- "Weaver, Walt" <[EMAIL PROTECTED]> wrote: > Anybody try to get into MetaLink this morning (7am MST)? > > Looks like they forgot to feed the hamsters again. > > --Walt Weaver > Bozeman, Montana, USA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Weaver, Walt > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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).
my.oracle.com
I never knew about my.oracle.com until I just saw a note about it here on the list. Thought I'd try it out. Went to their 'single sign on' and tried my username and password for technet and it failed. Thought I had it wrong so I had them email it to me. Nope I had it correct. I can modify my profile from my.oracle.com but I can't login with the exact name and password they sent to me. Note to the Oracle employees lurking on the list: YOUR SITES SUCK! __ 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: OT: this is the last thing we need
Oracle AppsWorld > > > > > > Former President Bill Clinton will be the keynote > > > speaker > > > at Oracle's AppsWorldin New Orleans on Monday. The > > > announcement comes while Clinton is reportedly in > > > line to join Oracle's board of directors. > > > > > > > >http://computerworld.com/cwi/story/0%2C1199%2CNAV47_STO57734_NLTam%2C00.html > > > > > > > > > > > > -- > > > 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). > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Dan Mills > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- (858) 538-5051 FAX: > > > (858) 538-5051 > > > San Diego, California -- Public Internet > > > access / Mailing Lists > > > > > > > > To REMOVE yourself from this mailing list, send an > > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > > 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB > > > ORACLE-L > > > (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: Ruiz, Mary A (CAP, CDI) > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- (858) 538-5051 FAX: > > > (858) 538-5051 > > > San Diego, California -- Public Internet > > > access / Mailing Lists > > > > > > > > To REMOVE yourself from this mailing list, send an > > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > > 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB > > > ORACLE-L > > > (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 - only $35 > >a year! http://personal.mail.yahoo.com/ > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Shantanu Talukder > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California -- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(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 Private, Free E-mail from MSN Hotmail at > http://www.hotmail.com. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Raghu Kota > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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 Personal Address > - only $35 a year! __ 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: 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: Opinions on OLTP
I'm working on a project which is converting from DB2 to Oracle and possibly UDB. All of the current constraints are in the Cobol code and none are database enforced. A version of the data model is stored in Cool:Gen and we need to update this and use it to move all of the constraints from the code into the database. We need to have someone who is familiar with Cool:Gen and the Cobol code go through and get the model updated before we move it to ErWin. Very tedious task which I am glad not to be tasked to do. I agree the constraints should be enforced in the database for consistency sake. Good luck. - Brian --- [EMAIL PROTECTED] wrote: > I am starting a Data Warehouse project, possibly using Oracle > Warehouse > Builder. One of the databases that I must bring together comes from > IBM > DB2 database. We have reverse engineered a piece of their database > so that > we can produce an ER diagram so that we can start understanding their > data. > A hindrance to us is that they do not use any constraints or > referential > integrity, but place all of their checks into their COBOL code. They > tell > me this is because they are an online transaction processing system, > and > that's how things are handled in that environment. I always thought > that > OLTP systems were airlines and such, but they, at best, have 20 data > entry > people. Is any database within DB2 under CICS considered OLTP, > perhaps? > What thresholds would you use to determine what is an OLTP system? > Has > anyone ever heard about putting all of the RI into code as opposed to > allowing the database to do its job? It seems silly to me to put all > of > your checks into code because changes and maintenance would just kill > you, > not to mention consistency, or lack thereof. > > Any insights into this would be appreciated. > > > Sherrie Kubis > Southwest Florida Water Management District > 2379 Broad Street > Brooksville, FL 34604 > 352.796.7211 Ext 4033 > Fax: 352-754-6776 > [EMAIL PROTECTED] > > > -- > 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 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: How to insert data in LOBs
No, you can't just use an insert statement to do this. There is a lot of information out on metalink about this. Take a look at the dbms_lob package or sql*loader. - Brian --- Saurabh Sharma <[EMAIL PROTECTED]> wrote: > hi all, > i want to know how to insert values i.e. text/word or images > in a table's LOB column. > can we insert them with the regular insert command. > please help in this regard. > thanks in advance.. > > saurabh > FCS Software Solutions Ltd. > Noida.(India) > [EMAIL PROTECTED] > __ 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
This is strictly a warehouse type solution. Loads only, never an update. Images and supporting data will be loaded from another database and queried from the internet and will remain online for X days. I do need to find out about the uniqueness of this data though just for my information. They seemed to have it all figured out and this wasn't what they tasked me to do so I left it to them for this part of it. Since the PK they defined didn't seem to have any relevance to their data or queries I thought I'd question its necessity. Thanks for the feedback everyone. - Brian --- William Beilstein <[EMAIL PROTECTED]> wrote: > The other problem is that if you do not have a unique key, how can > you ever manipulate that row. while I know that you can use the > rowid, that will not work if you ever need to link another table into > your application. > > >>> "Tony Johnson" <[EMAIL PROTECTED]> 02/01/01 03:27PM >>> > 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: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Tony Johnson > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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
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=3D4> class=3D240110416-01022001>This premiere party event=20 > features > class=3D240110416-01022001> > size=3D4> class=3D240110416-01022001>DJ & = > Dancing > size=3D4> class=3D240110416-01022001>Hors = > D'oeuvres > size=3D4> class=3D240110416-01022001>Cash > bar > size=3D4> class=3D240110416-01022001>and > size=3D4> class=3D240110416-01022001>A blizzard of SpeedDating=20 > sessions > class=3D240110416-01022001> __ 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
The will be querying off of customer id, check number, etc but they cannot guarantee the combination of customer and check or various other columns will be a unique row so the need for a sequence. The columns that would normally make up the PK are ALMOST always unique but once in a while ... This data is coming from banks - how accurate can it be? :) Once they receive the rows back that match the query they will then do a second select using the rowid returned from the first select to pull back the specific images. - Brian --- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote: > Well, how are you going to locate the image you need? If none of the > supported data is needed to describe or locate the image, why have > the > data at all? I'm not quite sure how to answer your question. > > > -Original Message- > Sent: Thursday, February 01, 2001 2: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: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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). __ 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).
Primary Keys
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: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: New Dynamic Views - GV$ ???
These are parallel server views. Taken from the reference manual. GV$ Views For almost every V$ view described in this chapter, Oracle has a corresponding GV$(global V$) view. In a parallel server environment, querying a GV$ view retrieves the V$ view information from all qualified instances. In addition to the V$ information, each GV$ view contains an extra column named INST_ID of datatype INTEGER. The INST_ID column displays the instance number from which the associated V$ view information was obtained. The INST_ID column can be used as a filter to retrieve V$ information from a subset of available instances. For example, the query: SELECT * FROM GV$LOCK WHERE INST_ID = 2 OR INST_ID = 5 retrieves the information from the V$ views on instances 2 and 5. In order to query the GV$ views, the value of the PARALLEL_MAX_SERVERS parameter must be greater than zero on all instances mounting the database. The sections that follow list the columns and public synonyms for the dynamic performance views. See Also: Oracle8i Parallel Server Concepts. - Brian --- Chandini Paterson <[EMAIL PROTECTED]> wrote: > Hi, > I was just looking at the data dictionary (dict table) and came > upon a > whole list of views that have similar names to the dynamic views > (V$), but > all start with GV$. > EG:- GV$DLM_LOCKS > GV$LOCK >etc. > > There almost seems to be one GV$ view for each V$ view. Would > somebody tell > me what these views are and why they are used. Oh, I am on ver 8.1.5 > by the > way. > > > Thanks a lot > Chandini Paterson > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Chandini Paterson > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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 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: Locally managed tablespaces
You cannot migrate a dictionary managed to local uniform. The best note on MetaLink that describes this is 120061.1. - Brian --- yong huang <[EMAIL PROTECTED]> wrote: > Hi, All, > > I can't figure out how to migrate my dictionary controlled tablespace > to a > locally managed with uniform size. > sys.dbms_space_admin.tablespace_migrate_to_local seems only to allow > you to > migrate to auto allocated LMT. So I emailed Jonathan Lewis and (hope > he won't > mind) says: > > begin quote** > What you are seeing is expected behaviour, the > allocation_type stays as USER, and you cannot > convert a dictionary managed tablespace into a > UNIFORM one (unless it happens to be completely > empty, I think, although there may be one other > special condition which I want to test). You only > get the benefit of the bitmap technology. > end quote > > in response to my question to him: > > |Question: I can't seem to migrate a dictionary-controlled TS to > local TS with > |uniform size. I can only migrate it to default, i.e. autoallocate. > Could you > |show me a simple screen dump to migrate to a uniform sized? Thanks a > lot. > > Therefore there's not much benefit you gain by migrating your > traditional > tablespace to LMT except through dropping and re-creating it. Who's > using the > autoallocate instead of uniform size option of LMT out there? > > Yong Huang > [EMAIL PROTECTED] > > > __ > 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: yong huang > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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 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).
