Title: Dynamic views
Sure, You can write
an INSTEAD OF trigger on the view that inserts into the right table.
Arup Nanda
www.proligence.com
- Original Message -
From:
david
hill
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, November 20, 2002 1:48
. Have you tried this:
select ... from ... where trunc(datefield1) =
'01.10.1950'
or
select .. from .. where datefield1 between
'01.10.1950' and '02.10.1950'
Hop this helps.
Arup Nanda
www.proligence.com
- Original Message -
From:
Daiminger, Helmut
To: Multiple recipients
anywhere; I found this by
accident.
Hope this helps.
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 21, 2002 9:18 AM
(Distributed transaction)
Gurus,
Desperately need some ideas to solve this one
Title: RE: export in full mode but exclude particular user?
It's the same - exu81obj and exu8usr.
HTH
Arup Nanda
www.proligence.com
- Original Message -
From:
Chris
Stephens
To: Multiple recipients of list ORACLE-L
Sent: Thursday, November 21, 2002 9:18
AM
The number is more than the numwidth specified. Try this
SQL set numwidth 13
SQL select trn_id from trnid;
Your numwidth is perhpas defined as 9; so anything of more precision is
displayed as exponetial notation; internally all numbers are stored the
same.
HTH
Arup Nanda
www.proligence.com
Ruth,
If you mean the operating system process id, it's in v$session field
PROCESS.
the following will tel you the oracle server process
select spid
from v$process p, v$session s
where s.sid = your sid from v$session
and p.addr = s.paddr
HTH
Arup Nanda
- Original Message
the constraint but rather to
design a better index.
HTH
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 22, 2002 1:39 PM
I am trying to find out what indexes are in the database only for
performance
FAQ: http://www.orafaq.com
--
Author: Arup Nanda
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
this, not from
other cleint machines.
HTH
Arup Nanda
www.proligence.com
From: Stephane Faroult [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Storing of number datatype in table
Date: Fri, 22 Nov 2002 23:43:43 -0800
MIME
and service in a command prompt window using oradim
comamnd. I am not sure of the options; but the oradim command gives a help.
At some point you would hit a problem that is decipherable. Please let us
know what came out of it.
HTH
Arup Nanda
www.proligence.com
From: john [EMAIL PROTECTED
?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Sat, 23 Nov 2002, Arup Nanda wrote:
Well, system does not do a shutdown abort. Oracle finds a problem and
then
instance aborts.
A few things you can do here.
(1) See if a trace file is generated around that time in user_dump_dest
, tables, populate control tables, etc and then refresh it
from the regular sources. This works out to be longer but less expensive.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, November 24, 2002 12:23 PM
ut i need to know the complete procedure. would you know the
complete statement and procedure to generate control files. do we have
to change the db/sid name ?
--- Arup Nanda [EMAIL PROTECTED]
wrote: Yes, the poster clarified that it was a missing controlfile.
I have a reply that catered to
: 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: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services
: Arup Nanda
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 mailing list, send an E
in that field can progress to the next logical
career move. Guess which profession's logical career move is database
administrator? See the excerpt from the webpage here in the attachment as a
picture.
I just couldn't resist posting it here. May be they are referring to SQL
Server DBAs?
Arup Nanda
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
analyzed any of the tables, including SYS owner
tables?
HTH
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 26, 2002 1:54 PM
Hello everybody,
I have the following query that runs every week
it's sure easy enough
SELECT (OWNER, TABLE_NAME)
FROM DBA_TABLES
WHERE (OWNER, TABLE_NAME) NOT IN
(SELECT OWNER, TABLE_NAME
FROM DBA_CONSTRAINTS
WHERE CONSTRAINT_TYPE = 'P')
HTH
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday
information (like subscribing).
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
INET: [EMAIL
BFILE, where the actual file is stored on the file system and
pointer to it is stored in the database. However security is definitely an
issue. And how do you plan to back it up?
There are other ways like using WebDAV and iFS, but I have no experience in
using them.
HTH
Arup Nanda
special about replication between 8ik and
9i, it's pretty much the same as in case of 8i-8i.
HTH
Arup Nanda
www.proligence.com
From: mantfield [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Advanced Rep between 9.2.0
).
_
The new MSN 8: smart spam protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network
_
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
John,
You are welcome. I am glad Icould be of help.
Arup Nanda
www.proligence.com
From: john [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: instance and database
Date: Sat, 30 Nov 2002 13:58:43 -0800
MIME-Version: 1.0
on timestamp.
Just my two cents.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 03, 2002 7:39 AM
Managing 20mil of anything (images/text/etc) in a file
system isn't a nice proposition. Go with the database
hth
the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
') 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
INET: [EMAIL
Title: Message
Rich,
You just gave the answer yourself, allocation_type
in dba_tablespaces should show UNIFORM for uniform extent allocation. For
non-uniform allocation, it will show SYSTEM in that field. If you want to know
what is the size of the uniform extent, look for INITIAL_EXTENT
sessions are trying to get the
same buffer low.
Caveat - if your database has a large percentage of DSS type quries (you
mentioned hybrid), then they will suffer slightly as the block gets will
increase.
HTH
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
is the same (16K) for indexes and tables. For other two OLTP
based apps, I have defined 8K tables and 4K indexes for a third party app. I did
a benchmark to see the effects and that was the conclusion. Unfortunately I
didn't save it.
HTH.
Arup Nanda
- Original Message -
From: "Jo
: 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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services
DEADLOCK DETECTED in alert log. Therefore setting
INITRANS higher is not going to help at all. Rather the application logic
should be checked to remove a real locking conflict.
Am I correct, or am I missing something here?
Arup Nanda
Original Post
Hi
I have been noticing some times following
and that will give you some indication how fast the
roll back is taking place.
HTH
Arup Nanda
www.proligence.com
- Original Message -
From:
shuan.tay(PCI¾G¸R³Ô)
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 25, 2002 10:48
PM
Subject: Killed status
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Yes, I know this will probably spark all sorts of
reaction; but I would appreciate any feedback on the process.
Arup Nanda
col name format a30 head "Index Name"col
comp_factor head "Compactness"col hole_factor format head "Hole"col
del_pct format head &qu
] wrote:
sigh. I need to find time to read ALL the docs.
Yeah, that'll happen.
If I can find a parallel universe where time runs at
a different rate.
Thanks, I'll test this out as well.
--- Arup Nanda [EMAIL PROTECTED] wrote:
In 9.2, you can keep the index by using the KEEP
researched and considered for the old "drop kick"
nonetheless.
Thanks again!
-Tim
- Original Message -----
From:
Arup
Nanda
To: Multiple recipients of list ORACLE-L
Sent: Saturday, December 28, 2002 9:08
PM
Subject: Re:
universe where time
runs at
a different rate.
Thanks, I'll test this out as well.
--- Arup Nanda [EMAIL PROTECTED] wrote:
In 9.2, you can keep the index by using the
KEEP
INDEX key words.
ALTER TABLE XXX DROP CONSTRAINT PK_XXX KEEP
INDEX
/cgi-bin/getmsgHL=1216hotmailtaglines_advancedjmf_3mf
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Title: Tales Of Big Hammer #10046 (AKA event 10046)
Raj,
Thanks for sharing this with us. In your original
post you mentioned that you saw a "rollback" right after the "SQL*Net
break/reset to client" and that was how you figured out the 1403 error. I don't
see that in this excerpt from the
Of course, the savepoint can be any name you
choose; it does not matter if they are the same in different
sessions.
- Original Message -
From:
Shishir Kumar
Mishra
To: Multiple recipients of list ORACLE-L
Sent: Friday, January 03, 2003 2:14
PM
Subject:
view possible.
HTH
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 2:49 PM
I am running 8.1.6 on solaris 2.8.
Before running a large update, I tried to set a specific rollback
segment by:
Set transaction use
for other information (like subscribing).
_
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
1024
1 row selected.
SQL select value from v$system_parameter where
name = 'sort_area_size';
VALUE1024000
1 row selected.
HTH
Arup Nanda
- Original Message -
From:
Nirmal Kumar
Muthu Kumaran
do the
follwoing query:
SQL l
1 select * from seg$
2 where (file#, block#, ts#)
3 in
4 (select file#, block#, ts#
5* from undo$)
SQL
Look at the blocks column which will tell you the size as of now.
HTH
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE
John,
This is set to take advantage of the file system access mechanism. For
Solaris9, this is recommended to be SETALL, not NONE. This is nothing to do with
using a SAN, We use Hitachi 9800 with SunFire 15 Solaris 9 and we have set
it to SETALL.
Hope this helps.
Arup Nanda
the contention in extent
growth.
HTH
Arup Nanda
www.proligence.com
- Original Message -
From: Guang Mei [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 08, 2003 3:12 PM
Subject: Re: rbs' maxextents in LMT
Hi,Arup:
From your message,it seems that you don't
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
, but could be less.
HTH
Arup Nanda
www.proligence.com
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 08, 2003 4:00 PM
Hi:
I am trying to learn how to make use v$sgastat info in our oracle 8173 db.
Here is what I set
of the
repository is as simple as opening up in vi and typing the lines. Guess
which one is simpler?
Just a thought.
Arup Nanda
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date: Wed, 08 Jan
Rick,
There is no such view, but can be very simply obtained by turning on
auditing and placing auditing for connects for user. Later you can aanalyze
the connects and disconnects in a given time period to get max concurrent
access.
HTH.
Arup Nanda
- Original Message -
To: Multiple
a
cronjob that creates the trace file in the user_dump_dest directory. In case
of a disater like this you have at least that file to go back to and save
yourself from writing the commands.
HTH.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
') 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET
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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
.
If the backup was made while the repository was in use for
other backups, it may be in a logically inconsistent state from
the RMAN perspective.
Kind of like backing up OID.
Could be that I'm wrong on this, but I don't have time to test
it and come up with a definitive answer.
Jared
Arup Nanda
AX
NUMBER
"Arup
Nanda"
arupnanda@hotmai
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
l.com
cc:
Sent
by:
Subject: Re: Determine max # of concurrent users at schema
level
[EMAIL PROTECTED]
01/09/2003
02:44
PM
Please respo
.
Admittedly, this was for cold backups of the Oracle database, but I
can't see why RMAN couldn't have as easily done the same thing for hot
backups.
--- Arup Nanda [EMAIL PROTECTED] wrote:
Huh!!!
Quote
If the backup was made while the repository was in use for
other backups, it may
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
? If
you archive off every quarter, then the date should be part of the key.
Similarly in the previous point I mentioned the arrival of data in different
intervals from different sources. So, in order to minimize the downtime you
will need to partition based on source.
HTH.
Arup Nanda
.
Admittedly, this was for cold backups of the Oracle database, but I
can't see why RMAN couldn't have as easily done the same thing for hot
backups.
--- Arup Nanda [EMAIL PROTECTED] wrote:
Huh!!!
Quote
If the backup was made while the repository was in use for
other backups
for hot
backups.
--- Arup Nanda [EMAIL PROTECTED] wrote:
Huh!!!
Quote
If the backup was made while the repository was in use for
other backups, it may be in a logically inconsistent state from
the RMAN perspective.
/Quote
That sent a shiver through
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
for the RMAN repository.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 5:00 PM
Not having used RMAN since it's inception, I'm a little confused. Why
couldn't you backup the DB hot, provided it wasn't using
, 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat
the procedure completely in http://www.dbazine.com/nanda2.html .
Hope this helps.
Arup Nanda
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 14, 2003 3:53 AM
replication environment
Hello
How can i replicate DDL on table (modify
Title: RE: Database tracking
Wow!
Thatdefinitely is one simple and elegant
solution, Raj.
I wonder what you call when the alarm goes off,
"heart-broken"?:)
Arup
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent:
the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
://www.orafaq.net
--
Author: Arup Nanda
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
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
://www.orafaq.net
--
Author: Arup Nanda
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
Thanks, Kirti.
Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, January 17, 2003 1:08 PM
And also an article about Summary Table Mgmt from Arup Nanda :)
Kudos to all !!
- Kirti
-Original Message-
Sent: Friday, January 17
') 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL
://www.orafaq.net
--
Author: Arup Nanda
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
ts_to_alert set to TRUE, then your alert log file
will have lines when the redo log group switch fom one to the
other." Regards Raj
"Arup
Nanda"
arupnanda@ho To:
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
tmail.com
cc:
Sent by:
Subj
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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
).
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City
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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup
the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
the same name and structure
in
one tablespace ? I think you should check your data dictionary or your
program documentation.
Hope this helps.
Rgrds,
Sony
-Original Message-
From: Arup Nanda [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 12:19 AM
To: Multiple
for the
onedefined in listener.ora file (under SID_LIST parameter) an
anotherfor the onethat hasbeen registered
automatically.
HTH.
Arup Nanda
- Original Message -
From:
Joshua
Becker
To: Multiple recipients of list ORACLE-L
Sent: Monday, January 20, 2003 11:59
PM
switches. But now to clearly understand
your
point of view, and for my curiousity, how does one derive the amount of
redo log generated in bytes using the SCN Numbers?
Thanks
Raj
Arup Nanda
arupnanda@hoTo: Multiple recipients of
list
Title: Message
Ethan,
Cool utility! Wow, thanks for sharing this with us.
The timing couldn't have been more perfect. I used it immediately for a problem
I was working on. I thought I would share it with everyone.
We have a little situation here,management
wants a certain tuning excercise
the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
(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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
: http://www.orafaq.net
--
Author: Arup Nanda
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
. For an simple insert statement, could also
update the UET$ or FET$ tables? So, if the purpose was to preserve all
changes to the data dictionary, What's different between OBJ$, COL$ and
these space management tables?
Thanks
Raj
Arup Nanda
months FREE*.
http://join.msn.com/?page=features/virus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
1 - 100 of 316 matches
Mail list logo
