Scripts for creating Tables/schema's

2002-10-25 Thread Santosh Varma
i wanted a script which contains the create table/schema's for a existing database. How to get this script ? any utitlity or which option to be selected for achieving this after i install Oralce ? i am using oracle 8.1.7. Thanks and regards,Santosh

Error ORA-12638 Credential Retrieval Failed During DB Creation Using DBCA

2002-10-25 Thread moyam
Hi gurus, I just installed Oracle 8.1.6 on Windows XP successfully. However on creation of database using the Database Configuration Assistant, I get the error ORA-12638 'Credential Retrieval Failed' on initialisation of database and thereafter the process stalls. I visited Metalink and found

Location of Trace file

2002-10-25 Thread cosltemp-g . manoj
BDY.RTF Description: RTF file

Re: Scripts for creating Tables/schema's

2002-10-25 Thread PK_Deepa/VGIL
Hello This is possible using the freeware TOAD (Tools for Oracle Application development). Regards, Deepa. |+--- || Santosh | || Varma | || vsantosh@psi| || .soft.net | ||

Re: Location of Trace file

2002-10-25 Thread Michal Zaschke
Look in $ORACLE_HOME/dbs for initSID.ora file. It will be the file or the link to the file there. HTH, Mike [EMAIL PROTECTED] wrote: Hi , I want to know the location of trace file.I do not know location of init.ora. How to get it. Thanks Manoj -- Ing. Michal Zaschke

RE: Location of Trace file

2002-10-25 Thread Ayyappan S
Hi U can get the vale from the v$parameter for all the background process and trace path Ayyappan -Original Message- [mailto:cosltemp-g.manoj;orbitech.co.in] Sent: Friday, October 25, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Hi , I want to know the location of trace

Re: Location of Trace file

2002-10-25 Thread Tom Pall
SQL select name, value from v$parameter where name='user_dump_dest'; NAME VALUE -- user_dump_dest C:\oracle\admin\tom\udump - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

Re: Location of Trace file

2002-10-25 Thread oraora oraora
Manoj, svrmgrl show parameter ifile will give u the location of init.ora and svrmgrl show parameter background_dump_dest svrmgrl show parameter user_dump_dest will give u the location of alert and trace files respectively. HTH. Jp. -- Please see the official ORACLE-L FAQ:

RE: Location of Trace file

2002-10-25 Thread cosltemp-g . manoj
BDY.RTF Description: RTF file

Re: Theory v Practice

2002-10-25 Thread Maria Quinn
Two examples from my own experience: A few years ago when I was starting out, I got involved on a database project where all the constraints were coded rather than declared at database level (it wasn't Oracle, but the principle remains the same). It was a relatively small project and the guy

Security of self-service (e.g.HR) apps, utilizing Apache

2002-10-25 Thread stef
Hi, all, Sorry for cross-posting this to the list and the forums, but I am in desperate need for some guidance here (I have researched the web for the last 24 hours, almost continuously, to no avail). My company has recently deployed self-service apps (started with the HR module), and we

can clustering help INSERTS ?

2002-10-25 Thread Rahul
List, i have two heavily inserted tables, the structures are same. currently these tables reside on separate disks, can i increase the performance of inserts if i create these tables in a cluster ? as a cluster would force the rows of both the tables to be physically close on the disk !

RE: Suggestions solicited - Change Column Datatype from Number to

2002-10-25 Thread Rick_Cale
The user stated they were using 8.1.7.1 :) Rachel Carmichael To:

RE: Flat file generation integrity ideas...

2002-10-25 Thread Grabowy, Chris
Yes, which is the ideal solution, but the other systems aren't ready for XML. Anytime we have a really good solution it's defered to the next phase. -Original Message- Sent: Thursday, October 24, 2002 6:33 PM To: Multiple recipients of list ORACLE-L Chris - Your comment about the

RE: LOCALLY MANAGED TABLESPACE

2002-10-25 Thread Jamadagni, Rajendra
Title: RE: LOCALLY MANAGED TABLESPACE The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any

RE: Flat file generation integrity ideas...

2002-10-25 Thread Grabowy, Chris
Title: Message Tim, I can always count on you for a slick answer. Thanks. I will have to check into that. -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 6:24 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Flat file

Re: can clustering help INSERTS ?

2002-10-25 Thread Stephane Faroult
Rahul wrote: List, i have two heavily inserted tables, the structures are same. currently these tables reside on separate disks, can i increase the performance of inserts if i create these tables in a cluster ? as a cluster would force the rows of both the tables to be physically close on

[no subject]

2002-10-25 Thread Todd Carlson
Hey Guys, I used FGAC for a small application a year ago without problems/issues. I have reread the docs and now I would like to know the experiences of those using FGAC for larger systems. I am now working on an OLTP system that will have tables in the 4+ million range with 100+

RE: HP-UX 11i/8.1.7/SAP

2002-10-25 Thread Docherty, Heather
We have one Sap box on 1527 and one on 1528. From memory, Sap creates the listener on 1527 on each box, and when I built the production box, I moved the second listener to 1528. I discovered the 1527 anomaly when porting the tnsnames entry created into the central tnsnames file that we use for

Re: can clustering help INSERTS ?

2002-10-25 Thread Tim Gorman
Rahul, It does no good to speculate; let's work with facts... What wait-events are occurring in the sessions running the INSERTs? If you can locate the sessions in the V$SESSION view, then use the value in the column SID to locate associated rows in the V$SESSION_EVENT view, sorting by the

RE: Location of Trace file

2002-10-25 Thread Deshpande, Kirti
Ask your DBA. If you are the DBA, Oracle's Concepts Guide and Administration Guide will address these and many other questions. Those guides can be read (or searched) on-line at http://tahiti.oracle.com. It's all free (nominal registration at Oracle Technology Network may be required,

Re: SID and DB_NAME

2002-10-25 Thread Rajesh . Rao
Simply speaking, consider SID to be the name for the various background process (DBWR, LGWR, et all) and the memory structures (SGA, PGA). A SID needs to be associated with a database, which would be the DB_NAME. The SID and DB_NAME need not be the same. They have to be different in an Oracle

RE: Scripts for creating Tables/schema's

2002-10-25 Thread Deshpande, Kirti
Experiment with exp/imp utilities. Those have some features to generate such scripts for you. More information can be found in the Oracle Utilities Guide at http://tahiti.oracle.com. - Kirti -Original Message- Sent: Friday, October 25, 2002 2:04 AM To: Multiple recipients of list

Oracle configuration using Kerberos in two different realms

2002-10-25 Thread R Howard
Has anyone tried this and gotten it to work (Cross Realm): Microsoft 2000 KDC (Realm A) Third Party KDC (Realm B) on Solaris Sqlnet client (on Microsoft XP) resides in Realm A. Oracle server (on Solaris 8) resides in Realm B. The service principal for the Oracle server was created on Realm B -

Re: LOCALLY MANAGED TABLESPACE

2002-10-25 Thread Tim Gorman
Title: RE: LOCALLY MANAGED TABLESPACE why did management care? - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, October 25, 2002 7:04 AM Subject: RE: LOCALLY MANAGED TABLESPACE The only issue we faced

RE: LOCALLY MANAGED TABLESPACE

2002-10-25 Thread Jamadagni, Rajendra
Title: RE: LOCALLY MANAGED TABLESPACE Good question I don't know ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD:

RE: Error ORA-12638 Credential Retrieval Failed During DB Creatio

2002-10-25 Thread Deshpande, Kirti
I doubt if 8.1.6 is supported on Win XP. - Kirti -Original Message- Sent: Friday, October 25, 2002 2:38 AM To: Multiple recipients of list ORACLE-L Using DBCA Hi gurus, I just installed Oracle 8.1.6 on Windows XP successfully. However on creation of database using the Database

RE: LOCALLY MANAGED TABLESPACE

2002-10-25 Thread Leonard, George
Title: RE: LOCALLY MANAGED TABLESPACE Same here Getting management to first understand the extent issue on Dictionary managed was a interesting exercise. Now trying to break that understanding down when wanting to use LMT is like double the work, painful. Difficult thing trying to

Re: Scripts for creating Tables/schema's

2002-10-25 Thread Ron Rogers
Resend to to a email blocking error again today Santosh, If you do an export with FULL=Y and ROWS=N you get an export with all of the tables and creation scritps but no data populating them. The DATABEE tool www.databee.com could help with you documenting the database and also there is more

RE: LOCALLY MANAGED TABLESPACE

2002-10-25 Thread Deshpande, Kirti
Title: RE: LOCALLY MANAGED TABLESPACE In a 'converted/migrated' LMT, tables/indexes can not take advantage ofUNIFORMor SYSTEM (autoallocate) policy of extent management. Those objects still grow with their old'next' extent sizes. For full benefits of LMT, consider creating new LMT

RE: Suggestions solicited - Change Column Datatype from Number to

2002-10-25 Thread Rachel Carmichael
yes I know, which is why I did not suggest it to the original poster. Dennis was talking about *his* future projects, which is why I suggested it for him --- [EMAIL PROTECTED] wrote: The user stated they were using 8.1.7.1 :)

RE: Error ORA-12638 Credential Retrieval Failed During DB Creatio

2002-10-25 Thread Kevin Lange
Moses; You can get this patch by ftp'ing to updates.oracle.com. I already did and saw that it was there. Log in with your Metalink User ID and Password Then CD to the patch number. You can not list the patches , nothing shows up. Just CD to the number and then ls to see the patch. I did

RE: Error ORA-12638 Credential Retrieval Failed During DB Creatio

2002-10-25 Thread Kevin Lange
This is an 8.17 patch, not an 8.16 -Original Message- Sent: Friday, October 25, 2002 9:35 AM To: Multiple recipients of list ORACLE-L Creatio I doubt if 8.1.6 is supported on Win XP. - Kirti -Original Message- Sent: Friday, October 25, 2002 2:38 AM To: Multiple recipients

RE: LOCALLY MANAGED TABLESPACE

2002-10-25 Thread Gary Weber
Title: RE: LOCALLY MANAGED TABLESPACE Pardon the ignorance, I'm simply trying to understand... What is meant by "management" in this context? I'm can't imagine a circumstance under whichANY business manager would have a say on what goes on in the black box called Oracle. Downtime? Cost of

RE: Suggestions solicited - Change Column Datatype from Number to

2002-10-25 Thread Rick_Cale
Ooops!!! I missed where the thread changed from 8i to 9ig Rachel

RE: LOCALLY MANAGED TABLESPACE

2002-10-25 Thread Fink, Dan
Title: RE: LOCALLY MANAGED TABLESPACE You are lucky, very lucky... -Original Message-From: Gary Weber [mailto:[EMAIL PROTECTED]]Sent: Friday, October 25, 2002 9:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: LOCALLY MANAGED TABLESPACE Pardon the ignorance, I'm

RE: LOCALLY MANAGED TABLESPACE

2002-10-25 Thread Jamadagni, Rajendra
Title: RE: LOCALLY MANAGED TABLESPACE Some business managers migrate (pardon the pun) from being a techie to a bean counter type. So they know. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion

RE: LOCALLY MANAGED TABLESPACE

2002-10-25 Thread Leonard, George
Title: RE: LOCALLY MANAGED TABLESPACE Or am I simply lucky to not have that level of bureaucracy - You are lucky We are busy going into production for a big project, during the rollout and data take on the managers wanted to know all these things, it comes down to them not just

ALTER SESSION SET EVENTS '...'

2002-10-25 Thread Michael Ivanov
I often met SQL phrase in sql scripts as ALTER SESSION SET EVENTS '...' for example: ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10'; (Oracle 8.1.7.3 patches install instuctions) or alter session set events '10046 trace name context forever, level Level'; where

RE: Download Oracle 7.3.4

2002-10-25 Thread Bishop Lewis
Those were the days eh? Not really! ;-) It was a preverbial pain in the butt! ;-) Anyone HERE actually get SCO 7.3.4 working on Linux? If so, anyone got a copy - I would love to take a pop at it (never had the opportunity). Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT

Re: Location of Trace file

2002-10-25 Thread Tom Pall
Show parameter ifile shows the ifile address, not the pfile address. Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL show parameter ifile NAME TYPE

Re: Location of Trace file

2002-10-25 Thread Tom Pall
The most common reason is that you are not logged on the system as the user and group that owns the $ORACLE_HOME/bin/oracle executable. You also need to have ORACLE_HOME and ORACLE_SID set appropriately. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

Re: LOCALLY MANAGED TABLESPACE

2002-10-25 Thread Tim Gorman
Title: RE: LOCALLY MANAGED TABLESPACE It's a question of responsibilities, not knowledge. Knowing something does not mean that one should continue to be involved. Most managers (or directors or VPs) whocontinue to be concerned in thistechnical detailare not paying attention to the things

supplying dblink name to package at runtime

2002-10-25 Thread Magaliff, Bill
Hi, I'm trying to incorporate a procedure in a package that needs to run using a dblink name supplied at runtime. The dblink is used in the dml inside the procedure, but when I compile the package I get ORA-00942 table or view does not exist for all the sql referencing the dblink. Here is a

RE: LOCALLY MANAGED TABLE SPACE

2002-10-25 Thread Govind . Arumugam
Title: RE: LOCALLY MANAGED TABLESPACE Folks, I amnew to this group. Has anyone tried to convert a dictionary managed table space containing a lot of data to locally managed? We have tried this out successfully on empty table spaces or created a new LET table space and moved the existing

Re: ALTER SESSION SET EVENTS '...'

2002-10-25 Thread Rajesh . Rao
Mike, These events are generally set at the advice of Oracle Support, or when the DBA needs to do some tracing. You might not find these in the docs, but Metalink should have notes on them. Raj

RE: supplying dblink name to package at runtime

2002-10-25 Thread Balaraman, Arvind
Hi You can use native dynamic PLSQL (8.1 or higher) to do this stmt varchar2(2000); stmt := 'INSERT INTO mm_product_temp (rec, rec_old, name, is_disabled, is_workingcopy) (SELECT mm_product_seq.nextval, rec, name, is_disabled, is_workingcopy FROM mm_product@'||v_dblink||' WHERE last_update IS

RE: The life time of the data in v$sqlarea

2002-10-25 Thread Ravi Kulkarni
Chuan - The Sqlarea should contain All the statements (generalized as objects here as it is true for sql stmts, cursors, procedures, sequences etc.) since the database startup WHICH are not yet flushed out of the LRU list UNLESS explicitly flushed through ..Flush shared_pool command you

RE: can clustering help INSERTS ?

2002-10-25 Thread DENNIS WILLIAMS
Stephane You mentioned each additional index costs about 2.5 times the cost of inserting into a non-indexed table. I just wanted to point out that Kevin Loney has done some performance tests involving the number of indexes. I don't know if he has published these anywhere. In a nutshell, the

Re: Location of Trace file

2002-10-25 Thread Rajesh . Rao
If you follow OFA, it works for NT ;-) Tom Pall

RE: supplying dblink name to package at runtime

2002-10-25 Thread Mercadante, Thomas F
Bill, Not sure about the refcursor thningy you mentioned. I think I would do it another way. Always have a db link available at compile time for your package. The link may simply point back to a user in the same database. The thing to do is to make sure a dblink exists, and that it currently

RE: supplying dblink name to package at runtime

2002-10-25 Thread DENNIS WILLIAMS
Bill - My guess is that part of the package compilation is to verify the dblink as well as other objects, exist (for our own protection). What are you trying to accomplish? Select the destination dynamically? Just a dumb suggestion, maybe you can accomplish your task by creating a synonym and then

SQL*Plus COPY error

2002-10-25 Thread Paul Baumgartel
I'm trying to use (for the first time in 15 years of Oracle experience!) SQL*Plus COPY, and am receiving the following incomprehensible error: SQL @odss/cmsr Array fetch/bind size is 100. (arraysize is 100) Will commit after every 10 array binds. (copycommit is 10) Maximum long size is 2.

RE: LOCALLY MANAGED TABLESPACE

2002-10-25 Thread DENNIS WILLIAMS
The other thing I've encountered is where a consultant comes in and makes a fuss about the number of extents. Usually privately to a manager, then leaves, so you don't have an opportunity to discuss the issue. Or a GUI tool is demonstrated that has a screen to find problems, and usually one of the

Re: ALTER SESSION SET EVENTS '...'

2002-10-25 Thread Rachel Carmichael
You can also get an explanation of these event codes in the oraus.msg file, which is NOT supplied on Windows installations, but can be found in $ORACLE_HOME/rdbms/mesg on Unix Rachel --- [EMAIL PROTECTED] wrote: Mike, These events are generally set at the advice of Oracle Support, or when

Scheduling software

2002-10-25 Thread dgoulet
To ALL, About a week ago I asked if anyone had an opinion of CA's AutoSys product. Thanks to those who replied, but that was a pretty SMALL number. Therefore the boss is asking what product(s) are the most used, especially in a PeopleSoft environment where jobs have dependencies on each

Changing location of control file

2002-10-25 Thread Mike Sardina
To change the location of a controlfile, do you simply need to change the destination directory in the init? Do you have to copy anything to a different directory? I have three controlfiles that are all on one physical drive and I want to move one of them to another physical drive. -- Please

RE: Fine Grained Access Control

2002-10-25 Thread DENNIS WILLIAMS
Todd - Haven't used fine grained access control yet, but out of curiosity, how would this work with Weblogic connection pooling? Are you assigning each user an Oracle username? Does that mean you are using a dedicated connection and no pooling? Dennis Williams DBA, 40%OCP Lifetouch, Inc.

RE: secure connection

2002-10-25 Thread DENNIS WILLIAMS
Murat, Justin Out of curiosity, what is there about your network configuration that would encourage you to do this? At this point we consider our intranet secure, and for externally facing web servers we use a secure point-to-point connect back to the intranet. Dennis Williams DBA, 40%OCP

RE: what is purify

2002-10-25 Thread Jeroen van Sluisdam
Hi, When you install oracle it might link some things together. Possibly it used some obecjts that were compiled with purify or it is somehow installed on your system. Look for the objects that might have this and try to figure out where they came from. Hth, Jeroen -Oorspronkelijk

RE: Changing location of control file

2002-10-25 Thread Fink, Dan
You've got it right. Shutdown the database, move the files, change the init and restart... -Original Message- Sent: Friday, October 25, 2002 12:34 PM To: Multiple recipients of list ORACLE-L To change the location of a controlfile, do you simply need to change the destination directory

RE: Suggestions solicited - Change Column Datatype from Number to

2002-10-25 Thread DENNIS WILLIAMS
Rachel, Rick - And I really appreciated Rachel's suggestion because the new project will be on 9i, so it makes sense for me to change my methods while taking advantage of the latest Oracle features. Thanks to the goddess! Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED]

RE: LOCALLY MANAGED TABLESPACE

2002-10-25 Thread Jamadagni, Rajendra
Title: RE: LOCALLY MANAGED TABLESPACE Tim, That's not the case, these guys aretechies .. now handling higher duties. They just haven't kept up with 9i yet ... and yes they do their job very well. Raj __ Rajendra Jamadagni MIS, ESPN Inc.

Memory usage control in Tru64 - urgent !!!

2002-10-25 Thread Pablo Rodriguez
Hi!! I'm trying to see if a unix machine is having performance problem with any resources: cpu, disk and memory. When I started analyzing the memory statistics, taken previously with vmstat I realized that it's columns are completely different from any other unix I've worked before (solaris, aix,

Installing iAS 9.0.2.0.1

2002-10-25 Thread Gene Sais
Has anyone installed iAS 9.0.2.0.1 on Intel Linux? I have downloaded the reams of documentation and this is a beast, much different than OAS 4.0.8. It requires a 9i db, Oracle Single SignOn, OID, OEM Server, 9i Listener w/ port 1521 free for iAS, etc. So many dependencies for iAS and I

Trigger/character search

2002-10-25 Thread Mike Sardina
Is there any way to do pattern matching in a PL/SQL trigger? In other words, if I had two strings and one ended with a character (ie. g) and one ended with a number, is there a way to search for it so that it would flag if it is only a number? -- Please see the official ORACLE-L FAQ:

RE: what is purify

2002-10-25 Thread DENNIS WILLIAMS
One thought if you are on Unix would to be to use the Unix command strings to search the different libraries and binaries for variations of the word purify. Look at the line Oracle pointed out to you for anything else that you could search for. You can find a surprising amount of information from

RE: Scheduling software

2002-10-25 Thread DENNIS WILLIAMS
Dick - We've ended up using a variety: Built-in Unix cron, our ERP package has a built-in scheduler, and on a home-grown development project the developers wrote their own scheduler so it has the same GUI interface as their application. It is just another screen their users can select. But we are

RE: Trigger/character search

2002-10-25 Thread Balaraman, Arvind
Hi You can do something like this no number(10) ; begin no := to_number(substr(character_with_pattern, length(character_with_pattern),1); -- if the control comes here it is a number -- flag it -- exception when value_error then do not flag it; -- end; -Original

RE: SQL*Plus COPY error

2002-10-25 Thread DENNIS WILLIAMS
Paul - Hopefully you will receive more helpful advice, but I have received strange errors using the COPY command and the reply I received from Oracle support was that it was being phased out and if I didn't like errors I should write a small PL/SQL program to perform this task (give you a copy

RE: Trigger/character search

2002-10-25 Thread Mercadante, Thomas F
Mike, You could try: if substr(:new.column_name,-1,1) in ('0','1','2','3','4','5','6','7','8','9') then do something; end if; Not sure what you want to do in the trigger if the above condition exists. The Substr command can look at the last character of the column for you. Hope this

RE: Trigger/character search

2002-10-25 Thread Mirsky, Greg
Something like this??? DECLARE --x VARCHAR2 (128) := 'abcdefg'; x VARCHAR2 (128) := 'abcdefg123'; BEGIN DBMS_OUTPUT.ENABLE (100); IF SUBSTR (x, LENGTH (x) - 1, 1) IN ('1', '2', '3', '4',

RE: Installing iAS 9.0.2.0.1

2002-10-25 Thread Gary Weber
Gene, Installed and running all (really!) components on Red Hat, HPUX, and Windows. 9.0.2 is better then 9.0.1, in part because it mostly works out of the box. Get ready to troubleshoot various individual components after initial installation. Wait, you will likely be performing two

RE: How to pass value from SQL*Plus to Unix scripts?

2002-10-25 Thread Stephen Lee
I've been gone a few days, so a bit of a delayed reply here. Example: { sqlplus -s -XXX username/password --junk --junk --junk set heading off set feedback off select whatever; exit; -- optional XXX } | sed 's/^[ ]*//g; s/[ ]*$//g; /^$/d' | while read LINE; do code to mess with

RE: Installing iAS 9.0.2.0.1

2002-10-25 Thread Scott . Shafer
Gene, We tried it on HPUX and it was not pretty. We ended up going back to 9iAS 1.0.2.2 for various reasons. Good luck. Scott Shafer San Antonio, TX 210.581.6217 -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 25, 2002 2:34 PM To: Multiple

SQL*Plus COPY error solved (sort of)

2002-10-25 Thread Paul Baumgartel
This COPY script failure occurred when running in SQL*Plus on Windows NT. In SQL*Plus on (Unix) database server, runs just fine, so immediate problem solved. Shouldn't it work from PC, though? --- Paul Baumgartel [EMAIL PROTECTED] wrote: I'm trying to use (for the first time in 15 years of

RE: Memory usage control in Tru64 - urgent !!!

2002-10-25 Thread Kurth, Michael J.
On Tru64 Unix there is a tool called SYS_CHECK which you run which will analyze your system and make recomendations on tuning parameters. You may have to install it from the installation CD if not already installed. -Original Message- Sent: Friday, October 25, 2002 2:19 PM To: Multiple

Re: simple ? question

2002-10-25 Thread Joan Hsieh
Stephane, you are right, after I talked to the developer. She is totally confused by alias name, dbname, schema name. She is referring database name. joan Joan Hsieh wrote: Stephane, Well spoken- my bad. Our developer threw me this question when I was just leaving from work. (I copied

Re: SID and DB_NAME

2002-10-25 Thread ora ak
Thanks Rajesh , well explained . I had same idea . that SID is instance indentifier . -oramagic . [EMAIL PROTECTED] wrote: Simply speaking, consider SID to be the name for the various backgroundprocess (DBWR, LGWR, et all) and the memory structures (SGA, PGA). A SIDneeds to be associated with a

oracle apps documentation

2002-10-25 Thread ora ak
can some one point me in right direction to look for oracle applications documentations. I am specially interested in manufacturing and financials . thanks , oramagic Do you Yahoo!? Y! Web Hosting - Let the expert host your web site

Re: oracle apps documentation

2002-10-25 Thread Tim Gorman
appsnet.oracle.com - Original Message - From: ora ak To: Multiple recipients of list ORACLE-L Sent: Friday, October 25, 2002 3:01 PM Subject: oracle apps documentation can some one point me in right direction to look for oracle applications

RE: oracle apps documentation

2002-10-25 Thread Murray, Margaret
Metalink - top tech docs (left menu) - E-business Suite ERP - module - Documentation (there are also other paths to follow to get to the same place). You'll find user guides and most TRMs Alsocheck out AppsNet: http://www.oracle.com/appsnet/content.html -Original

ole

2002-10-25 Thread Thomas Day
I've been reading the FM's but ... How do you set it up or change the connection? I've read a lot of nice puffery but where in the Oracle manuals will it tell you what need to be modified to make it work? Environment is Client: Win95 C++ - MS Developer Oracle 7.3.4 client Server: Oracle 8.1.7

Oracle DBA vs JAVA programmer???

2002-10-25 Thread Janet Linsy
Hi all, I need your idea. I got laid off as an Oracle DBA (3 yrs experience), and it's hard to find a DBA position here(I'm in Colorado). I had couple of years experience programming (3 yrs) in VB, and currently learning JAVA. I'd like to know is JAVA market still hot? (I can relocate to New

RE: SQL*Plus COPY error solved (sort of)

2002-10-25 Thread Stephen Lee
Some severe rustiness here on this topic; but the mists of time have me thinking that Oracle is looking for the file that contains the text for messages it wants to display, and in your case, it can't find the file. I used to know what file this was and where it was located; but would have to

RE: Oracle DBA vs JAVA programmer???

2002-10-25 Thread Kevin Lange
My only comment is ... New Jersey over Colorado Are you mad woman -Original Message- Sent: Friday, October 25, 2002 5:14 PM To: Multiple recipients of list ORACLE-L Hi all, I need your idea. I got laid off as an Oracle DBA (3 yrs experience), and it's hard to find a

Re: Oracle DBA vs JAVA programmer???

2002-10-25 Thread Alex
DBA would be a safer bet. As far as programmer, don't pigeon hole yourself as a Java programmer but rather someone who knows how to program. But if you only have a few years of VB then you'll wind up doing maintenance. On Fri, 25 Oct 2002, Janet Linsy wrote: Hi all, I need your idea. I got

Re: Oracle DBA vs JAVA programmer???

2002-10-25 Thread Mohammad Rafiq
I shall suggest you to put your resume on monster/dice.com and see the response Market in NJ for DBA is also not very good at this moment..However, I have no idea about JAVA Programmer market. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL

RE: Oracle DBA vs JAVA programmer???

2002-10-25 Thread Wong, Bing
If you are single, get a job wherever it offers and then move back to your favorite place. Try not to be out of job for too long if you can. I have friend got laid off here in CA and got a job in Orlando, FL. And he has family. Bing Wong Open Systems Database Administrator x25721 This e-mail

Re: Oracle DBA vs JAVA programmer???

2002-10-25 Thread Lyndon Tiu
DotNot. Anyone? -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: SQL*Plus COPY error solved (sort of)

2002-10-25 Thread Rachel Carmichael
it's oraus.msg located in rdbms/mesg but that file does NOT exist on Windows systems anymore --- Stephen Lee [EMAIL PROTECTED] wrote: Some severe rustiness here on this topic; but the mists of time have me thinking that Oracle is looking for the file that contains the text for messages it

RE: oracle apps documentation

2002-10-25 Thread ora ak
I am thinking of learning oracle manufacturing myself . Can you suggest which is most proper starting point . I dont know anything abt apps , but know oracle pl/sql and developer 2000 . Thanks , oramagic "Murray, Margaret" [EMAIL PROTECTED] wrote: Metalink - top tech docs (left menu) -

RE: oracle apps documentation

2002-10-25 Thread John Kanagaraj
Oramagic, Please be aware that there are 'Functional' and 'Technical' aspects in Apps. Both require some sort of Business knowledge, much more so with the Functional side. The DBA side of Apps, however, does not specifically require this knowledge. If you want to approach this from a Developer's

Re: ALTER SESSION SET EVENTS '...'

2002-10-25 Thread Mark J. Bobak
True enough, but the level of detail describing most events is distressingly minimal. Unless you already know what the event does, setting it is probably a REALLY bad idea. Of course, what I like to do is create a small throwaway database. Then I can set events to my heart's content, just to

RE: what is purify

2002-10-25 Thread Mark J. Bobak
Also, on unix, to see what dynamic libraries an executable depends on, you can do: ldd executable_name and you'll see the list of shared libraries this executable is dependent on. -Mark PS ldd=list dynamic dependencies, so it does nothing to tell you what static libraries an executable is

checkpoint not complete

2002-10-25 Thread Mike Sardina
I am noticing in the Alert Log that it notes quite often Checkpoint Not Complete. What causes this? Does something need to be tuned? What parameter? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Sardin INET: [EMAIL PROTECTED] Fat City Network Services--

RE: checkpoint not complete

2002-10-25 Thread Jacques Kilchoer
Title: RE: checkpoint not complete -Original Message- From: Mike Sardina [mailto:[EMAIL PROTECTED]] I am noticing in the Alert Log that it notes quite often Checkpoint Not Complete. What causes this? Does something need to be tuned? What parameter? The message is because

Fwd: checkpoint not complete

2002-10-25 Thread Mohammad Rafiq
Increase the size of redologs and add some more group Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 25 Oct 2002 17:03:47 -0800 I am noticing in the Alert Log that it notes quite often Checkpoint Not Complete. What causes this? Does

Joseph Testa has sent you a 10% discount]

2002-10-25 Thread Joe Testa
This is a multi-part message in MIME format. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Joseph Testa has sent you a 10% discount]

2002-10-25 Thread Joe Testa
well that didnt work, ok how about cut/paste :) Joseph Testa bought a few things at Amazon.com and wanted to offer you a discount on them. Its the new RMAN book by Robert Freeman Under Amazon.com's Share the Love program, if you purchase any items from the following list by November 1, 2002,

  1   2   >