Re: ORA-01000: maximum open cursors exceeded

It can be set to much higher values if the need is there. There used to be some kind of limit depending on the various 7-versions as far as I remember. Personally, I haven't seen the need for anything higher than 2000 more than once or twice. Mogens [EMAIL PROTECTED] wrote: Hi I think u

Re: sysdba

i am using Solaris 8. connect / as sysdba the result is i dont have privileges. thank you in advance. [EMAIL PROTECTED] wrote: What is your operating system, database level, and what command are you issuing? Is this the first time this has occurred? David A. Barbour Oracle DBA, OCP AISD

RE: RE: Long running SQL Problem?

Catherine, I am sure that Larry Elkins will forgive my taking the opportunity of being 7 hours ahead of him (and 7 hours behind yourself) for singing the praise of the 'hash anti-join' in his name. And anyway you could remind your senior DBA the existence of NOT EXISTS, far better than

Creating staging area from Windows client

All, I'm trying to install Oracle 8.1.7 on a Solaris box but I don't have physical access to the machine in order to insert the CDs. I'd like to copy the contents of the CDs up to the target Solaris box and create a staging area to perform the install from. The problem is, I've got a Win XP

Slightly OT: Perl Q.

Hi All (Jared in particular), OS: AIX We are trying the following: We have a script that executes and sets all sorts of environment variables. Than after this we execute a perl script that reads the environment variables, however the environment variables set in the first script are not picked

problems in oracle report

Hi All Gurus! I have few problems related to oracle report. Problems are listed below: 1. How can a report be editied after its generation in previewer at runtime? 2. In After_Parameter_Form trigger, we check no of records to be displayed and if it is zero then we are able to display a

Re: Creating staging area from Windows client

Its a kludge but have you tried chmod 777-ing the entire stage area after copying? hth connor --- Hately Mike [EMAIL PROTECTED] wrote: All, I'm trying to install Oracle 8.1.7 on a Solaris box but I don't have physical access to the machine in order to insert the CDs. I'd like to copy

Trigger question

Hallo, What is wrong with this trigger: I want the trigger to fire(to run the statement : UPPER(SUBSTR(:OLD.namn, 1, 1)) || SUBSTR(:OLD.namn,2); after new record is inserted in this table. The thing to happen should be this: I want that script to be run on the same record that has been

Re: problems in oracle report

Hi Atul kumar 1. How can a report be editied after its generation in previewer at runtime? Which object you wanna to edit or modify . 2. In After_Parameter_Form trigger, we check no of records to be displayed and if it is zero then we are able to display a customised message

Re: Trigger question

As the this is a NEW record there is no OLD value! (and would it be bette to use a BEFORE insert?) Regards torben [EMAIL PROTECTED] writes: Hallo, What is wrong with this trigger: I want the trigger to fire(to run the statement : UPPER(SUBSTR(:OLD.namn, 1, 1)) || SUBSTR(:OLD.namn,2);

Re: Creating staging area from Windows client

Hi, Should work fine with binary FTP, Using it right now for the upgrade to 8.1.7.3 W2K and AIX is my environment Jack Hately Mike

RE: Creating staging area from Windows client

Hey Connor, kludges make the world go round! I've got it installed just by making the following files executable : /tmp/scratch/817/disk1/runInstaller /tmp/scratch/817/disk1/install/solaris/runInstaller /tmp/scratch/817/disk1/lsm/lsminst and I haven't seen any problems so far. I think the

RE: Trigger question

Roland, First thing would be that as it is an on insert trigger the OLD reference is not valid (only valid for update and delete I think) though I'm surprised that it accepts the referencing old as old part. Iain Nicoll -Original Message- Sent: Wednesday, April 03, 2002 12:08 PM To:

RE: Trigger question

BDY.RTF Description: RTF file

Re: Trigger question

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 14:08 Hallo, What is wrong with this trigger: many things are wrong with this trigger, for example: - the OLD pseudo column is defined only for UPDATE and DELETE

Re: Unix at command ???

Janet, From the command line type man at and you will see the correct format to enter a at string. The basic format is at -f file_to_execute HH:MM This will execute the file at the time specified if the time is in the future. If the time is in the past it will take the next occurrence of

trace external procedure listener

We have occasional problems with the external procedure listener... ORA-28575 unable to open RPC connection to external procedure agent. We are finding it very difficult to track down the source of these errors. Is there anyway to trace what the external procedure was trying to run when these

RE: Database shut itself down

My NT admins are great for doing things and not telling me. Monday they changed a system password that a mail routing server uses. After a day and a half of trying to figure out what was wrong with the mail router one of the admins finally says, Oh yea, I changed the password. I simply

Re: Database shut itself down

One correction: Oracle holds shared lock on the files, not exclusive. If it'd be exclusive - hot backup would be impossible. Still, shared lock is enough to prevent from deleting, moving, or renaming file. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple

technet download problem

is anyone else able to download anythning from technet, all i get is unable to find server errors. i dont think its a firewall issue as we dont block any ports. thanks, joe -- Joseph S Testa Data Management Consulting http://www.dmc-it.com 614-791-9000 -- Please see the official ORACLE-L

RE: Literal SQL and sys.dual

The error is in your code, you are explicitly telling oracle that the bind variables are varchar2, so why would Oracle evaluate it? Try this ... DECLARE nnum1 NUMBER; nnum2 NUMBER; nresult NUMBER; BEGIN BEGIN nnum1 := 0; EXECUTE IMMEDIATE USING nnum1,

RE: sysdba

Well, with all this info I can't imagine that someone will not be able to help you. -Original Message- paPIpapupapePO Sent: Tuesday, April 02, 2002 9:18 PM To: Multiple recipients of list ORACLE-L i cant connect as sysdba. ORA-01031 - insuffecient privileges. can anybody help me? --

RE: Long running SQL Problem?

I would rewrite it with a where not exists But that is just me. I would also not bother selecting anything in the subquery. Just a 1 or a 'x' would do. Don't return stuff from the database that you don't want. All you care is whether or not there is a record in the subquery not what it

RE: sysdba

Did you create an externally identified account? Did you grant sysdba this priv? Only sys has it automagically. Everyone else needs to have it granted. -Original Message- paPIpapupapePO Sent: Wednesday, April 03, 2002 12:08 AM To: Multiple recipients of list ORACLE-L i am using

RE: Long running SQL Problem?

Use 'exists' or 'not exists' only if you have index on col3 and col4 on table_2 that can be used in the sub-query, else the query will be running like a dog. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN

RE: trace external procedure listener

John, Your error message doesn't seem to hint at a problem with what the external procedure was trying to run specifically, but in the 'call' to extproc. If I were you I'd try to put the listener in trace mode, as it looks like that's where the problem occurs. HTH. - Original Message

Re: sysdba

[EMAIL PROTECTED] wrote: i am using Solaris 8. connect / as sysdba the result is i dont have privileges. thank you in advance. are you starting sqlplus from an account in the DBA group? is the DBA group the primary group? -- -- Bill Shrek Thater ORACLE DBA

Connecting to Oracle via Perl

Hi DBAs, Environment is Oracle 8.1.6 NT 4.0 What is the best way to connect to Oracle using Perl? I do not want to hard-code password in script if not necessary. I could not find a way to embed in dsn creation. Any suggestions/working examples on how to achieve this is appreciated? I do not

Re: 8.0.5 -- 8.1.7 apps upgrade

I've done this in the past: Install 8.1.7 and create a database (same SID as your current database). Create the same tablespaces and users as your current database. Export your old database and import it into your new database. Be sure to use the same level client software for the export and

RE: Dynamic create and execute procedure

execute immediate is your ticket, now not knowing (as Jack puts it) 'desirements', it is difficult to help you further. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is

Help needed

HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is required to partition the database as per financial year.Almost all the tables will be partitioned accordingly. I want to know

Re: Dynamic create and execute procedure

It's called a text editor. Peter.McLarty @mincom.com To: Multiple recipients of list

RE: Connecting to Oracle via Perl

You might want to check out Jared's site since he kind of likes perl. http://www.cybcon.com/~jkstill/util/ Dave -Original Message- Sent: Wednesday, April 03, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Environment is Oracle 8.1.6 NT 4.0 What is the best way to

RE: RE: License standby database?

Yea...I vaguely remember something like that being said to our company back in 2000. I spoke to couple of Oracle Reps and they said as long as you are using the DB for HA environment you don't need to license it separately. I don't know whats going on now. Cheers, RS --- Post, Ethan [EMAIL

RE: Database shut itself down

You are most likely correct Lisa. I have never tried on NT but I have seen that error on Unix and that is one of the most likely causes is that someone has deleted the data file. I can confirm that the delete definitely works under the Unix o/s for better or worse. -Original Message-

RE: Connecting to Oracle via Perl

Hi Rick, Here's what I did... granted I have never been able to get os-authenticated logons to work on Windows (have you?) * Created a config file that has pairs of values (ex: elvis_pw elvis) * Created a module that accepts a hash as a parameter, reads the config file, populates

Re: Help needed

Put each partition into separate tablespace. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 9:18 AM HELP Hi, I am working with Oracle 8i version in our ERP applications. I have

Re: 8.0.5 -- 8.1.7 apps upgrade

How about installing 8.1.7 on your NT server and migrating the database on it's current server? You need the 8.0.5 software to do the migration. The 8.1.7 mig utility is actually placed in the 8.0.5 ORACLE_HOME. Jared On Tuesday 02 April 2002 14:05, Fedock, John (KAM.RHQ) wrote: Looking

RE: RE: License standby database?

HA is different from Standby. Standby is an Oracle DB in recovery, i.e. Oracle running on 2 servers. HA is a DB Server waiting to become the prod DB via shared storage, i.e. Oracle running on 1 server. [EMAIL PROTECTED] 04/03/02 09:28AM Yea...I vaguely remember something like that being

Re: Help needed

Rakesh, You have 2 options. 1. Either create the different partitions on different tablespaces and take backup of selected tablespaces 2. You can take a logical backup using the export utility by providing a query clause for the table. HTH, Naveen --- rakesh banerjee [EMAIL PROTECTED] wrote:

RE: Literal SQL and sys.dual

Thanks for the help. You are right on the money. However, I am getting the data as strings and I do not know what I will get. I get hundreds of thousands of them and I have no idea what they would look like. I might get any string. couple of examples: select 1 + 1 + 1 + 1 from dual select 1 +

SQL Server vs. Oracle 9i

This is interesting: http://biz.yahoo.com/prnews/020403/sfw026_1.html Ken Janusz, CPIM

RE: Dynamic create and execute procedure

http://www.fixedsys.com/context/ -Original Message- [EMAIL PROTECTED] Sent: 03 April 2002 14:48 To: Multiple recipients of list ORACLE-L It's called a text editor. Peter.McLarty @mincom.com To: Multiple recipients of list

Re: Help needed

Give each partition its own tablespace and back up the tablespaces. --- rakesh banerjee [EMAIL PROTECTED] wrote: HELP Hi, I am working with Oracle 8i version in our ERP applications. I have one question regarding the backup of Oracle database. In the database I am designing it is

RE: Help needed

Rakesh, Yes. You can certainly export a single partition at a time for logical backups. If you put each partition in its own tablespace, you can physically back up individual partions as well. Jack Jack C. Applewhite Database Administrator/Developer OCP

RE: sysdba

That's because you didn't read the documentation for Oracle. If you do not have the cd, you can find the sqlplus guide online at http://technet.oracle.com which details all variations, restrictions, and abilities of the connect command. Scott Shafer San Antonio, TX 210-581-6217 -Original

Pinhitratio vs gethitratio

Can someone explain why a pinhitratio would be higher than a gethitratio in the v$librarycache for the namespace = 'SQL AREA'? I would think it would be the opposite. Our current gethitratio is 87.98 and the pinhitratio is 95.10. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: Help needed

Rakesh, Keep in mind the init parameter MAXDATAFILES when you initially build your database. If the original database was built with a small limit then you will have to rebuild to change the MAXDATAFILES parameter. Search the metaslink site for information on changing the parameter if you think

Re: SQL Server vs. Oracle 9i

Consider the source. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 03, 2002 10:03 AM Subject: SQL Server vs. Oracle 9i This is interesting:

RE: Creating staging area from Windows client

I did consider the download option but the part number differs from the CD I have in my hand and I'm not sure whether this reflects the different method of delivery or a slightly different build. Cheers, Mike -Original Message- Sent: 03 April 2002 16:54 To: [EMAIL PROTECTED] Cc: [EMAIL

Re: Help needed

Hi, Thanks for ur answer. Can u please help me in giving the code about how to implement it, i.e. how to write the code specifying the particular tablespace, because as the new financial year will appear, new tablespace will be required. So how it can be managed to put the code in the DDL

Re: Slightly OT: Perl Q.

Lets see the script. Are you sure you are setting the environment variables? Are the scripts being run by the same username? Why don't you set the environment variables in the perl script? On Wed, 3 Apr 2002, Jack van Zanen wrote: Hi All (Jared in particular), OS: AIX We are trying the

RE: 8.0.5 -- 8.1.7 apps upgrade

That's what it is looking like I have to do. Since we are moving the database to a new server, I was trying to save a step if possible. Thanks. John -Original Message- Sent: Wednesday, April 03, 2002 9:58 AM To: Multiple recipients of list ORACLE-L How about installing 8.1.7 on

RE: SQL Server vs. Oracle 9i

I bet following variable is set in the test _ignore_downtime_cost=true; _ignore_reboots_cost=true; Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't

Re: Slightly OT: Perl Q.

You didn't specify the shell you are using but because of the . file syntax I'll ass|u|me you are using sh or ksh. I will also ass|u|me you have the correct perl code. It would have been nice if you included an example of your setup code and perl code butoh well. The correct way to set up

Re: Slightly OT: Perl Q.

-- Jack van Zanen [EMAIL PROTECTED] Hi All (Jared in particular), OS: AIX We are trying the following: We have a script that executes and sets all sorts of environment variables. Than after this we execute a perl script that reads the environment variables, however the environment

RE: Literal SQL and sys.dual

TRy something like this ... CREATE OR REPLACE PACKAGE My_Dynamic_Stuff IS v_result NUMBER; -- PROCEDURE eval_this (pi_string IN VARCHAR2); END My_Dynamic_Stuff; / CREATE OR REPLACE PACKAGE BODY My_Dynamic_Stuff IS -- PROCEDURE eval_this (pi_string IN VARCHAR2) IS BEGIN

Re: SQL Server vs. Oracle 9i

yeah but it was written by MS. [EMAIL PROTECTED] 04/03/02 10:03AM This is interesting: http://biz.yahoo.com/prnews/020403/sfw026_1.html Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services

Re: Creating staging area from Windows client

I have always had access to a local Unix box, inserted and tar'ed the CD's there. If you can't do the same, then go to otn.oracle.com and download it (http://download.oracle.com/otn/solaris/817/817solaris.cpio.gz) Brian P. MacLean Oracle DBA, OCP8i

Re: Connecting to Oracle via Perl

-- [EMAIL PROTECTED] Environment is Oracle 8.1.6 NT 4.0 What is the best way to connect to Oracle using Perl? I do not want to hard-code password in script if not necessary. I could not find a way to embed in dsn creation. Any suggestions/working examples on how to achieve this is

RE: max_open_cursors

Hi All, max_open_cursors of 2000? What programmer can handle 2000 open cursors at once? Remember this is per session. The default is 40, if a programmer can explain to me the cursors he has to maintain open, and that number is 40 then I will

RE: SQL Server vs. Oracle 9i

The Walklett Group, the author of the paper cited, is a consulting/services company and has Microsoft listed on their "Alliances" web page, although the exact nature of the relationship is not defined. The paper makes a number of assumptions that I would question. After reading it, I

RE: RE: License standby database?

Gene, HA means High Avalability. HA is a DB Server waiting to become the prod DB via shared storage, Not really. You can implement HA by any means as long as you ensure you have High Availability. IMHO standby is also something that is waiting to be activated and to become prod server.

RE: Trouble ticketing system

Hi David, Look into REQUEST TRACKER. Open source (perl), many databases. Similar to Remedy byt free. A Google search will find it. Why code when you can install? Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see

RE: SQL Server vs. Oracle 9i

But a clueless CIO or IT Director might be persuaded...and that is the problem. Even more so, when the IT budget is tight...and when is the IT budget not tight?? -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 03, 2002

Re: SQL Server vs. Oracle 9i

And I charge less than Steve Adams or Jonathan Lewis (3.5 times lesser), for 'comparable' features (could be physical). So, hire me, and Save a million in 5 years. Who buys that? ;-) Raj

ORA-00600 error

Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC:ORA-00600: internal

DBA's supporting CERNER

DBA's, If there are any DBA's on the list supporting CERNER medical applications please contact me off list. We are in the decision/planning stages of aquiring this product and I would like to get some advise on how much care and feeding this beast requires. Thanks Jim Howerton Senior Oracle

RE: EMC question

I don't want to start a technical religious war here. Nevertheles, I am not a great fan of raw devices especially after the advent of comparable I/O options such as Direct I/O within Oracle which allows you to keep your file system layout and yet have raw device comparable performance. Plus

Re: Help needed

To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you

Re: ORA-00600 error

Bunyamin, I think you better check the following doc. from metalink... START * Doc ID: Note:31056.1 Type: REFERENCE Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 31-DEC-1996 Last Revision Date: 20-MAR-2002 Note: For additional

RE: RMAN

Dave, I never said setup was easy. I agree that getting the tape software integrated can be a real pain in the side, depending on what vendor you use (DON'T USE CA'S ARCSERVE) As far as backup goes, this is my command for full database backup. Much simpler than strategies I've had to use in

RE: EMC question

No wars! I also agree there are good products out there. But the question will be: can these products offer striping for Oracle OPS/RAC? Using EMC striping would allow this, I believe! note: I'm not working for EMC Regards, Waleed Any views or opinions presented in this email are solely

[Fwd: ORA-00600 error]

Bünyamin, The trace you sent is not enough. But before determining if your memory is enough or not, we should understand if the requested memory size is normal or if UGA shrinks normally . For quick answer: Check session uga memory and session uga memory max statistics. can you attache the

RE: Insert statement hangs

If you have the Diagnostics Pack, try looking at your session in Top Sessions. Beth -Original Message- Sent: Wednesday, April 03, 2002 1:06 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am trying to insert a record thru sql*plus into a table. I am the only one accessing

Re: Insert statement hangs

Rick , check logfiles May be ur database is running in archivelog and archive destinations are full . There are many other possible reasons ..look into alertSID.log for them . -Bigp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April

Re: ORA-00600 error [729]

Is any of export(exp) job is being terminated abruptly? This is the main reason for this message. It was corrected in ver 7.3.4.5. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 03 Apr 2002 10:06:18 -0800 Bunyamin, I think you

Re: Help needed

Rakesh , create your tablespaces as required using system managed or LMT's. I chose LMT and I wanted to control the size of the extents. example: CREATE TABLESPACE IDSR_DATA_02 DATAFILE '/data3/lnxdb/idsr02d.dbf' SIZE 1600 M AUTOEXTEND ON NEXT 20 M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 20 M;

Re: Follow-up :Long running SQL Problem?

CHAN Chor Ling Catherine (CSC) wrote: Hi Gurus, My senior DBA always tell us that the not in command sucks and we are all encourage to use the select count(*). SQL A is greatly frowned upon and SQL B will be the best. SQL A : SELECT col1,col2 FROM Table_1 WHERE (col1,col2) NOT

RE: EMC question

Hello, If you want to use OPS/RAC, I suggest you go with something like an HP-256 disk array (or bigger, depending on your needs; a 256 is good for 1-2 terabytes and can be easily increased); and use mirroring and business copies. Caveat to the above: this is only good for read-intensive, not

RE: RMAN

I used to be a hot backup scripter hack like Dave :-) but now I've been backing up... AND RECOVERING with RMAN for a few years. Setup is the most difficult part but after several times now I'm starting to get the hang of it. You can use the sbttest utility without having to relink Oracle so

RE: Literal SQL and sys.dual

Thanks a million, I am going to try it and let you know how it works out. I can see the result I am looking for. Shakir --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: TRy something like this ... CREATE OR REPLACE PACKAGE My_Dynamic_Stuff IS v_result NUMBER; -- PROCEDURE

RE: Help needed

help received... I was responding to the question about the tablespace partitioning with text and examples. My email package (groupwise) is still randomly limiting the size of the emails. Thanks for helping. Ron [EMAIL PROTECTED] 04/03/02 01:43PM Help given -Original Message- Sent:

Re: SQL Server vs. Oracle 9i

It's fascinating when somebody proclaims "50% savings in TCO over a 5 year period" when it is patently obvious that A)such aconfiguration has not existed over the past five years and B) it will never exist over any contiguous five year period. The lifecycle of systems doesn't happen that

RE: Literal SQL and sys.dual

Hmmm there is a small error The package body should be as follows CREATE OR REPLACE PACKAGE BODY My_Dynamic_Stuff IS -- PROCEDURE eval_this (pi_string IN VARCHAR2) IS BEGIN RTRIM(pi_string,';') || '; end;'; END eval_this; -- END My_Dynamic_Stuff; / this of course assumes that you are

Re: Help needed

Rakesh, Keep in mind the init parameter MAXDATAFILES when you initially build your database. If the original database was built with a small limit then you will have to rebuild to change the MAXDATAFILES parameter. Search the metaslink site for information on changing the parameter if you think

RE: Do programmers tune SQL?

Thanks to everyone that replied to this question. I feel that I have a MUCH more well-rounded view of how this works at other organizations, and where the pitfalls are. I am going to develop a document for the developers that outlines how I see this working. I will share it with the list when I

RMAN Core dumps while restoring datafile

Greetings all, I was trying restore one data file but it core dumps. Following is the log file but didnot specify any error. Any idea. Thanks, Ashoke unix Segmentation Fault - core dumped Recovery Manager: Release 8.1.7.0.0 - Production RMAN-06005: connected to target database: PTESTAKM

RE: Ticket tracking system

The solution of adding a column es very good, but you can create a table to keep the closed tickets(deleted) and if you want to reopen it, just look it in that table and recreate it. Assuming that the quantity of reopened tickets is small this will work for you Luck -Original

DB Trigger to control PK change

Hi List, I want to create a trigger that insert into a table anytime a user change or compile a package doesn't matter who create it or compile it. Is there a trigger at DB level, like the on logon, that I can create to keep this kind of control. I did some FM but couldn't find nothing.

RE: DB Trigger to control PK change

As opposed to using auditing? What version of Oracle? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

Re: SQL Server vs. Oracle 9i

Hi Tim, Nice to see you here -bill At 01:03 PM 4/3/2002 -0800, you wrote: It's fascinating when somebody proclaims 50% savings in TCO over a 5 year period when it is patently obvious that A) such a configuration has not existed over the past five years and B) it will never exist over any

RE: DB Trigger to control PK change

I am not sure there is a trigger to do that Ramon. Why not use the audit option to track changes. John -Original Message- [EMAIL PROTECTED] Sent: 03 April 2002 22:33 To: Multiple recipients of list ORACLE-L Hi List, I want to create a trigger that insert into a table anytime a user

Re: sysdba

i did use the oracle account with primary group as oinstall and secondary as dba. this what the manual tells. [EMAIL PROTECTED] wrote: That's because you didn't read the documentation for Oracle. If you do not have the cd, you can find the sqlplus guide online at http://technet.oracle.com

help - JVM on Oracle

Hello List: I have Oracle 8.1.7 installed. It has includes a fully functional Java virtual machine (VM), as well as the Java class libraries for Sun's Java Development Kit (JDK) 1.2.1. , as readme.txt file states. Locally, I also have jdk1.3.1 installed. You can see this 2 JVM does not match.

Re: sysdba

the acoount that i used was oracle account. primary group is oinstall and secondary is dba. bill thater wrote: [EMAIL PROTECTED] wrote: i am using Solaris 8. connect / as sysdba the result is i dont have privileges. thank you in advance. are you starting sqlplus from an account in

Re: sysdba

guess i missed that somewhere, i've always done dba for both groups , never a problem but that could be since i've been doing oracle since version 5 on msdos. joe paPIpapupapePO wrote: i did use the oracle account with primary group as oinstall and secondary as dba. this what the manual

Re: DB Trigger to control PK change

I am trying to do something similar. I want to trap when new tables and procedures are created so I can issue grants and synonyms. I found in the manual triggers at the schema level but I haven't been able to make them work. From the manual CREATE OR REPLACE TRIGGER On_DDL after DDL ON

another listener.ora

How can I start another listener on same box using another listener.ora file . TIA Bp

RE: Do programmers tune SQL?

Whether a programmer tunes SQL depends on their answer to another question, Does the programmer care about overall application performance? If they do and a significant part of the application involves a database then they need to get on a professional development track to become a Database

  1   2   >