t; To: Multiple recipients of list ORACLE-L
> >
> >
> > We are an Application Service Provider--we maintain a set of
> servers in
> > a colocation facility and our customers use our application via the
> > Web. Security is a paramount concern, of course, and only our W
Never mind, I see that it is. Thanks.
--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> Jared,
>
> Is that the book from sans.org?
>
> Thanks,
>
> Paul
>
>
> --- Jared Still <[EMAIL PROTECTED]> wrote:
> > Yes, I will ditto the recomme
is output makes a couple of
function calls...does the elapsed time here include the waits that the
function calls might cause? I have 24 seconds of elapsed that aren't
accounted for.
TIA,
=
Paul Baumgartel
Transcentive, Inc.
www.transcentive.com
___
t; >>> Dear List, Can anyone send me a list of dba interview questions?
> >>>
> >>> Thanks,
> >>>
> >>>
>
> ___
> Get Your 10MB account for FREE at http://mail.arab
d in
> the message BODY, include a line 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).
=
Paul Baumgartel
Transcentive, Inc.
www.transcentive.com
_
product or exempt from disclosure under applicable law.
> If you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860)
> 766-2000 and delete this e-mail message from your computer, Thank
> you.
>
*********
****5
>
__
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgart
et
> --
> Author: Tim Onions
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -----
> To
an the microsecond resolution values on Linux, so that
would be, what, tenths of nanoseconds???). And I guess the Windows
epoch is not the same as the Unix epoch (perish the thought). Has
anyone figured out how to convert these to wall clock time values?
TIA
=====
Paul Baumgartel
Transcentive, Inc.
ww
reasing "dep" values (with detours for
"true" recursive SQL, such as data dictionary access, that follows
Cary's rule)?
TIA
=
Paul Baumgartel
Transcentive, Inc.
www.transcentive.com
__
Do you Yahoo!?
Protect your identity with Yahoo! M
ntaining: 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).
=
Paul Baumgartel
Transcentive, Inc.
www.transcentive.com
__
Do you Yahoo!?
Protect your identit
rcentage of used space falls below PCTUSED", didn't
you?
=
Paul Baumgartel
Transcentive, Inc.
www.transcentive.com
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the offici
---
> 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 want to be removed from). You may
> --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Yong Huang
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing li
t; --
> Author: Jose Luis Delgado
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> ---------
___
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 htt
Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fa
onfigured on the
> SAN for the B80 and 6C4 computers. Sam has told me that, in the
> Oracle
> community, mirroring (RAID1) is preferred over RAID 5 for various
> reasons (RAID5 is: more costly for write-intensive applications, 3
> times
> more likely to incur data loss, suffers from massi
and web hosting services
> -
> 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 contain
x27;) and in
> the message BODY, include a line 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).
__
Do you Yahoo!?
SBC Yahoo! DSL - Now on
tp://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and we
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 want to be removed from). You may
> also send the
mpathy are welcome.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
sense here? ;-)
--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> I have successfully (on the third attempt) gotten a logical standby
> database up, running, and applying changes from the primary.
> However,
> I quickly ran into a problem, and I'm wondering if anyone else ha
OK, I'm going to aim a little lower: is _anyone_ using Logical
Standby? Any tips, gotchas, implementation accounts to share?
TIA
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $
Even some of the MetaLink papers are buggy--I was advised to rely on
the 9.2.0.2.0 docs.
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Paul Baumgartel wrote:
> >
> > OK, I'm going to aim a little lower: is _anyone_ using Logical
> > Standby? Any tips, got
ven't tested Streams yet.
I'd be interested in hearing of any experiences from those who have the
same or similar requirements.
Paul Baumgartel
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official O
. We'd like to use the secondary database for
> > reporting as well, so a physical standby isn't practical.
> >
> > RAC doesn't give us a second database copy.
> >
> > Multimaster replication requires that changes to replicated objects
> be
> &g
mirror
is split off, the two nodes continue to run against two mirrored
copies, correct?
Thanks!
Paul Baumgartel
--- Matthew Zito <[EMAIL PROTECTED]> wrote:
[snip]
> What about a storage-level solution? Either at the software (i.e.
> Veritas) or hardware (i.e. your big honkin' st
> the message BODY, include a line 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).
__
Do you Yahoo!?
SBC Yahoo! DSL - Now o
you tell
> the
> install where "some" is?
>
>
>
>
>
>
> Paul Baumgartel
>
>recipients of list ORACLE-L <[EMAIL
quot;About"; version showed as 2.2.0.18.0.
=
Paul Baumgartel
Transcentive, Inc.
www.transcentive.com
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Aut
cient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 126
ORA-06512: at line 2
When SQL statements are executed in the session, no further trace
information is added to the file.
Anyone know what's going on here?
TIA
=
Paul Baumgartel
Transcentive, Inc.
port.start_trace (waits => false, binds => false) ;
> end ;
> /
> DISCONNECT
>
> logon as user X:
> trace file created
>
> logon as user Y:
> no trace file created
>
> logon as user Y, say "alter sesssion set current_schema = X ;"
> no trace file cr
That's it! Thanks...sometimes I forget that a trigger is a stored
object, too.
Regards,
--- Wolfgang Breitling <[EMAIL PROTECTED]> wrote:
> The logon user needs to have granted "alter session" privileges
> directly to
> her, not just through a role.
=
Pau
//sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---
isk failure?
>
> Cheers,
>
> -Roy
>
> Roy Pardee
> Programmer/Analyst/DBA
> SWFPAC Lockheed Martin IT
> Extension 8487
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
b hosting
> services
> >
> -
> > 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, inc
> > > San Diego, California-- Mailing list and web
> > > hosting services
> > > >
> > >
> >
> ---------
> > > > To REMOVE yourself from this mailing list, send an E-Mail
&
nd web hosting services
> -
> 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 cont
. Then on the other hand-what things
> should
> someone try to leverage?
>
> thanks in advance!
>
>
> Greg Loughmiller
>
>
>
=
Paul Baumgartel
Transcentive, Inc.
www.transcentive.com
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, eas
abase? I had trouble to find the 9.2.3 doc. I really appreciate
> for
> your help.
>
> Joan
>
> Paul Baumgartel wrote:
> >
> > We were going to use logical standby but quickly abandoned the idea
> > after testing.
> >
> > 1. The APPLY process
t to be removed from). You may
> also send the HELP command for other information (like subscribing).
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ:
1890 0.21 0.17 0 0 0
Execute945 0.04 0.08 0 0 0
Fetch 945 38.48 43.24 0 620428 0
=
Paul Baumgartel
Transcentive, Inc.
www.transcentiv
.21 0.17 0 0 0
>
>
> Execute945 0.04 0.08 0 0 0
>
>
> Fetch 945 38.48 43.24 0 620428 0
>
>
>
> =
> Paul Baumgartel
> Tr
r than the intended recipient is strictly prohibited and may be
> illegal.
> If you have
> received this communication in error, please notify the sender
> immediately
> by reply e-mail,
> delete this communication, and destroy all copies.
>
>
> Corporate Systems,
Wow--that one sent me scrambling to Google. Nice riposte!
--- Stephane Faroult <[EMAIL PROTECTED]> wrote:
> Paul Baumgartel wrote:
> >
> > A couple of corrections are in order here. First, some Christians
> > might object to your characterizing the Holy Trinity
he name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribin
I don't respond to any messages that use "u" for the word "you".
__
Do you Yahoo!?
Yahoo! SiteBuilder -
I've created a physical standby database that seems to be performing
properly, but there's no alert log in user_dump_dest, nor anywhere else
on the machine. Is there no alert log until/unless the standby
undergoes a role transition?
TIA
=
Paul Baumgartel
Transce
$ORACLE_HOME/rdbms/log.
> If you have looked for the file with find (don't tell you are on
> Windoze), have you used -follow ?
>
> HTH
>
> SF
>
> >----- --- Original Message --- -
> >From: Paul Baumgartel <[EMAIL PROTECTED]>
> >To: Mul
rnia-- Mailing list and web hosting
> services
> >
> -
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
>
HELP command for other information (like subscribing).
______
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
--
Please see the official ORACLE-L FAQ: htt
redo logs like fine
> grained
> stripe sizes) but given the mix of uses for each that doesn't seem
> viable.
>
>
> Comments, suggestions or even productive questioning of my sanity
> would be
> appreciated.
>
>
> Thanks,
> Jay Miller
>
>
ing).
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tanel Poder
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California--
o.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
gt;
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to
n
> the message BODY, include a line 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).
__
Do you Yahoo!?
The New Yahoo! Shopping - with
t; die,
> probably me. *-)
>
> Dick Goulet
__
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Ser
ations does not represent that this transmission is free of
> errors,
> viruses or interference.
>
>
>
__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.
ify environment variables such as ORACLE_HOME. But
nowhere do I see how to use a SQL*Net connect string: I have PDBA
installed on my PC, and I want to connect to databases on Unix servers;
the service name resolution is provided by Oracle Names. What am I
missing?
Thanks,
osed to.
TIA!
__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://ww
This COPY script failure occurred when running in SQL*Plus on Windows
NT. In SQL*Plus on (Unix) database server, runs just fine, so
immediate problem solved.
Shouldn't it work from PC, though?
--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> I'm trying to use (for the fir
ee the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---
u want to be removed from). You may
> also send the HELP command for other information (like subscribing).
__
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.co
rch new jobs daily now
http://hotjobs.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting servic
the large
reel-to-reel tapes in my hand. As I recall, the project never got off
the ground, to my chagrin. Imagine allowing a single developer to
choose a language that way now!
Paul Baumgartel
--- [EMAIL PROTECTED] wrote:
> Things seem a little slow on the list ( like I need more em
l
and s.sid = &sid
order by se.time_waited
/
Run this before and after executing the insert statement, and compute
the delta for each wait event seen.
HTH
Paul Baumgartel
--- [EMAIL PROTECTED] wrote:
>
> Oracle 8.1.7.0.0 on Win2k (4 CPU, 4GB RAM)
>
> A 3rd Party app. is e
ormation (like subscribing).
__
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
ces
> Thomson, Inc.
>
> Email: [EMAIL PROTECTED]
>
> Indy DBA Master Documentation available at:
> http://gkmqp.tce.com/tis_dba
> Select 'Indy DBA' then 'DBA Web Pages'
>
>
>
>
___
o be removed from). You may
> also send the HELP command for other information (like subscribing).
>
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the of
ficial ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing li
When one executes a query, the result set is identified. Fetching the
rows in the result set can be done over a period of time. In what form
does Oracle maintain the result set, and where?
TIA
Paul Baumgartel
__
Do you Yahoo!?
Yahoo! Mail Plus
> When one executes a query, the result set is identified. Fetching
> the
> rows in the result set can be done over a period of time. In what
> form
> does Oracle maintain the result set, and where?
>
> TIA
>
> Paul Baumgartel
>
>
> ___
rom anyone who's
worked with FalconStor or similar products and can suggest other things
to investigate.
TIA,
Paul Baumgartel
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
--
Please see the offici
name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
--
Please see the official ORACLE-L FAQ: http://www.o
24 rows. If we add WHERE ROWNUM < 1000, the query returns 336
rows!
I don't know the size of the entire result set (I'm running a count
right now), but if the result set consists of at least 336 rows,
shouldn't WHERE ROWNUM < 50 return 49 rows?
TIA!
=
Paul Baumgartel, A
s not sequential, and ROWNUM 999 could be the 336th row in
sorted order.
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
I believe you have ROWNUM confused with ROWID.
--- ltiu <[EMAIL PROTECTED]> wrote:
> Holes in your extents/segments. Normal. You get this after repeated
> updates/deletes/inserts.
>
> ltiu
>
> Paul Baumgartel wrote:
>
> >I've been given a query t
Can we do anything in the program itself, such as closing
cursors more frequently, that will help?
TIA!
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock q
nning session
calls it constantly; the wait event references the library cache lock.
I've seen waits on the library cache latch in similar situations (at
least I think I have; my memory may be failing me!).
TIA!
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL
add up to equal time logged on.
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network
owning schema, nor in that of the
replication administrator. What, then, is the mechanism by which the
procedures in this package are called?
TIA!
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo
eplication of an object, it
> creates a package called $RP. This package contains
> code
> to be run when rows are inserted, updated, or deleted. There are,
> however, no trigges in the owning schema, nor in that of the
> replication administrator. What, then, is the mechanism by which
trick in the TNSNAMES.ORA and LISTENER.ORA files.
>
> Please can anyone give some light in that, I am totally confused !!!
>
>
> Ramon E. Estevez
> [EMAIL PROTECTED]
> 809-565-3121
>
>
__
Do You Yahoo!?
Yahoo! Fina
ad
hoped to put a face to the name!
Paul Baumgartel
__
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
http://dir.remember.yahoo.com/tribute
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul
_
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-50
g the load. Am I correct in concluding that the high CPU, and
especially the current mode block gets numbering over 6 times the
number of rows inserted, are due to index updates?
Thanks!
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL
I thought I'd repost to see if I could get a response. Anyone?
--- Paul Baumgartel <[EMAIL PROTECTED]> wrote:
> I'm looking at a client's tkprof output, showing among other things
> that the insertion of about 135,000 rows taking 450 seconds of CPU,
> and
&
Hi all. I've just entered the world of Oracle on Windows. My first
question regards the mechanism used to run jobs that are created using
OEM.How does OEM execute RMAN, or export, for example?
Thanks
Paul Baumgartel
__
Do you
g the instance, but any
other ideas would be appreciated.
I really prefer running Oracle on Unix.
TIA,
Paul Baumgartel
__
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
--
Please see the official ORA
://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this
sage BODY, include a line 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).
__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Ou
BODY, include a line 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).
__
Do you Yahoo!?
Yahoo! Cal
> also send the HELP command for other information (like subscribing).
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
John, yes, you must use a trigger, with some variation of
select .nextval into :new. from dual;
Paul Baumgartel
--- John Weatherman <[EMAIL PROTECTED]> wrote:
> OK, I RTFM and am probably just missing it. Is there an easy may to
> define
> a default as a NextVal? When I try,
hange directly to the spfile.
HTH,
Paul Baumgartel
--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
> expecting the
> init.ora file?
>
> I created the database using dbca. It created an init.ora in
> admin/{db
or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the offici
Yes, setting GLOBAL_NAMES = FALSE will allow the DB link to work, but
if you are using Advanced Replication, GLOBAL_NAMES must be set to TRUE
and your DB links must conform to the requirement that it imposes.
Paul Baumgartel
--- [EMAIL PROTECTED] wrote:
> set GLOBAL_NAMES to false from
; 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 want to be removed from). You may
> also send the HELP command for other information (like subscribing).
_
table, with the
additional columns populated appropriately.
Paul Baumgartel
-- "Browett, Darren" <[EMAIL PROTECTED]> wrote:
> We need to be able to track what records have been deleted from a
> table.
>
> Our current thinking is
> 1. A "before delete" t
101 - 200 of 272 matches
Mail list logo