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
EE*
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, California-- Mailing list and web hostin
.1.7.1
Can anybody help please
Thanks
John
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
INET: [EMAIL PROTECTED]
Fat City Network 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: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-
.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, February 11, 2003 10:29 AM
> That mandates proper initrans and pctfree setting, don't
> you think?
>
> > -Original Message-
> > From: Arup
ltiple" of OS block size.
I don't know the downside of specifying an OS
block size of 2K or 8K. But if it can be done without any problems, I
supposethat will help in "split-block phenomenon" during hot
backup.
Arup Nanda
www.proligence.com
- Original Message -
bing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> 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
>
Title: Service startup on Windows 2000 fails
Lisa,
Just a thought - did you try starting the listener
from the command line - lsnrctl start?
Arup
- Original Message -
From:
Koivu, Lisa
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, February 19, 2003 9:08
-
it does not reduce the likelihood that more than one sessions will try to
get the same block to the buffer cache simulataneously.
Table drops appear a little slower in ASSM; but that could be wrong - I
never timed dropping a table in the system managed mode.
HTH.
Arup Nanda
- Origin
only 2 GB each, the
additonal space is used for other non-essential tasks like an occasional
export, the tools directory, etc.
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, February 19, 2003 12:28 PM
>
Title: Message
From the Fine Manuals
The operating system files are deleted
too, when an Oracle Managed logfile grup or member is dropped.
HTH.
Arup Nanda
- Original Message -
From:
Ramon E. Estevez
To: Multiple recipients of list ORACLE-L
Sent: Wednesday
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
at not result in BBW?
>
> John Kanagaraj
> Oracle Applications DBA
> DBSoft Inc
> (W): 408-970-7002
>
> Disappointment is inevitable, but Discouragement is optional!
>
> ** The opinions and statements above are entirely my own and not those of
my
> employer or clients *
ails
on.
HTH.
Arup Nanda
- Original Message -
From:
Ramon E. Estevez
To: Multiple recipients of list ORACLE-L
Sent: Friday, February 21, 2003 8:19
AM
Subject: Replication
I was asked of a
problem in a friend's site about replication.
The
[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).
>
--
Charu,
The view V$DBLINK can show you if the link is in use.
select open_cursors, in_transaction
from v$dblonk
where db_link = 'mylink'
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, February
Jackson,
I can't say it for HP-UX, but in Tru64 Unix, a cousin-in-law of HP-UX, the
error can occur if the ulimit is set too low. Check MetaLink Note 166350.1
for information on how to check and set the ulimit.
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipien
OVE 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 HELP comm
-
> > 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
&
: http://www.orafaq.net
> --
> Author: Jared Still
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> --
Title: RE: Partitioning
It's true for 9.2, too. It doesn't make sense to
have different storage parameters for hash partitions.
- Original Message -
From:
Jacques Kilchoer
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, February 26, 2003 6:39
PM
Subject:
8i and 9i) is.
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, February 27, 2003 8:19 AM
>
>
> On ORACLE 8i we need setup primary and standby databases same name
> otherwise will get "ORA-
ferent from the thread#.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, March 02, 2003 9:58 AM
> Oracle 9i has quite a few new columns added to the V$ARCHIVED_LOG
dictionary
> view,however there is no docume
: chao_ping
> 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 t
Thanks for the compliments, Jared. Much appreciated.
Arup
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, March 02, 2003 8:23 PM
>
> Congrats to Arup Nanda, whose bio appears
> in the latest issue
You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
> INET: [EMAIL P
he will eat for a day. But TEACH him how to fish,
> and...he will sit in a boat and drink beer all day"
>
> __
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Deshpande, Ki
Try OakTable Network. They have a paper on Windows RAC setup details.
http://www.oaktable.net/userFiles.jsp.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, March 05, 2003 6:34 AM
> Hi
>
>
> We a
Sure, checkout the Oracle Lite from
OTN.
- Original Message -
From:
Sultan
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, March 05, 2003 6:49
AM
Subject: Oracle Tools
Hi gurus,
Is there any Oracle tools available to use it in
Handheld Comp
Check Oracle
MetaLink Note 108723.1. There seems to be a problem when a numeric value is
specified for max_dump_file_size, rather than a K or M at the end. In short,
change max_dump_file_size to 10K from 10240, bounce it and
retry.HTH.Arup Nanda- Original Message - From:
shuan.tay(P
Sudhakar,
Unfortunately that's the only way to change teh trigger's ownership. But how
does it matter, if you drop and recreate the triggers in another schema?
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: W
Title: access to oracle $ tables in 9.2.0
Matt,
It's still valid in 9.2.0.2. Perhaps you need to
qualify the seg$ with SYS schema:
SELECT * FROM SYS.SEG$
HTH.
Arup Nanda
- Original Message -
From:
Adams,
Matthew (GECP, MABG, 088130)
To: Multiple recipien
Title: Queue_message wait event
Raj,
I assume you are using persistent queues. Each
queue resides on a queue table that is nothing more than a normal table
subjected to the same problems. By default the queue tables are created with
INITRANS 1 and FREELISTS 1, like regular table.
You have
Title: Forcing 2 Decimal Positions
Laura,
It woroks for me.
SQL> select to_char(clusterid,'9.90') from
t;
TO_CHAR(C- 1234.89
1234.80
SQL> select clusterid from t;
CLUSTERID--
1234.89 1234.8
SQL> col clusterid format 9.90SQL>
/
CLUSTERID-
TION P1999 VALUES LESS THAN ('2000%'),
PARTITION P2000 VALUES LESS THAN ('2001%'),
.
PARTITION PMAX VALUES LESS THAN (maxvalue)
)
Hope this helps.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
S
AK,
If the log buffer is at least 4MB, then increasing
it will not help, rather it may hurt. The log buffer is flushed when any of the
the follwoing occur
(i) 1 MB is filled up
(2) 1/3rd is filled up
(3) every 3 seconds
(4) when a checkpoint occurs
(5) when a commit occurs.
Therefore, see
the behavior I tested in 8.1.7; although I have not tested
in 9i. This has also been stated by several Oracle Support Analysts.
Thanks.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 7:32 AM
&g
ED]>
> Sent: Friday, March 14, 2003 4:32 AM
>
>
> > Arup:
> >
> >
> > The second condition is not quite true. It is 2/3 full in the current
> > versions.
> >
> >
> > It is very easy to test with the event 10046^8.
> >
> > KG
&
Join the file_id as well as follows
select segment_name
from dba_extents
where file_id = 123
and 259186 between blocks and
blocks+block_id
HTH
Arup
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Friday, March 14, 2003 11:03
AM
S
Every three seconds
> b.. When the redo log buffer is one-third full
> c.. When a DBWn process writes modified buffers to disk, if necessary
>
>
>
> At least this was the behavior I tested in 8.1.7; although I have not
tested
> in 9i. This has also been stated by several Ora
will lean towards CLIC
interface.
The environment you mentioned is not just viable,
but that's exactly how it is done.
HTH.
Arup Nanda
- Original Message -
From:
Thompson, Todd
To: Multiple recipients of list ORACLE-L
Sent: Friday, March 14, 2003 1:29
PM
Su
f possible, try to move the redo logs to non-RAID disks, preferably
local (direct attached).
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 5:34 PM
> log buffer is 320 K and log files ar
Server side, simply read record-by-record
from this view through the ODBC link and insert/update/delete as necessary.
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, March 15, 2003 2:18 AM
> Hello
seems stabler than 9.2.0.2.
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, March 18, 2003 9:58 AM
> Any opinions on which patchset of 9.2 is most stable: 9.2.0.1, 9.2.0.2,
9.2.0.3? We're running HP
Stephan,
I am wondering why would you not rate Tru64 as a stable platform. We are
using it for all our OLTP and datawarehouse needs; and it has been quite
stable. It's rather unfortunate that HP is retiring it in 3 years.
Arup Nanda
- Original Message -
To: "Multiple recipien
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 Se
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 21, 2003 8:53 AM
> Hi list
>
> Is there any way to remove a killed session from v$session. Is it even
> necessary to do that ?
> I ran t
Rahul,
The purpose of standby is to failover to it when
the primary fails - which could range from the CPU failure to SAN failure.
Although modern SANs are pretty robust, you account for the remote chance of
failure by building a standby. Placing the database on teh same SAN as the
primary
9900 SAN, Solaris 2.8, Veritas File System, Oracle
8.1.7.4, 1200 GB OLTP database with 6 GB SGA.
Hope this helps.
Arup Nanda
- Original Message -
From:
Joshua
Becker
To: Multiple recipients of list ORACLE-L
Sent: Thursday, March 27, 2003 10:33
PM
Su
---
> 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: UNSU
Why not just use the syntax select * from customerinfo
partition ()?
Much better solution, though, is to gather stats of
1% estimate and do the query. The partition elimination will automatically kick
in.
Arup Nanda
www.proligence.com
- Original Message -
From
batches, or 20,000 records
SET COPYCOMMIT 200
This process is fairly simple and can be easily automated using a shell
script. Any error raised by the sql block can be checked.
Hope this helps.
Arup Nanda
www.proligence.com
- Original Message -
To: "Multiple recipients of list O
20
before attempting the copy command.
Please let us know where you found that 64K limitation. The ohter thin you
have to consider is that COPY is being depecrated in 10i, or whatever it
will be called; but then again, I hope your application will have ceased
using LONGs.
Arup Nanda
But the key was setting the LONGSIZE
parameter in SQL*Plus. When I set it a low value, like 80 bytes, the value
was truncated.
Hope this helps in your archiving strategy.
Arup Nanda
www.proligence.com
- Original Message -
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 31, 200
data istruncated. If it is not, you may want to open up a TAR
pointing out the error in the document.
Thanks.
Arup Nanda
www.proligence.com
- Original Message -
From:
Sai
Selvaganesan
To: Multiple recipients of list ORACLE-L
Sent: Sunday, June 01, 2003 3:54 AM
Tim, Thanks for the compliments.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 10:59 AM
> You are a generous person, Arup! Thanks...
>
>
> on 5/31/03 10:54 PM, Arup Nanda at [EMAIL PROTECTED] w
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 HELP command for other in
n
CORE9.2.0.3.0 Production
TNS for Compaq Tru64 UNIX: Version 9.2.0.3.0 - Production
NLSRTL Version 9.2.0.3.0 - Production
SQL> create table testl (col1 number, col2 clob, col3 blob)
2 tablespace scl_aw_y03q2_data
3 /
Table created.
Could you please let us know where you got that in
e above
(2) The existing data from LONG can be painlessly migrated to LOB using
TO_LOB()
Their case against moving from LONG
Code change required
You counter argument:
Code change is minimal. Almost all columns that are used as LONG can easily
be converted to LOB.
Hope this helps.
Arup Nanda
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 C
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
IN
;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://ww
ments.
HTH.
Arup Nanda
Author of the forthcoming book "HIPAA Security and Auditing for Oracle" from
Rampant TechPress (www.Rampant.cc)
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 12:04 AM
Perhaps MBO (Mood Based Optimizer)!
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, June 11, 2003 7:39
AM
Subject: Re: Re: Rule Based
Optimizer
what did oracle use before the RBO? > > From:
Mogens Nø
That's correct. The poster didn't specify which version. If it's 9i the
options available are plenty.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 11, 2003 10:19 AM
> Beware th
you wish) on the table. The global index may be partitioned but the
partitioning scheme may not be even remotely close to that of the table. In
case of a partitoned table, you have to use the keywords LOCAL or GLOBAL in
index creation script to specify what it is.
Hope this helps.
Arup Nanda
fact I think (note sure) it is supported by Oracle. And it
should be; MLOG$ tables are just plain simple tables anyway.
Hope this helps.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 12, 2003 3:54 PM
GLOBAL is the default. If you ommiit the keyowrd, you have essentially
created a non-partitioned global index. This is not wrong; but do you want
to create a global index?
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent
ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Lee
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> --
201 - 300 of 327 matches
Mail list logo