Privileges and PL/SQL code

Hi list I was wondering if there is any way to get the following to work: User A owns all tables, users B,C own PL/SQL code to access A's tables. To work with A's tables from user B and C, I would like to create a role to contain all the object privileges and grant these to B and C. Didn't

RE: Privileges and PL/SQL code

Title: RE: Privileges and PL/SQL code If you don't want to do that, create your pl/sql code under schema A and grant execute on those to B and C. Sorry ... that's the only way to go ... Raj Rajendra dot

AW: Privileges and PL/SQL code

Title: RE: Privileges and PL/SQL code That's what I was afraid of 8-{ ... oh well. Since we have several developer's working on local copies of the code in schemas B, C, etc., I guess I have to grant privileges to all schemas. Thanks for the quick response. Stefan Stefan Jahnke Consultant

Antw: Privileges and PL/SQL code

Hi Stefan, since 8 (i?): have a look at AUTHID CURRENT USER in the docs. This enables using of database roles. Greetings, Guido [EMAIL PROTECTED] 14.07.2003 14.30 Uhr Hi list I was wondering if there is any way to get the following to work: User A owns all tables, users B,C own PL/SQL

Re: Oracle DBA e-books , must read E-books

1)Expert One-on-One (Thomas Kyte) 2) Oracle doc. performance tuning guide. 3) High Performance tuning with Statpacks. (Don Burleson) 4) Scaling Oracle8i 4) Oracle Internals Locks,latche,waits,memory (Steve Adams). And finally this mail group... - Original Message - To: Multiple

Re: Oracle security question

Don, The users need acces to the data that is in the database or what is the purpose of the database? I would change the privileges of the users to CREATE SESSION only and revoke all others. Then I would use ROLES that have select privileges on the tables that they need acces to. By creating

Estimating User Load on the system

Title: Estimating User Load on the system I have been asked to compute the load put on the system by a 'select group of userids'. I know these users and have put something in place where I sample periodically following 1. session stats 2. session io 3. system stats 4. number of sessions 5.

RE: import from 8i to 9i /IMP-00003:ORA-02298

Just to update you all... I am not having any problems if I setup a db link from 9i to 8i and get the data then enable the constraints. Oracle asked me to create a test case for them. I have sent them all the information they have asked for. Thanks, Surendra -Original

Recreating the Temporary segment in a TEMPORARY Tablespace

In earlier versions of Oracle with the TEMP tablespace being Dictionary-Managed but Contents=TEMPORARY, I could recreate or shrink the temporary segment without an Instance restart by executing an ALTER TABLESPACE TEMP DEFAULT STORAGE (PCTINCREASE 0) -- ie any ALTER command for the storage

Performance problems VMS 8i

Oracle 8.1.7.4 OpenVMS 7.2-1 DIGITAL TCP/IP Services for OpenVMS Alpha Ver V5.0A-ECO 3 After an upgrade from Oracle 7.3.4 to 8.1.7.4 on OpenVMS, some (but not all) of our batch jobs are suffering severe performance degradation. One of our critical jobs went from 3 hours to 9 hours elapsed

Re: Estimating User Load on the system

Load on a system is in general comprised of three components: CPU, memory and IO. If you have something in place to track those on a per user basis, then you're doing well. You might consider also tracking other users, so that you have a basis for comparison. Jared On Monday 14 July 2003

Re: Performance problems VMS 8i

I'm going to ask the obvious question: Have statistics been generated for the schemas in question? It's assumed that you're now using CBO, and if stats have not been generated, then CBO is making assumptions about the nature of your data. Jared On Monday 14 July 2003 07:54, Barbara Baker

RE: Estimating User Load on the system

Raj I'll second Jared's idea. Don Burleson in his book Oracle9i High-Performance Tuning with STATSPACK makes a strong point that looking at system load must start with the underlying system. Any look at Oracle performance must begin with an understanding of what the system load was at that

RE: Estimating User Load on the system

I'll add my favourite - and currently overlooked - point. Network. Not the entire network as a whole, but specific server things like NIC performance, protocol stack performance, MTU (see recent excellent post by Matt on jumbo frames), and all that jazz. my 2¢ Ciao Fuzzy ;-) -Original

RE: Estimating User Load on the system

Title: RE: Estimating User Load on the system Thanks Dennis, I have periodic (10 mins) snapshots taken of following views ... 1. gv$session 2. gv$sesstat 3. gv$transaction 4. gv$sess_io 5. gv$sysstat Now, I really _can't_ use Statspack, because it tells me overall score. I need to

MicroSlop DTC

To All, especially any WEB developers out there. We've a WEB based application that uses MS DTC. OK, so we turned on XA in the database, but the web servers do not want to play with our normal ONmase setup. Instead they only want to work with a TNSNAMES.ORA file in the appriopriate

Oracle user groups in Bangalore, INDIA

List gurus, Are there any oracle user groups in Bangalore, INDIA? My nephew is an upcoming Oracle DBA. He would like to participate in user meetings relevant to Oracle in Bangalore area. Any help will be greatly appreciated. Thanks, Govind -- Please see the official ORACLE-L FAQ:

Re: Antw: Privileges and PL/SQL code

You will need to grant privileges directly to B and C on A's objects. Since B and C use PL/SQL code, other users only need to have execution permission on B and C's procedures. Using AUTHID CURRENT USER in the creation of the stored programs would require that the stored programs execute under

Re: MicroSlop DTC

I've seen this happen with older versions of the sqlnet client (Different application, same symptom). What version of the client are you using? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

RE: Estimating User Load on the system

Raj, Assuming that these users will logoff normally (for the most cases), you could have a database level LOGOFF trigger that captures the following 'stats' from these sessions (out of v$MYSTAT): CPU used by this session (Cpu time used) user commits (Number of transactions - figuratively!)

RE: Estimating User Load on the system

Title: RE: Estimating User Load on the system Thanks John ... this is precisely (the logoff trigger) is what I am in middle ot writing down ... except that I am taking everything from v$sesstat instead of selective stuff. I can then filter out what I don't need. Raj

Re: Oracle security question

Hi Don, I wrote a paper for securityfocus.com a while ago that described a simple security scanner for Oracle, there is also a script you can run with the paper. You can get the link on my Oracle security papers page on my site at www.petefinnigan.com/orasec.htm, the paper is near the top and is

dbf and cdx files

I have got some *.cdx and *.dbf files to load . Any Idea what are these files and how can I open them ? -ak

Re: dbf and cdx files

clipper/dbase III/foxbase/foxpro? joe AK wrote: I have got some *.cdx and *.dbf files to load . Any Idea what are these files and how can I open them ? -ak -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official

RE: MicroSlop DTC

9.2.0.1.0 On Win 2K. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, July 14, 2003 1:54 PM To: Multiple recipients of list ORACLE-L I've seen this happen with older versions of the sqlnet client (Different application, same symptom). What

Re: dbf and cdx files

The dbf are databases of Fox, Clipper or DBase. And the cdx, I am not sure but maybe are index. You can open the dbf's with MicrosoftExcel, DBUor DBASE. In excel select data type DBase. [EMAIL PROTECTED] 07/14/03 12:29PM I have got some *.cdx and *.dbf files to load . Any Idea what are

RE: MicroSlop DTC

Hum, does tnsping resolve the service correctly? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

RE: dbf and cdx files

Are the dbf files dbase files? If so, I have something that you might be able to use or adapt to your purposes. -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, July 14, 2003 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: dbf and cdx files I

RE: dbf and cdx files

Toss paradox in too.. YOu might be able to find and old dbf to ascii test converter utility.it might still run in a DOS box on WIndoze... Old excel version from Office 95 might be able to open them. You would need to set up 95 or 98 to install... either wayugly -Original

oracle last

hi is there a statement like last in mysql ? last returns a specified number of rows from a select. means if i do a select and i want only the last 3 lines. thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer INET: [EMAIL PROTECTED] Fat City Network

RE: MicroSlop DTC

Yes, as well as SQL*Plus and ODBCTST. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, July 14, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Hum, does tnsping resolve the service correctly? Ron Thomas Hypercom, Inc [EMAIL PROTECTED]

Re: Oracle security question

Dear Guang Mei: Thanks for your message. Your suggestion is very helpful. After reviewing all possible uesers, I have locked them. Now I have only one concern that if nobody knows my database's sys and system's password, there should be no way to unlock these accounts. Am I complete right?

RE: LISTENER ON LINUX

A simple ps -ef|grep lsnr will work. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, July 11, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't

oracle listener

hi i run oracle8 on w2000 advanced server. my question is how to create a auto increment primary key for this table: id number(5) name varchar(12) id should auto increment after inserting a new datarow must i create a trigger ? excuse my bad english thx martin -- Please see the official ORACLE-L

RE: Performance problems VMS 8i

Hi Barbara After an upgrade from Oracle 7.3.4 to 8.1.7.4 on OpenVMS, some (but not all) of our batch jobs are suffering severe performance degradation. One of our critical jobs went from 3 hours to 9 hours elapsed time. The reason is obvious. The solution is not. One of our jobs

RE: MicroSlop DTC

If you are using Microsoft Transaction Server, then be aware that there is a crucial patch to 9i that enables it to work correctly. Oracle shipped a wrong dll oramts.dll with 9i that breaks MTS. I tried 3 times with metablink to find out what was wrong before the software supplier pointed this

RE: Oracle security question

Don Well, if you changed the password, then you should have the new password. Don't post them, because everyone on the internet will have them. What is your Oracle version? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday,

Re: dbf and cdx files

Looks like foxpro files . Trying to open using odbc driver . -ak - Original Message - From: Stephen Lee To: Multiple recipients of list ORACLE-L Sent: Monday, July 14, 2003 11:54 AM Subject: RE: dbf and cdx files Are the dbf files dbase files? If so, I

RE: dbf and cdx files

Attached (I hope) is a C prog I slapped together to take the contents of a DBF file and blow it out to a SQL Loader dat file. I got most of the info from asktom.oracle.com. He has apackage posted there to read a DBF file and insert rows into an oracle table. It is a robust, general-purpose

Re: oracle last

Depending upon the version, you may be able to use the analytical functions (8.1.6+) to achieve what you want. I don't have a ready example, but the Oracle docs are pretty good. If you want a less elegant solution, use an inline query, sort by the reverse order (asc or desc depends on your

Perl Question

I am mucking through my first real perl script. When it is finished it will install statspack on all of the database throughout the company. That's a gob of databases! To run in batch mode statspack requires two define statements: define default_tablespace = tablespace_name define

RE: dbf and cdx files

I looked through the copy of the C program file I sent and spotted the following error: if(i + 1 p_hdr.no_fields) write(out, ::, 1); There should only be one : in the string ... unless you want ::, in which case, change the 1 to 2. This isn't really an error since only one : is going to

Re: oracle listener

Hello Martin, You can create a sequence in Oracle and assign it to the table. You don';t have to create trigger on it. Hope this helps Raju. sorry for my english too :) --- pfeffer [EMAIL PROTECTED] wrote: hi i run oracle8 on w2000 advanced server. my question is how to create a auto

RE: Estimating User Load on the system

Hello folks, Recently, I employed a similar approach in ourtest database to figure out the problematic queries during a certain load test. I used a logon trigger with just 2 statements : alter session set max_dump_file_size = unlimited; alter session set sql_trace = true; The init.ora

Re: Perl Question

Pete, Even as a rabid Perl fanatic, I still use KSH to install statspack. I just modified the stock scripts a bit so they will run without user input. You can do it in Perl, but ksh is probably the tool for this job. Jared Peter Barnett [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

RE: Estimating User Load on the system

Hello folks, Recently, I employed a similar approach in ourtest database to figure out the problematic queries during a certain load test. I used a logon trigger with just 2 statements : alter session set max_dump_file_size = unlimited; alter session set sql_trace = true; The init.ora

How to make SPFILE in sync with INIT.ORA ?

Guys, i have a 9iR2/win2k test instance. i just renamed CONTROL01.CTL once and tried to start the instance. SQLstartup But it gave a ORA-00205 error. so i removed CONTROL01.CTL from INIT.ORA file and started the instance SQLstartup pfile='d:\oracle\admin\pe92\pfile\init.ora' Now it worked

RE: How to make SPFILE in sync with INIT.ORA ?

USE shortcut like soft link for unix -Original Message- Sent: 15 July 2003 10:59 To: Multiple recipients of list ORACLE-L Guys, i have a 9iR2/win2k test instance. i just renamed CONTROL01.CTL once and tried to start the instance. SQLstartup But it gave a ORA-00205 error. so i removed

Re: How to make SPFILE in sync with INIT.ORA ?

make spfile from pfile; something like that. I would suggest just deleting it altogether. :) - Kirti --- Prem Khanna J [EMAIL PROTECTED] wrote: Guys, i have a 9iR2/win2k test instance. i just renamed CONTROL01.CTL once and tried to start the instance. SQLstartup But it gave

Re: How to make SPFILE in sync with INIT.ORA ?

Try OEM it has a couple of ways to help you do this. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 14, 2003 11:19 PM make spfile from pfile; something like that. I would suggest just deleting it altogether. :) -

Re: How to make SPFILE in sync with INIT.ORA ?

As user sys, issue CREATE SPFILE FROM PFILE; This will create the spfile. You must have started the database using the pfile to use this command. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 14, 2003 10:59 PM

RE: Estimating User Load on the system

Thanks, but I am _not_ looking for culprits ... and I will be collecting this data over a week so collecting traces is not an option. I have queries run by research dept that routinely scan millions of rows, multiple times a day... EMC should be happy though ... Thanks again Raj

Thanx--Re: How to make SPFILE in sync with INIT.ORA ?

Thanx a lot Arup,Kirti,Arun and others. It worked Thanx a lot once again. i accidentally deleted my mails. sorry i couldn't thank everyone in person. Thanx and Regards, Jp. 15-07-2003 13:25:15, Arunkumar [EMAIL PROTECTED] wrote: Fire the following commands . 1) startup

OEM Repository Problem

Hi Listers, I had OEM repository on my database installed on my PC. Accidentally I dropped the database. Now I have recreated the database. But an not able to use this database to create New OEM repository as the OEM config assistant says that the database already had a repository