Re:

yes coz I am a novice Oracle Certifiable DBBS - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, July 06, 2001 11:45 AM > Hello guys, > > can anyone tell me how can i have two versions of oracle on the same > machine. Is it possible. >

Urgent: modify column name

hi every body, I'm on oracle 7.3.4 is it possible to mdify a column name ? very urgent !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cal

Re:

u can always have multiple oracle homes on NT. create new home for installing new version. if u want to install higher version it will ask u for migrating the DB. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipie

OT-Oracle User Groups in India

Hi,   I wanted to know if there are any Oracle User Groups in India. I visited  http://www.eoug.com/usergroup-list.htm which lists all the user groups, the two links provided for India don't seem to be the proper ones. One is UKOUG and the other link does not work. I am in Bangalore, India La

No Subject

Hello guys, can anyone tell me how can i have two versions of oracle on the same machine. Is it possible. I have to put together 8.1.6 and 8.1.7 on the same machine. I'm using Windows NT. Thanks in advance Tom Pilfer _ G

Re: OT: Learning Curve for Informatica ETL Products

Larry, I took several training courses last year for one of their competitors products, Ardent Datastage, though it's called something else now. Anyway, they're very similar, we evaluated Informatica also. They are both very powerful products. If my experience with the Ardent products is any

Re: Schema organization

ya gotta love them new triggers in 8i. I used a similar scheme to keep duhvelopers from changing the passwords on common development accounts, because they would promptly forget them and call the DBA. Jared On Thursday 05 July 2001 09:21, JOE TESTA wrote: > yeppers, if you want to prevent dd

RULE versus CHOOSE

Database = Oracle 8.1.7.0.0 on SunOS 5.6 . Current Database Size = 20 GB This is only a Test One & the Live Production will be a BIGGER (100 GB) One . OPTIMIZER_MODE = RULE & NO Statistics Exist Currently Qs.1 How does optimizer_mode=CHOOSE Compare with RULE ? Qs.2 Is there ANY Benefit of keep

Re: urgent..! how to combining 2 querries...

thanks to all. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 9:41 PM > > > -Original Message- > Sent: Wednesday, July 04, 2001

Re: OFA (Optimal Flexible Architecture) in practice

Linda, Try ls -ltr /*/oradata/db_name1/* Didn't think of that, didja. It's actually pretty cool that (in Unix) you can actually reference all your data/log/control files with one filespec. Doesn't work well on NT, but it's better than non-OFA. HTH, Yosi   "Hagedorn, Linda" wrote:   Does anyone us

Re: temp tablespace is permanent tablespace

On July 5, 2001 07:55 pm, [EMAIL PROTECTED] wrote: > Hi, > One of the generic users (multiple people use the same > logon/password) on one of my db's has been assigned temporary > tablespace which is a permanent tablespace type, i.e. > (select contents from dba_tablespaces where > tablespace_name

Re: OFA (Optimal Flexible Architecture) in practice

>Does anyone use OFA as their company standard? If so, are there any >complaints about it's structure? For example, the commingling of >different database subdirectories under a given mount point? > >e.g.. > >/u02/oradata/db_name1/userdata01.dbf >/u02/oradata/db_name2/userdata01.dbf >/u03/oradat

OT: Learning Curve for Informatica ETL Products

Listers, For any of you who use Informatica ETL products such as PowerMart and/or PowerCenter, how steep is the learning curve for these products? I know there are lots of variables such as how quickly does the person pick up new things, are we talking about learning the basics and doing simple t

RE: Listing parameters changed at the session level

Walt, How about select * from v$parameter where ismodified ='MODIFIED'; Extract of doco is below (817 reference manual on v$parameter) ISMODIFIED VARCHAR2(10) Indicates how the parameter was modified. If an ALTER SESSION was performed, the value will be MODIFIED. If an ALTER SYSTEM (which w

OFA (Optimal Flexible Architecture) in practice

Title: OFA (Optimal Flexible Architecture) in practice Does anyone use OFA as their company standard?  If so, are there any complaints about it's structure?  For example, the commingling of different database subdirectories under a given mount point?  e.g.. /u02/oradata/db_name1/userdata

Re: Listing parameters changed at the session level

Hi Walt - Kinda getting into this myself recently. I found a reference to an undocumented dbms package on Metalink today called: dbms_system.read_ev I'm playing around with their test scripts to see what I can do with this in conjunction with v$session and tracing and auditing. Check out note

RE: temp tablespace is permanent tablespace

Hi Lyuda, What platform and what version? If on 815 and using global temporary tables (GTTs) then perhaps the temp tablespace was set to permanent to avoid some of the errors associated with GTTs. That said, by having the tablespace with permanent contents, the performance is probably worse. Al

RE: OT: Ari and his company have been noted in InfoWorld.

Ethan, Your scenario reminds me that I should have invested in paper company stocks when the paperless office was being theorized. Much of the "inefficiency" in which we indulge is due to extremely poor craftsmanship on the part of the people who produce packaged applications. When the applica

Re: How to precreate tables for migration?

Since you mentioned partitioned tables, watch out for: Bug 973502 THE PARTITIONED INDEX IS NOT IMPORTED AS A PARTITIONED INDEX If you are happy with the storage parameters, you can skip steps 3 and 4, because step 5 creates everything for you - except the above !! >>> [EMAIL PROTECTED] 07/0

temp tablespace is permanent tablespace

Hi, One of the generic users (multiple people use the same logon/password) on one of my db's has been assigned temporary tablespace which is a permanent tablespace type, i.e. (select contents from dba_tablespaces where tablespace_name=my_ts_name; returns PERMANENT). I was told by let it stay t

RE: OT: Ari and his company have been noted in InfoWorld.

Michael, No not all databases are the same but many are. DBA's as a whole are extremely inefficient. Most of us well know that we could automate much of what we do if we just sat down and thought about it for a second. I mean come on, why should a DBA have to actually check dozens of V$ views

RE: 11 disks to build a DB, suggestions

Hi Rahul, and Yosi I misunderstood you Rahul I'm sorry, you need both redo logs (log01 and log02, these are different redo goups and not different members of the same group, as I thought) (Yosi is right about this, off course) Now according to this information, I'll be still consistent with my f

RE: can/do indexes chain?

Update in the index is done as delete and insert, so there is no chaining. Alex Hillman -Original Message- Sent: Thursday, July 05, 2001 5:46 PM To: Multiple recipients of list ORACLE-L I've been asked to create an index which combines two fields, date & location. For reasons I don't r

HOW MUCH % SGA SHOULD BE FREE IN OLTP?

Hi In general how much % SGA should be free in OLTP ? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [

Re: can/do indexes chain?

Charlie Mengler wrote: > > I've been asked to create an index which combines two fields, date & location. > For reasons I don't really want to explain, we need/desire this index to > be in the order of date, location. The minor gotcha is that while location > will be populated at the time the rec

RE: OT: Just chatter about Wireless costs and PocketDBA

Most fun I ever had with my PalmPilot was when I took it up in the hills and shot it with my Remington .300. I don't miss it a bit. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Thursday, July 05, 2001 2:41 PM To: Multiple recipients of list ORACLE-L Ross, What I

Listing parameters changed at the session level

Okay, I've consulted all of the Oracle posters I have pinned to the wall here -- my TUSC posters, the Computer Associates poster -- and I've now gotten desperate enough that I'm starting to dig into the Oracle documentation on Technet. But, I figured I'd post to the list and risk getting a few R

Stand alone Procedure v/s Package Procedure

> Hi, > > What are the advantages/disadvantages of using procedures in a package as > compare to stand alone procedures in application. > > Thanks > Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network

RE: * Oracle DBA Needed in Phoenix..

Title: RE: * Oracle DBA Needed in Phoenix.. Jonathan, I think if we retranslate it, we can ascertain what Bill was talking about. >>We would like to submit someone who is a renter and who is interested in Phoenix... We aren't telling you that this company doesn't really want you long term.

Re: * Oracle DBA Needed in Phoenix..

On 07/05/2001 3:41:08 PM, Jonathan Gennick is quoted as saying: . . . .|Thursday, July 05, 2001, 4:15:20 PM, you wrote: . . . .|O> We would like to submit someone who is a renter and who is interested . . . .|O> in Phoenix but has not applied to Phoenix companies and is not working with . . .

RE: * Oracle DBA Needed in Phoenix..

I was this close to working at seven-11, you know? *mandatory "Fast Times" quote* -Original Message- Sent: Thursday, July 05, 2001 5:41 PM To: Multiple recipients of list ORACLE-L Thursday, July 05, 2001, 4:15:20 PM, you wrote: O> We would like to submit someone who is a renter and who

RE: OT: Ari and his company have been noted in InfoWorld.

I wonder if a similar thought was echoed in 1991? Maybe all of the DBAs that were former DB2, etc DBAs could offer some war stories here. It's funny that databases have become more cumbersome to manage, not easier IMHO. DBAs have to understand more technologies that are outside the RDBMS box tha

Re: * Oracle DBA Needed in Phoenix..

On 07/05/2001 3:41:08 PM, Jonathan Gennick is quoted as saying: . . . .|Thursday, July 05, 2001, 4:15:20 PM, you wrote: . . . .|O> We would like to submit someone who is a renter and who is interested . . . .|O> in Phoenix but has not applied to Phoenix companies and is not working with . . .

RE: * Oracle DBA Needed in Phoenix..

Ditto. This 'renter' thing sounds like some sort of thinly veiled discrimination. -Original Message- Sent: Thursday, July 05, 2001 2:41 PM To: Multiple recipients of list ORACLE-L Thursday, July 05, 2001, 4:15:20 PM, you wrote: O> We would like to submit someone who is a renter and who

RE: OT: Just chatter about Wireless costs and PocketDBA

But you can play games on them. I actually used to think the same way until the company agreed to by me one. Since I use Outlook so much they are actually quite nice to have. Now, instead of carrying a day timer I carry a Palm. Makes life easier for me. Now I am going to go get the software to

can/do indexes chain?

I've been asked to create an index which combines two fields, date & location. For reasons I don't really want to explain, we need/desire this index to be in the order of date, location. The minor gotcha is that while location will be populated at the time the record is created, the date field is

Re: * Oracle DBA Needed in Phoenix..

Thursday, July 05, 2001, 4:15:20 PM, you wrote: O> We would like to submit someone who is a renter and who is interested O> in Phoenix but has not applied to Phoenix companies and is not working with O> other recruiters for Phoenix companies. Now why in the world would any of this matter? Best r

RE: SQL ERROR--Nebulous definition

Title: RE: SQL ERROR--Nebulous definition It's saying that execute permissions on sys.dbms_sql must be granted  to ROSTERDBA Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like   trying to club someone to death with a loaded Uzi.

RE: Re[2]: OT: Ari and his company have been noted in InfoWorld.

and 3) if you are working on that stuff while running from a grizzly you are either planning on getting killed or a REALLY fast runner able to concentrate on many things at once in the face of death >From: "Weaver, Walt" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipient

RE: OT: Ari and his company have been noted in InfoWorld.

I for one think Ari and his company need to be commended. In the future you and I will be capable of admin'ing and monitoring multiple databases via handhelds. Larger consulting companies will likely have teams of DBA's that are responsible for large pools of databases. New databases will be ad

Strange explain plan

Hi all. I'm having problems with the following query: select a1.MBR_TYP_CDE MBR_TYP_CDE, (COUNT ( DISTINCT a1.NOVS_NTWRK_MBR_KYD )) from MDSS_STAR.NOVUS_NETWRK_MBR_D a1 group by a1.MBR_TYP_CDE It fails with ora-06000 (parameter 15851). I have noticed that if I created the new table NOVUS_N

Sorry---I figured it out.....FW: SQL ERROR--Nebulous definition

Sorry for wasting the bandwidth lc -Original Message- Sent: Thursday, July 05, 2001 4:00 PM To: ORACLE-L@fatcity. com Cc: Lisa R Clary I have some simple procedures in a DEV instance that run just fine (e.g. enable_constraints, drop_table, insert_data). When I import them into the

Re:OT: Just chatter about Wireless costs and PocketDBA

Ross, What I was talking about is the added expense of wireless connectivity for a PDA. Personally I don't own a PDA and have no desire to do so. Dick Goulet Reply Separator Author: "Mohan; Ross" <[EMAIL PROTECTED]> Date: 7/5/2001 11:19 AM Whi

Re: "ALTER SYNONYM"?

Rick Osterberg wrote: > > Well, here's what I'm trying to do. I've got a pile of tables that are > read-only tables that are downloaded periodically (approximately daily) > from another system. They get slurped into our database via sqlloader. > > A previous incarnation of this process had the

RE: How to precreate tables for migration?

Hey Don! GREAT info! I'm wiping out my test DB right now to try it out. I already have the scripts to create the TSs (I've learned a little in three years), so that's no biggie. I'll letcha know what happens. THANKS! :) Rich Jesse System/Database Administrator [EMAI

SQL ERROR--Nebulous definition

I have some simple procedures in a DEV instance that run just fine (e.g. enable_constraints, drop_table, insert_data). When I import them into the PROD instance, they won't compile stating that PROCEDURE ROSTERDBA.DROP_TABLE On line: 7 PLS-00201: identifier 'SYS.DBMS_SQL' must be declared. I am

RE: Re[2]: OT: Ari and his company have been noted in InfoWorld.

We did something similar to this 4 years ago using the 2 way pagers, email, home grown algorithm similar to secure key(give me a number and I'll check to see if it's the correct sequence), and a heck of a lot of PERL programming. So IF WE HAD COVERAGE on the 2-way pager(RIM pager using bellsouth's

* Oracle DBA Needed in Phoenix..

If you're interested in a great opportunity, then consider this position in Phoenix, AZ with a leading company that needs an Oracle DBA to join its' I.T. staff. We would like to submit someone who is a renter and who is interested in Phoenix but has not applied to Phoenix companies and is not wor

Re[4]: OT: Ari and his company have been noted in InfoWorld.

Thursday, July 05, 2001, 3:40:31 PM, Walt Weaver wrote: WW> Well, we have remote access from home too, but it might be convenient to be WW> able to do this stuff while I'm running from a grizzly in the Absarokas. I hope I never have the opportunity to run from a grizzly. I once bumped (not litera

RE: Tracing Events - Anybody have a list of the Events?

Yeah, thanx all. It seems us poor NT users can't see the events list. We only rate an MSB file, not an MSG file. > -Original Message- > From: Scott Shafer [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 3:19 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Tracin

RE: Re[2]: OT: Ari and his company have been noted in InfoWorld.

Well, we have remote access from home too, but it might be convenient to be able to do this stuff while I'm running from a grizzly in the Absarokas. That way I wouldn't have to hang around the house all weekend waiting for a call that might never come. Of course it's a moot point for us since (1)

OT: Just chatter about Wireless costs and PocketDBA

While i don't shared DG's feelings about the size and resource consumption of the PocketDBA, I do share his feelings about the cost of the wireless access. Around here, Ricochet for the Palm PDA runs about 50$ a month or so. What bullsh*t! When I get wireless for an additional 10$ a month, I

Re: Tracing Events - Anybody have a list of the Events?

Try oraus.msg (if it exists). Sorry I don't have an NT install (woohoo! ;-) to check on... Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: > > Checking my oraus.msb file on NT, I don't see any list > of events. Am I missing it or is it not there? I'm on > 8.1.7 (didn't see it on 8.1.0 e

Re: How to precreate tables for migration?

for precreatng the users, pull the create users statements out of the .dmp file.   joe   >>> [EMAIL PROTECTED] 07/05/01 02:35PM >>>So,We're taking the leap from 8.0.6 to 8.1.7.  For various reasons, we will beusing the export/import method of migration.Since I'll have the DB all to myself fo

RE: Tracing Events - Anybody have a list of the Events?

Only in UNIX -Original Message- Sent: Thursday, July 05, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi > -Origi

Re: How to precreate tables for migration?

As I impose order on our servers, (moving from project-managed to dba-managed db's) I perform this sort of task for individual schemas. The short form is the same as yours except: 3.5) create schemas where tables or tablespace assignments will change. 4.5) create tables that are to have storage

InterMedia Gurus

Any one you guys/dolls out there who are really using InterMedia, this one is for you Have you come across a good, single user scanner/OCR combo for putting hardcopy into a db under InterMedia? I have a bunch of dox i'd like to put on a CD or DVD, but want very high quality OCR and don't wan

Re[2]: OT: Ari and his company have been noted in InfoWorld.

Where I am the amount is zero as we all have remote access from home already. What one can quantify is the amount of extra $ it costs for a VPN dial-up line vs. the wireless connectivity this monster requires. Now that comes to something (what I am not privy to), so good-bye PocketDBA. Dick Gou

RE: Tracing Events - Anybody have a list of the Events?

msG -Original Message- Sent: Thursday, July 05, 2001 2:36 PM To: Multiple recipients of list ORACLE-L Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi > -Original Messa

How to precreate tables for migration?

So, We're taking the leap from 8.0.6 to 8.1.7. For various reasons, we will be using the export/import method of migration. Since I'll have the DB all to myself for the weekend, I want to also partition most of our larger tables (1M-7M rows each -- it's not a huge DB) in the migration. My plan

RE: Tracing Events - Anybody have a list of the Events?

Checking my oraus.msb file on NT, I don't see any list of events. Am I missing it or is it not there? I'm on 8.1.7 (didn't see it on 8.1.0 either). Thanks, yosi > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 2:07 PM > To: Mult

RE: "ALTER SYNONYM"?

Rick, If your current process works for you, that's great! My only thought was that, since you are already sqlloading the data, why not right a PL/SQL procedure that would process the transactions into the existing table. For example, read a record from the sqlloader table, look for a matching

Re: OT: Ari and his company have been noted in InfoWorld...

If only it were this simple: "..quantify the amount of time and money their companies would save if their DBAs.could remotely... remove from the database a user who is running a command that is holding up the system." David A. Barbour Oracle DBA, OCP AISD 512-414-1002

Re: Tracing Events - Anybody have a list of the Events?

Very cool, Thank You. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Scott Shafer

OT: Ari and his company have been noted in InfoWorld...

Ari and his company have been noted in InfoWorld... EPHRAIM SCHWARTZ "Wireless World" InfoWorld.com Thursday, July 5, 2001 REDUCING THE COST OF DBAS Posted at J

Change Manager problem

Has anyone seen this? Change Manager (OEM 2.2.) on my machine takes a snapshot of Oracle 7.3. databases all right, but when I try to compare this baseline against an existing 8.1.7. database (or a baseline of same), Change Manager does not detect the tablespaces, views, tables, triggers from the

RE: "ALTER SYNONYM"?

Hi Rick, How about creating a private synonym for FOO_A and a public synonym for FOO_B. When you drop the private synonym, the public synonym takes effect immediately, and when FOO_A is ready for usage again, you can create a new private synonym. That way there's always a table available. Just a

RE: Online backup script..........

Amen and Bravo, Jared. -Original Message- Sent: Thursday, July 05, 2001 12:46 PM To: Multiple recipients of list ORACLE-L Now THAT is both useful AND entertaining! > -Original Message- > From: Jared Still [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 04, 2001 7:36 PM > T

RE: Tracing Events - Anybody have a list of the Events?

All the events are there in $ORACLE_HOME/rdbms/mesg/oraus.msg The ones you're interested in are the ones above 1. Regards, Waleed -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 12:11 PM To: Multiple recipients of list ORACLE-L Morning Folks - Hope t

RE: Online backup script..........

Now THAT is both useful AND entertaining! > -Original Message- > From: Jared Still [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 04, 2001 7:36 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Online backup script.. > > > > Robert, > > After going through the a

Re: Tracing Events - Anybody have a list of the Events?

Look near the end (~70% through) of the $ORACLE_HOME/rdbms/mesg/oraus.mesg file (on unix at least) for events. This is about all I could find. Anyone else? Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: > > Morning Folks - > > Hope those of you in the US had a safe and happy 4th - fo

RE: 11 disks to build a DB, suggestions

Diego, I think log02 is not a redundant log01, I'm pretty sure it's the second redo log group, without which it will be pretty difficult to run the database :-). Maybe Rahul shouldn't delete it. Yosi > -Original Message- > From: Diego Cutrone [mailto:[EMAIL PROTECTED]] > Sent: Tuesday,

Mac OS X client for Oracle coming?

This is from www.gmsv.com from yesterday. Oracle has embarked on an effort to develop client software that will connect Oracle database applications to workstations running Apple's new Mac OS X operating system

Tracing Events - Anybody have a list of the Events?

Morning Folks - Hope those of you in the US had a safe and happy 4th - for those of you who didn't celebrate this particular holiday, hope your day was also safe and happy ( every day should be safe and happy!). I'm trying to set up some tracing for various events/levels. Not using OEM. In th

RE: Schema organization

yeppers, if you want to prevent ddl on tables when you are required to give out the schema owner password, you put those triggers on all of the objects.  This assumes the user logging does NOT have alter any trigger.  The triggers are owned by a separate userid and look like this(besides you

RE: DB on NT

I tend to leave out the sid in a datafile name, saves me from having to rename it, if i'm doing the transportable tablespace ordeal.   joe   >>> [EMAIL PROTECTED] 07/05/01 12:03PM >>>ALso, what does "1GB" actually mean? That much data, if you dumped itall out into a CSV file? A 1GB tablespac

RE: RUPD$_ (long)

Amarillo is still beautiful.. although the natives don't seem to share my enthusiasm. Yeah, I found this... I was just hoping for... more. I can find considerable stuff on mlog$_<> tables, but I'm still digging on this one. I love the 'documenation' on some of these 'features'. Thanks Apri

RE: urgent..! how to combining 2 querries...

-Original Message- Sent: Wednesday, July 04, 2001 2:53 PM To: '[EMAIL PROTECTED]' I think you need this > comp sum of nfrags totsiz avasiz on report break on report col tsname format a16 justify c heading 'Tablespace' col nfrags format 999,990 justify c heading 'Free|Frags

Re: "ALTER SYNONYM"?

Well, here's what I'm trying to do. I've got a pile of tables that are read-only tables that are downloaded periodically (approximately daily) from another system. They get slurped into our database via sqlloader. A previous incarnation of this process had the setup run sqlloader on the data ta

RE: Schema organization

So what your DDL triggers are doing. And if they do not allow DDL to work how you can execute DDL - disabling these triggers? Alex Hillman -Original Message- Sent: Thursday, July 05, 2001 8:00 AM To: Multiple recipients of list ORACLE-L i try to play by the same rule as you. but if i

Where is the lock?

On of our applications is reporting a problem trying to access on a record in a table. The application is reporting that a transaction is reserved for update. The app in question hung whilst working on the record a few days ago. I'm not convinced that this is an Oracle problem, i.e. a row lock

RE: DB on NT

ALso, what does "1GB" actually mean? That much data, if you dumped it all out into a CSV file? A 1GB tablespace to hold all the data (and how is that tablespace organized)? 1GB being the sum of the sizes of all the datafiles? So, even if there were such a saying, it would be meaningless. What I l

RE: Wildly OT. Made me laugh.

*excellent*   !!!   thanks! -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 04, 2001 7:31 AMTo: Multiple recipients of list ORACLE-LSubject: Wildly OT. Made me laugh. For the UNIX people out there Unix csh/sh commands:

RE: Which RBS have active transactions?

Thanks, I was able to write a script that gets me most of what I want: select a.segment_name, b.start_uext "ACTIVE EXENT NUMBER", b.used_ublk "USED RBS BLOCKS" from dba_rollback_segs a, v$transaction b where a.segment_id = b.xidusn order by a.s

RE: how to browsed thru archives of this list

Nope, under no such disillusions :) It's just that I have been on the list since way back when, and have always called it the "Lyris List". I suppose I could call it ORACLE-L, but why change what I already have set up? :) I was just describing *my* set-up. I suppose you could call the folders "Ge

Re: RUPD$_ (long)

April, How's Amarillo lately? ;-) The only useful thing I found was on metalink forum (I'm sure you've seen it) pasted below. Looks like a special log for UPDATABLE SNAPSHOTS, which would make sense in the context of 2 way replication. Scott Shafer San Antonio, TX --begin-

Re: how to browsed thru archives of this list

On Thursday 05 July 2001 07:41, Mark Leith wrote: > folder called "Lyris" automatically when any > mail comes in. (This keeps the lyris mailseparate from any other > "business" mail, for ease of reading) Mark, You seem to be under the impression that we are still using Lyris mail softwa

Re: Schema organization

paquette stephane wrote: > > Hi all, > > I'm a fan of having the processing done by a user > different than the owner of the data. > Am I alone ? > > For example, we're on a datawarehouse system where the > data owner is DWH. The etl tool repository owner is > TOOL_POWERMART and the reporting t

Re: Which RBS have active transactions?

Terrian, Tom wrote: > > Does anyone know of a way to determine which RBS extents have active > transactions? > > Specifically: > select a.segment_name, a.bytes, a.extents, c.xacts > from dba_segments a, dba_rollback_segs b, v$rollstat c > where a.segment_type = 'ROLLBACK'

UNIX vs. 2000... check out what the Gartner Group thinks about M$ latest offering and how they compare

I don't want to start another "discussion" on this topic, I just thought that this was a good article. It appears that Unix is still king for VLDB or mission critical apps... Frank - DPRO-89898 Mary Hubley, Mary Ann

RE: Schema organization

A couple of other reasons for this approach: When you create a DAD in Oracle Application Server, you can choose to store the password in the config file. On version 3.02 it is in unencrypted form and is optional. On 4.x it's encrypted and mandatory (unless you cheat and remove the password entr

816/817 and JDBC Driver

Hi, following question on NT. I need to install 817 JDBC-Driver as I neet JDBC2 compliance. I just have a Oracle 8.1.6 database and installed SybaseToOracleWorkbench817. I copied JDBC-Driver in 8.1.7 home and was wondering if it is sufficient to have the 8.1.7 Home and OCI of 816 is used or do I

RE: how to browsed thru archives of this list

1) Sorry about that - I was using a funny name for MS Outlook. Within Outlook, you have an option called archiving, which I have set up as follows: 1) Create a rule that moves all mail received in my Inbox from "[EMAIL PROTECTED]" to afolder called "Lyris" automaticall

RE: Online backup script..........

Title: RE: Online backup script.. Woo Hoo!  Jared opened up a can on you Robert!   c'ya! --Chris [EMAIL PROTECTED] -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 04, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Subject: Re: O

FYI - Oracle 8i contains buffer overflow in TNS listener

Hi, Please check this Thanks Muthu --- CERT Advisory CA-2001-16 Oracle 8i contains buffer overflow in TNS listener Original release date: July 03, 2001 Last revised: -- Source: CERT/CC A complete revision history is at

RUPD$_

Good Thursday morning! I have a nagging question that I can find only sketchy documentation on. I have been working with Materialized Views and their associated logs and have been trying to figure out what the RUPD$_ structures are for. I have watched those tables during incremental processing

Re:can i place online redologs with oracle engine ?

Rahul, You can put them just about anywhere you want, but since they tend to be a high IO item you may end up paying a price. Dick Goulet Reply Separator Author: Rahul <[EMAIL PROTECTED]> Date: 7/5/2001 1:16 AM > list, > i cannot spare a separ

RE: Online backup script..........

hahahah, roflmao, thats hilarious, my co-workers are wondering whats so funny.   joe   >>> [EMAIL PROTECTED] 07/05/01 08:51AM >>>(robert) - you ARE the weakest link! goodbye!  :)that's what I call immediate justice.-Original Message-Sent: Wednesday, July 04, 2001 7:36 PMTo: Multiple

Re:Schema organization

Stéphane, Your not alone. I like having one schema that owns all of the objects and a second or more that manipulate the data therein. The reason is that many times the passwords for the other user accounts get hard coded into software making them almost impossible to change. This way if t

Re:DBMS_ALERT

I believe you'll need to be more specific. Using an alert is fairly simple, but sometimes does not get the desired results. Dick Goulet Reply Separator Author: "Pulikkol Kumar" <[EMAIL PROTECTED]> Date: 7/4/2001 12:35 AM Hi lists Any one can help

  1   2   >