chance that two 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 recipie
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-- 858-538-5051 http://www.fatcity.com
San Diego, California
block size 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 --
an Diego, California-- 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
ssage 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
Hi
I have been noticing some times following error wit
g 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 s
; also send the HELP command for other information (like
> > > > subscribing).
> > > > >
> > > > >
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.ora
database is 8.1.7.4.
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_p
e primary kept, kept the index and then
> added a unique constraint...
>
> I would contend that this is a rare occurrence ?
>
> Cheers
> Connor
>
>
> --- Rachel Carmichael <[EMAIL PROTECTED]> wrote:
> > sigh. I need to find time to read ALL the docs.
> > Y
vantage of skewed data distribution
-- but it should be 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, D
raint on it
> > > - loaded the data
> > > - decided actually X was NOT the primary key, just
> > a
> > > unique value
> > > - decided that X could allow nulls as well
> > > - dropped the primary kept, kept the index and
> > then
> > > added
ling 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 HELP command for other information (like s
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: SavePoi
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
>
s/featuredemail
--
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
--
an Diego, California-- 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') and in
>
7;) 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
--
Autho
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.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Cali
---1024
1 row selected.
SQL> select value from v$system_parameter where
name = 'sort_area_size';
VALUE----1024000
1 row selected.
HTH
Arup Nanda
- Orig
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 recipie
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
ied the version. If it's 9i, you could use the
Automated
> Segment Space Management to further reduce the contention in extent
growth.
>
> HTH
>
> Arup Nanda
> www.proligence.com
>
> - Original Message -
> From: "Guang Mei" <[EMAIL PROTECTED]>
>
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:
, 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
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,
end 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 HELP command for other information (like subs
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: "Mul
; into your regular hot backup script or just 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: "
st, 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 s
> > --
> > Author: Richard Ji
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> >
pository.
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 answ
NUMBER>
USERS_MAX
NUMBER> > > > >
>
"Arup
Nanda"
>
start the
> restore from where I had stopped, instead of from the beginning again.
>
> 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
--
> 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 mai
ds to store and archive. What is your archival strategy? 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
wi
tten to tape as well.
> >
> > As I did restores, I read the text file. then I used that file to let
> > me know which file I was reading from the tape and where to put it. I
> > wrote another text file while I was doing the restore, as each file was
> > successfully
6:04 AM
> >
> >
> > > way back when, I wrote my own set of scripts to handle backups. As
each
> > > datafile was backed up, I wrote the full path name to a text file. At
> > > the end of the backup the text file was written to tape as well.
> > >
> > &
ining: 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
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
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
cribed 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
>
&g
Title: RE: Database tracking
Wow!
That definitely 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: Wedn
DY, 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
ECTED] (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).
>
--
Please see the official O
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 HELP command for other information (l
ACLE-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 Service
ant 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 N
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
>
>
e 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
(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).
>
--
Please see
http://www.orafaq.net> >
--> > Author: MURAT BALKAS> > 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-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 mai
; Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://
CTED] (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).
__
> 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
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 Network Services-- 858-538-5051
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: [E
L> select count(*) from facility;
>
> COUNT(*)
>--
>
>
>SQL> commit;
>
>Commit complete.
>
>SQL> select count(*) from facility;
>
> COUNT(*)
>--
>
_
STOP
ossible, how could two tables have 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 [SMT
for the
one defined in listener.ora file (under SID_LIST parameter) an
another for the one that has been registered
automatically.
HTH.
Arup Nanda
- Original Message -
From:
Joshua
Becker
To: Multiple recipients of list ORACLE-L
Sent: Monday, January 20, 2003 11
r to
> know the frequency of your log 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
>
>
>
>
>
>
>
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 excerci
pelling 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: ht
;) 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
ing 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 containing: UNSUB ORACL
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).
>
--
Please see the official ORACLE-
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 PROTE
> 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
t;
> That raises another doubt. 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
&g
_
MSN 8 helps eliminate e-mail viruses. Get 2 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
Joshua,
You can have two users named "oracle" (the oracle
64-bit software owner) and "app1" (the app owner).
You will create 2 ORACLE_HOMEs, say
/u01/oracle/product/9.2/64bit and /u01/oracle/product/9.2/32bit. In the .profile
of the app1 owner, the ORACLE_HOME=/u01/oracle/product/9.2/32bi
or pointers will be
highly appreciated.
Thanks.
Arup Nanda
Use
pl/sql block with execute immediate 'create table < > as
...'
Number of rows should be in sql%rowcount (immediately after execute
immediate).
Waleed
-Original Message-From: Arup Nanda
[mailto:[EMAIL PROTECTED]Sent: Friday, November 07, 200
ince the rowsize
> can change radically, it can be way off the mark. Any help or pointers
will
> be highly appreciated.
>
> Thanks.
>
> Arup Nanda
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: [
, November 07, 2003 4:20 PMTo:
Multiple recipients of list ORACLE-LSubject: Re: Getting Number
of Rows in CTAS across DBLinkArup,
Any chance there will be an index on the table?
Daniel
"Arup Nanda"
the table?
Daniel
"Arup Nanda" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/07/2003 12:34
PM Please respond to
ORACLE-L
To: Multiple recipients o
c. and all those will not get into SYSTEM
tablespace.
Perhaps I should mention here is that I also conduct database security
audits for corporations. But unlike your auditors, I tend to follow the
advice up with more detailed information :)
Arup Nanda
www.proligence.com
- Original Message
TECTED]
> >
> > Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> > San Diego, California-- Mailing list and web hosting services
> > -
> > To REMOVE yo
> 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 ma
ED]
>
> 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 messa
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
le
apps there to get a feel for it? If you like it then you can think about
installing it in house.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, November 13, 2003 10:44 AM
>
>
>
>
> List:
ces
> -
> 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
>
yy')". The former is not in the same format as
the partition definition, i.e. "(to_date('14-nov-2003','dd-mon-'))", the
latter is; hence the optimizer made a smart choice. When the patterns mentioned
in the query and the partition definition don't
email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,
> or send email to [EMAIL PROTECTED] and
> include the word "subscribe" in either the subject or body.
>
>
> Friday, November 14, 2003, 1:04:25 AM, Arup Nanda ([EMAIL PROTECTED])
wrote:
> AN> Jon
f the last redo, your
best option is DG Max Performance (or Standby, in 8i), IMHO.
HTH.
Arup Nanda
www.proligence.com
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 11:54 PM
> Hello!
>
> What do you t
--
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
: 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 Netw
Title: RMAN - the time has come
In addition to the Freeman book, I would also
suggest the RMAN Pocket Reference from O'Reilly. It predates the RF book and
certainly comes handy for learning - I learned from there.
HTH.
Arup Nanda
- Original Message -
From:
Jama
space. Make sure you do the
same for any local indexes, too.
HTH.
Arup Nanda
- Original Message -
From:
NGUYEN Philippe (Cetelem)
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 22, 2003 10:34
AM
Subject: Exporting a partition with
transport table
; information. Also, please notify the sender that you have received this
> e-mail in error, and delete the copy you received."
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Davey, Alan
> INET: [EMAIL PROTECTED]
>
> Fat
You haven't specified the Oracle version. If it's
9i, you could use Fine Grained Auditing (FGA) to get the exact
SQLs.
Hope this helps.
Arup
- Original Message -
From:
Mauricio Vélez
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 29, 2003 1:39
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).
>
--
Plea
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 containing: UNSUB ORACLE-L
> (
at it?
http://www.amazon.com/exec/obidos/ASIN/0972751394/qid%3D1073685823/sr%3D11-1/ref%3Dsr%5F11%5F1/104-5146136-6379164
Six months of hard work gotta deserve something
better than the recyclebin, I sincerely hope.
Regards,
Arup Nanda
- Original Message -
From:
April
---
> > > 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 ORAC
o
difficulties, does not resolve them. I hope future versions of Oracle do
offer that functionality. It's not that difficult or unheard of, either.
Listener.ora, tnsnames.ora are all editable and also read by Net Assistant.
just my .02
Arup Nanda
- Original Message -
To: "Multip
You can drop or rename CUSTOMERS to, say,
CUSTOMERS_A, and then create synonym CUSTOMERS pointing to CUSTOMERS_B. Or
rename CUSTOMERS_B to CUSTOMERS.
HTH.
Arup Nanda
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent
and also CUSTOMERS_B.
Not just only one. If only one table, my head will not spin like this.
^__^ Ukrit K,
"Arup Nanda" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/16/2003 11:59 AM Please respond to ORACLE-L
101 - 200 of 327 matches
Mail list logo
