RE: Hot Backup

to be written to the redo log. If all of your tablespaces are in backup mode at the same time, redo writes for the tablespaces whose files are not currently being copied will be unnecessarily large. Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -Original Message- Sent

computer history stories

works when you've learned about asserting ALE (address latch enable) and strobing the address bus! Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network

RE: grants to schema query

off @grantem Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 02, 2001 11:01 AM To: Multiple recipients of list ORACLE-L Hope there is not an obvious answer to this. I want to grant UPDATE priv to all objects in a schema to a user

9i RAC and Sun cluster?

We're considering using the above for a new system. Naturally there is a lot of skepticism about the reliability of such a new Oracle release. I'd be interested in hearing about anyone's experiences with 9i and Real Application Clusters. Thanks! Paul Baumgartel MortgageSight Holdings, LLC

RE: Another Braindead Friday...

Good idea, Tom, but you omitted the 'to ' clause in the grant statement; it should be select 'grant select on ' || table_name || ' to username with grant option;' from user_tables Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -Original Message- Sent: Friday, July 27

WebLogic and OPS transparent application failover

Anyone have experience with the above combination? Any pitfalls, caveats, gotchas, or roadblocks? Is the Oracle failover capability indeed transparent to WebLogic? TIA, Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http

RE: ADMIN: Please vote (was: RE: OT SPAM : Become an Oracle Certi

I'd prefer the list be kept closed. Paul Baumgartel InstiPro Group, Inc. [EMAIL PROTECTED] 212 813-0829 x103 -Original Message- Sent: Thursday, June 14, 2001 3:26 PM To: Multiple recipients of list ORACLE-L Certified DBA in 5 Weeks) I too got it, so I'm presuming they harvested

OID on 9i

anyone else tried this? Any ideas? This is 9.0.1 on Solaris 2.7 TIA Paul Baumgartel InstiPro Group, Inc. [EMAIL PROTECTED] 212 813-0829 x103 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services

RE: Re[2]: Serious Question (believe it or not)...

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Backup Control File Privilege

Since the syntax of the command to do this is alter database backup controlfile to trace; you must grant alter database privilege. Paul Baumgartel InstiPro Group, Inc. [EMAIL PROTECTED] 212 813-0829 x103 -Original Message- Sent: Tuesday, June 05, 2001 2:13 PM To: Multiple recipients

Cartesian

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Nothing to do with Oracle : But is is very important : Your r

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services

RE: job offer from SAUDI ARABIA

send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

FORALL / bulk bind insert

).message_content); which gives implementation restriction: cannot reference fields of BULK In-BIND table of records. So, how *is* it done? TIA, Paul Baumgartel InstiPro Group, Inc. [EMAIL PROTECTED] 212 813-0829 x103 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: FORALL / bulk bind insert

gives implementation restriction: cannot reference fields of BULK In-BIND table of records. So, how *is* it done? TIA, Paul Baumgartel InstiPro Group, Inc. [EMAIL PROTECTED] 212 813-0829 x103 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET

RE: PL/SQL Question

-- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

RE: What columns are in the Primary Key

). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Oracle DBA Needed in Fairfield County, CT...Major Company.

My resume is attached. Please contact me at your convenience. Thanks. Paul Baumgartel [EMAIL PROTECTED] 917 549-4717 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 11:26 AM Major state-of-the-art pharmaceutical company

RE: differences between physical datafile and v$datafile

ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

transaction recovery error

. Thanks! Paul Baumgartel InstiPro Group, Inc. [EMAIL PROTECTED] 212 813-0829 x103 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: imp - limitation on number of tables?

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

Re: Should each partition have it's own tablespace and datafile?

Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

OID installation

I'm looking for help installing Oracle Internet Directory (8.1.7, Sun Solaris 2.7). The software installation goes fine, but once the OID Configuration Assistant window comes up, everything stops. My database does use the UTF8 character set. Any ideas out there? Thanks. Paul Baumgartel

RE: OID installation

I found the problem. The OiD schema installation assumes that the password for "system" is "manager". If it isn't, the installation doesn't proceed. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Origin

RE: OID installation

You can, but the scripts are meant to be run via the GUI installer: I changed the system password to "manager" instead and all ran smoothly. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- [mai

RE: Oracle being scalable

his email formatting broke the line in two, just add the "tml" to the ".h" and you'll get there Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Thursday, April 05, 2001 12:31 PM To:

OID installation

does not currently have an Oracle8i database." Is the purpose of this recommendation to ensure best performance, or is there some other issue? Thanks. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- Please see the officia

RE: Set transaction does not work

d it, only to find that the relevant rollback info has been overwritten. You'd have to specify the BIG_ROLLBACK to be used by your other transactions *before* you issue the query. Setting an RBS has no effect on a query. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 91

RE: Execute priv to an isolated procedure inside a package

That is correct. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Tuesday, March 27, 2001 8:45 AM To: Multiple recipients of list ORACLE-L I have not tested this. I believe ,with about a 60% level

RE: Lemon Juice in Ants Pooh-Poohed

age header, at least, so it's possible to filter them out. And no, I am not a grouch, curmudgeon, in need of lightening up, etc. Sometimes enough is enough, already. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- Please see the official OR

RE: number of Mb to add?

It's Oracle blocks. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Monday, March 12, 2001 11:20 AM To: Multiple recipients of list ORACLE-L if I get this message, IMP-00058: ORACLE error 1654

RE: Weird - unable to extend error

In this case the "temporary segment" was not a sort segment, but the space allocated for an index while under construction. I'm surprised that no one here caught that! Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) ---

RE: Weird - unable to extend error

I'm not so sure. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Friday, March 09, 2001 9:55 AM To: Multiple recipients of list ORACLE-L Sorry Paul, Do not pass Go and do not collect 200 quid. One

RE: opinions on naming primary keys in new database (seriously)

r database objects. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Thursday, March 08, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Hugh, You are right that Richard Barker says not to use an e

RE: Oracle Upgrade DBA Wanted

Yeah, it was in my inbox as well...sounds like these people are mining this mailing list for addresses. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Friday, March 02, 2001 9:32 AM To: Multiple

RE: Restore Scenario

Speaking of dairy: Jared, your web site features an "Oracle Initialization Parms Comparison". When I see "parm", I think of Parmesan (or, more properly, Parmigiana) cheese. Shouldn't that be "params"? Or "settings"? Paul Baumgartel InstiPro, Inc. [EM

RE: RE: MetaSlop

And if you were running a comparable system, what would *you* say? Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Tuesday, February 27, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Man

Connection Manager

Can anyone explain to me the difference between Connection Manager's connection concentration and connection pooling capabilities, and the appropriate circumstances in which to use them? Thanks. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717

RE: Get Java from database?

What about a binary (i.e., class) file? Any way to extract it to an OS file? I'm asking because we have some Java stored procedures of uncertain origin and we're trying to locate the source. They're stored in the DB as classes. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829

RE: shutdown Abort...Open normal??

Instance recovery, not database recovery, occurs after a shutdown abort or other abnormal instance termination. No DBA intervention is required; Oracle takes care of it automatically. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile

Get Java from database?

I'm new to Java in the DB. Once a class or source has been loaded into Oracle, is there any way to get it back out? Thanks. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- Please see the official ORACLE-L FAQ: http

RE: Get Java from database?

No, I wasn't clear enough; I mean retrieve into a file. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message- Sent: Thursday, February 15, 2001 4:16 PM To: Multiple recipients of list ORACLE-L You mean, drop

RE: OFF TOPICRE: Get Java from database?

Title: OFF TOPICRE: Get Java from database? Someone has been drinking *too much* java, methinks. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Thursday

RE: Are snapshot logs purged?

to consider (in this order) dropping the snapshots, dropping the logs, re-creating the logs, and re-creating the snapshots. Perform some DML on the master tables, then do fast refreshes and ensure that the logs are empty. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549

RE: Extent allocation

Title: Extent allocation It is a big clue. Oracle rounds to multiples of 5 extents to prevent the existence of a free extent of fewer than 5 blocks, which is unlikely to be usable. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile

<    1   2   3