Hello,
I have a problem and I hope you can help me.
We have a Oracle 9 installation two users with two different default
tablespaces. The problem is to move data between theese two users with
imp/exp.
I'll try to explain it a little bit more.
we have userA with the default tablescape tabA
Title: Win2k Perl accessing Oracle Parameters?
Hello All,
I am writing an perl script. I cann't figure out and have been going through the docs, but cann't find exactly what I need.
A way to access Oracle Parameters as they are set up in the Win2k registary. I am specifically thinking of
Dear
One of the solution is you can export in system user with two
user tables. You can exp/ imp blob column also. Later you can imp thru
system, but use from user and to user options.
I think it will help u.
Thanks and Regards
V.Baskaran
-Original Message-
Ciocildau
Sent:
Adrian Ciocildau wrote:
Hello,
I have a problem and I hope you can help me.
We have a Oracle 9 installation two users with two different default
tablespaces. The problem is to move data between theese two users with
imp/exp.
I'll try to explain it a little bit more.
we have userA
hi, i learned that i need net8 for linux to rebuild the DBD-Oracle perl
module. where can i download one for free
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: sonny e. supilanas
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Here's something to read registry keys I used a while back. Obviously needs
the win32 module installed.
use Win32::Registry;
$terminal = $ARGV[0];
$HKEY_LOCAL_MACHINE-Connect ($terminal, $hNode) || die Cannot connect to
$node;
$hNode-Open (SOFTWARE\\Microsoft\\Windows
Hi List,
We have Oracle 8.1.7, SunOS 5.8, SunFire 280r.
While using dbastudio and trying to add a database to the tree, no dialog
box opened to allow this operation.
I previously (some weeks before) have used dbastudio without any problems
and have added several databases to the
Tom,
I didn't mean to imply that you were going into damagement!
I was lucky enough to have someone point me to seminars and figured
I'd share my luck.
I think the reason they don't publicize it is that he is the only one
teaching it and it's full without publicizing. Can you imagine if they
I suspect the contractor will only provide the documents all parties agreed
to be delivered at completion.
Deliverables are part of the contract and require a considerable amount of
effort. If your company did not
account for this my guess is to document it in your lessons learned.
Are these Internals classes only available in the US?
-Original Message-
Carmichael
Sent: 29 October 2002 11:04
To: Multiple recipients of list ORACLE-L
Subject:Re: Oracle Internals course
Tom,
I didn't mean to imply that you were going into damagement!
I was lucky
Try BMC 's Control-M
Thanks
-Original Message-
Sent: Friday, October 25, 2002 11:34 PM
To: Multiple recipients of list ORACLE-L
To ALL,
About a week ago I asked if anyone had an opinion of CA's AutoSys
product.
Thanks to those who replied, but that was a pretty SMALL number.
Title: RE: List of Rows Updated
Auditing is much simpler and usable than logminer for *this purpose*.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't
Hi,
I've installed Application Server Infrastructure 9i Release 2, but i
skipped the configuration assistants. The Enterprise Manager Console
doesn't discover the Oracle HTTP Server even if was started with the
dcmctl utility. Are there configuration tools that configure the HTTP
server and
List,
I'm always keen to refresh on database comparisons so thanks for
everyone's pointers.
I'm surprised Oracle doesn't make more of an issue about their locking and
concurrency methods (i.e. redo/rollback/undo).
MSSQL seems to deal with it in two ways:
Default: readers and writers
We had to decide the same thing.
As soon as I saw that support is down in 9 months I decided to go with 9.2.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 29, 2002 3:53 AM
Thanx Joe.
let me think about it.
made the same experiences with iAS 92 and ended up
using 9iAS 1.0.2.2 for various reasons.
but we will try again, when oracle - hopefully - does provide a more comfortable way
of installation. we use portal, single sign on in connection with novel ldap. was
quite a toil to get it up and running
Back in 1999, I taught the 8.0 version of these seminars in Venezuela and
Argentina and was scheduled to do so in Columbia as well, except for some
minor problems like a US State Department travel warning due to kidnapping
of US citizens.
I don't know if they ever tried to teach these in more
Title: sqlplus /nolog
Hi!
I was wondering what
sqlplus /nolog
actually does on Unix? Is it only used for not listing username/password when doing a ps ? Or anything else?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut
hello to everybody
has somebody ever had the problem of accessing a variable in reports - need one that i
can store a value on, retrieve a value from, that is accessible globally and can be
displayed in the body part, regardless of frequency of group by's ecc. - something
like a user parameter
I have a 1tb db w/ 95% of it inline blobs, same tbs as data. No performance
degradation. However, if I were to do it again, I would have separated the blobs out
as B/R is a nightmare, soon to be better w/ RMAN. I haven't received my RF RMAN book
yet, amazon must be backfilling orders.
hth,
No I have given them for Oracle in Holland, Belgium, Norway, Singapore
and Malaysia.
Anjo.
-Original Message-
Sent: Tuesday, October 29, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L
Are these Internals classes only available in the US?
-Original Message-
Carmichael
Govind - I agree with Tom. Since you phrased your original question asking
for those who had done the conversion, the silence was your answer. If you
had also asked for replies from those who had decided to build new
tablespaces and convert the data ourselves, then more of us could have
replied.
The best way to calculate the size of a table is to
load it with 1000 production data rows. Then calculate
the size of the predicted volume.
You should be able to handle the first year of data at
day 1.
Do not loose time to calculate the table size at the
byte level with formulas.
For the temp
Title: Implicit Date conversion problem
We have a query (please don't ask me why it is written this way)
--Doesn't work:
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
where a.ep_number =
Thanks for the link !
Hemant
At 06:33 AM 28-10-02 -0800, you wrote:
Hemant K Chitale wrote:
Does anyone have benchmark or comparative figures for Sun SPARC v Compaq
(thenewhp) Alpha
for Oracle Databases ? I found some benchmark figures for Datawarehouses
at the
Oracle website but not
that I know of yes unfortunately, because I believe Scott is the only
one teaching the classes.
Is there a separate and distinct Oracle education site for the UK and
Europe?
Rachel
--- Mark Leith [EMAIL PROTECTED] wrote:
Are these Internals classes only available in the US?
-Original
Any idea about the chances in INDIA?
Regards
Naveen
-Original Message-
Sent: Tuesday, October 29, 2002 6:39 PM
To: Multiple recipients of list ORACLE-L
Back in 1999, I taught the 8.0 version of these seminars in Venezuela and
Argentina and was scheduled to do so in Columbia as well,
As a Consultant in a previous life I had done installations and upgrades
on various *nixs. I did think that Alpha and HP PA-RISC were better
than SPARC.
In this current organisation [as an internal DBA], about 66% of the
larger databases are on Alpha and the rest on SPARC. Again, I get
the
Title: Message
It is
just me or does 500-2000 per day seem a little "steep"?
Oracle8i: Everything You Always Wanted to Know about
the Optimizer
Instructor-Led
inClass
US$ 500
1 Day
English
English
OR
INTRODUCTION TO
Tim,
Do you mean this Scott Gosset is working here in the Netherlands or
used to be? Any idea about these courses in the Netherlands?
I can always call Oracle support here but I doubt if they know
about it.
Tia,
Jeroen
-Oorspronkelijk bericht-
Van: Tim Gorman
Title: sqlplus /nolog
It opens up a sqlplus session session/shell on the server without logging into a database. The 9i version of sqlplus does not allow for a command line: sqlplus / as sysdba command. You have to login to sqlplus and when prompted for the username then add / as sysdba. The
Actually, he isn't. There is another guy, named Scott Heisey, who teaches
an OPS/RAC version of this course. He is also supposed to be one of the
great sages of the Oracle Corp. I've attended Scott Gossett's course and it
was fabulous. I've only heard about Scott Heisey and it is my great wish
Thanks Greg. I'd be very interested in what you find.
To address the other responses,
1. the raid-1 configuration had 24 mirrored disk sets (48 spindles total). The raid-5
configuration also had a total of 48 spindles.
2. I'll be glad to send the whitepaper to anyone who requests it.
Russ
What is shown to you on the Oracle Ed site, is actually based upon where you are
located, within your login profile. I don't see any mention of Seminars what so ever
(being UK based).. Can anyone else in the UK confirm this?
Cheers
Mark
-Original Message-
Carmichael
Sent: 29
Oxford is using maestro and it is a good software.
-Original Message-
From: BALA,PRAKASH (HP-USA,ex1) [mailto:prakash.bala;hp.com]
Sent: Monday, October 28, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Scheduling software
I have heard that 'Maestro' is
Prem - Simple way to get in the ballpark with table size. Figure out how
large your average row is and multiply by the number of rows. This is only
approximate and you'll want to size larger for indexes and other effects
like the fact that your data blocks won't be 100% utilized. Better yet,
Rachel Carmichael wrote:
Is there a separate and distinct Oracle education site for the UK and
Europe?
Rachel
I am sure that Oracle UK has opted out of most of what is common fare on
the continent.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ:
Title: sqlplus /nolog
it
starts sqlplus without logging in to a database -
-Original Message-From: Daiminger, Helmut
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 29,
2002 8:29 AMTo: Multiple recipients of list
ORACLE-LSubject: sqlplus /nolog
Hi!
I was wondering
On Mon, Oct 28, 2002 at 08:58:32PM -0800, sonny e. supilanas wrote:
hi, i'm totally new to oracle, we have a webserver running on mandrake
and can make queries to mysql dbase using perl/cgi scripts on same unit
which works fine for our sites. but now, we have to connect to a remote
oracle
Title: RE: Implicit Date conversion problem
Well,
Let me point out one thing following is the original query ...
-- this returns no rows ...
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
Looks like I'm gonna implement a stand-by database on
Windows 2000 using Oracle 8.1.7.4
Anyone have any good article, how-tos, caviots I need
to consider or read up on?
Lizz
__
Do you Yahoo!?
HotJobs - Search new jobs daily now
If the TPCs can be believed, I guess this would make a good ruler, too:
http://www.top500.org/list/2002/06/
I don't even know what 3016 processors look like. ;)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI
Title: sqlplus /nolog
Helmut,
It
makes sqlplus act like svrmgrl.
I use
sqlplus this way, followed internally by a connect as sysdba command to start
and shutdown the database on 9i.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Daiminger, Helmut
Title: sqlplus /nolog
It
originates fromthe wonderful OS that used to have commands like "SET DEF",
"MONITOR MODES",
"BACKUP/IGNORE=INTERLOCK SYS$ORACLE:[]*.*
MU:" and alike. There is also an abomination
of
this OS created by David Cuttler.
-Original Message-From: Daiminger,
What does doesn't work mean?
Wrong data?
Error message?
etc...??
Also the trunc(to_date('01-Jan-03','DD-Mon-YY')) is not quite right
most likely.
It should probably be:
trunc(to_date('01-Jan-03','DD-Mon-YY'))
to_date('01-Jan-03 23:59:59','DD-Mon-YY' HH24:MI:SS')
or if used with a
No. Scott said he's been to a number of Pacific Ocean countries to teach
the course. I suspect those courses where hosted by a company which had
offered enough internal enrollment. As I recall, there's another instructor
who also teaches the Internals, Crashes/Dump/Traces and Backup/Recovery
This is a multi-part message in MIME format.
--=002_Dragon805267761306_=
Content-Type: text/plain;
charset=GB2312
Content-Transfer-Encoding: quoted-printable
Daiminger, Helmut=A3=AC=C4=FA=BA=C3=A3=A1
=A1=A1=A1=A1It is used when you want to do it in your shell script, or
can someone provide me with a link to get a oracle 8i
CD ?
there was one available from the oracle store for
around $40 (for 8i). i don't find that link there any more.
__
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
If the value is not dependent on the parameters entered by the user then you
can have it a user parameter not displayed in the parameter form.
Alternatively, you can also use a placeholder column to achieve the same. You
can place it outside of any group.
Regards
Naveen
-Original
Title: sqlplus /nolog
sqlplus /nolog starts sqlplus, but does not connect
you to any database, nor does it prompt you for a
username/password.
- Original Message -
From:
Daiminger, Helmut
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, October 29, 2002 8:29
Dick,
We've looked at another scheduling tool that's paticularly good at cross platform job
dependancies etc. that has support for Peoplesoft. The product is called OpCon/xps
from a US based company called SMA.
Before you ask, no, I receive no commisions from this company.. ;) We did in fact
Title: RE: List of Rows Updated
Gosh. I wish I worked in your shop. I'm
typically asked to produce an audit report for yesterday on a table I didn't
even know existed. "What do you mean you can't do that? Aren't you
an Oracle DBA?"
- Original Message -
From:
Jamadagni,
Title: RE: Implicit Date conversion problem
http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96540/sql_elements2a.htm#54201
Look up for table 2-10 and then below the table look for 4th bullet ... that's where I found it out ...
At-least Tom you know my
Look out for the Pentium 4 bug.
Other than that I've found it to be pretty straightforward.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Title: Message
Oracle didn't start offering instruction directly
at your desktop or urge you to open up an iTAR instead of talking to a Customer
Service person for nothing. People are expensive.
- Original Message -
From:
Bob
Metelsky
To: Multiple recipients of list
On Tue, Oct 29, 2002 at 06:58:49AM -0800, Gogala, Mladen wrote:
It originates from the wonderful OS that used to have commands like SET
DEF, MONITOR MODES,
BACKUP/IGNORE=INTERLOCK SYS$ORACLE:[]*.* MU: and alike. There is also
an abomination
of this OS created by David Cuttler.
Cutler
In addition to BIshop's excellent response, be sure to install
the latest version of Tie:Registry. The one that comes with
ActiveState Perl doesn't work properly.
The current version (as installed from ActiveState via PPM)
is I believe 1.24. Just reinstall it.
Jared
On Tuesday 29 October
Hadn't thought of trying that; makes sense. Thanks.
--- Reardon, Bruce (CALBBAY) [EMAIL PROTECTED]
wrote:
When you tried under NT, did you use sqlplus.exe or sqlplusw.exe?
If you used sqlplusw.exe, this sounds like Bug No. 1504702
The workaround is to use the copy command from the
One of the best sources of information is a white paper by Lawrence To
called Graceful Switchover and Switchback for Standby Databases
(Metalink note 90817.1)
Another one under the White papers sectiopn is note 91570.1 but I have not
looked at that
John
-Original Message-
Sent: 29
Scott Heisey taught the New Features for 8i administrators class that
I took.
Yeah, he's in my top ten of Oracle instructors.
A not at all complete, in no particular order list is:
Scott Gossett
Scott Heisey
Sue Jang
John Hough
Please note, I have NOT taken classes from all the Oracle
otn.oracle.com is the right place.
Jared
On Monday 28 October 2002 20:58, sonny e. supilanas wrote:
hi, i'm totally new to oracle, we have a webserver running on mandrake
and can make queries to mysql dbase using perl/cgi scripts on same unit
which works fine for our sites. but now, we have
Title: Implicit Date conversion problem
Raj,
you
are forgetting how dates are stored internally vs. how they are displayed by
sqlplus.
change
your first query to:
select ea1.ep_number, ea1.est_dt,
veas.est_dt from (select a.ep_number, ea.est_dt
from
v_episode_avail_summary_break a,
Actually, I am sending and receiving files.
They will be handling the FTP of the files, and making sure it has FTPed
correctly.
I just have to have a sanity check of the file. Basically, I decided to
prefix each data line with 'DAT', and the CRC line with 'CRC'. The
flat file is read into the
Title: RE: Implicit Date conversion problem
Sorry about that ... I am working on a sev-1 problem with Oracle (ora-904 error if anyone is interested).
Doesn't work means it doesn't return any data the working query returns correct number of rows. the trunc() syntax is right ... est_dt
On Tue, Oct 29, 2002 at 01:48:38AM -0800, sonny e. supilanas wrote:
hi, i learned that i need net8 for linux to rebuild the DBD-Oracle perl
module. where can i download one for free
otn.oracle.com, you have to download oracle for linux and install it.
The installer gives you the option to
Russ:
We're using EMC Clariion disk arrays. These are using EMC's version
of RAID-5; they call it RAID-S. There is 2GB of cache if front of
the disks. They claim that the cache is write guaranteed so that
we'll never lose an update. So far, so good, and the performance
has been acceptable,
What a guy that Joe is. ;-)
But Joe, I thought you were getting out of the DBA business.
--- Joe Testa [EMAIL PROTECTED] wrote:
well that didnt work, ok how about cut/paste :)
Joseph Testa bought a few things at Amazon.com and wanted to offer
you a
discount on them.
Its the new
Dear gurus !
We are trying to analyze a table partition (estimate 2 %) and it takes
forever.
analyze table ... partition (P20021022) estimate statistics sample 2
percent;
For instance, select count(*) from the same partition takes 10 minutes , but
the analyze takes literally infinite amount of
Mark Leith wrote:
What is shown to you on the Oracle Ed site, is actually based upon where you are
located, within your login profile. I don't see any mention of Seminars what so
ever (being UK based).. Can anyone else in the UK confirm this?
Cheers
Mark
Nothing of the sort visible
Some guy in the Netherlands uh huh
--- Anjo Kolk [EMAIL PROTECTED] wrote:
No I have given them for Oracle in Holland, Belgium, Norway,
Singapore
and Malaysia.
Anjo.
-Original Message-
Sent: Tuesday, October 29, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L
Raj:
The date column has a timestamp value as well. By using the TRUNC
function, you are getting all dates regardless of the time value (i.e.
12:01 AM, etc.) . When dealing with DATE datatypes it is always a good
practice to use the TRUNC function on the columns to prevent the time of
day
On Tue, Oct 29, 2002 at 07:23:33AM -0800, Lizz Pena wrote:
Looks like I'm gonna implement a stand-by database on
Windows 2000 using Oracle 8.1.7.4
Anyone have any good article, how-tos, caviots I need
to consider or read up on?
--
caveat, from Latin, let him beware. Ain't English great,
Title: sqlplus /nolog
It
doesn't?
$
sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 29 10:39:53
2002
Copyright (c) 1982, 2002, Oracle Corporation. All rights
reserved.
Connected to:Oracle9i Enterprise Edition Release 9.2.0.1.0 -
ProductionWith the
Greetings ALL..
I have been assigned a security research project by my boss. Really simple
topic, o/s authentication vs. password file authentication. Currently we use
a password file, and the boss wants to know what it would take to convert to
o/s authentication instead. However, I'm not
It's these readers-blocks-writers and dirty reads that makes people migrate
their data to Oracle. Blocking writers kills performance. Of course
constantly rolling back blocks to give queries consistent views uses i/o and
cpu. But that extra overhead rarely impacts overall performance as badly
Hi,
what do you mean with to export in system user with two user tables ?
Regards,
Adrian Ciocildau
Oracle wrote:
Dear
One of the solution is you can export in system user with two
user tables. You can exp/ imp blob column also. Later you can imp thru
system, but use from user and to user
Thanks for all the replies. It makes me rethink going to iAS 9.0.2.0.1. Does iAS
1.0.2 require all the same dependencies, i.e. infrastructure install?
Gene
[EMAIL PROTECTED] 10/29/02 07:53AM
made the same experiences with iAS 92 and ended up
using 9iAS 1.0.2.2 for various reasons.
but we
Title: RE: Implicit Date conversion problem
Raj,
you
said:
"according to Oracle, when comparing a
varchar2 to a date column, the string does get converted to a date ...
"
This
has got to be wrong. If you compare a varchar2 column with anumber,
Oracle try's to convert the varchar2 to a
Solaris 5.7
From: Fink, Dan [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Data guard
Date: Mon, 28 Oct 2002 13:43:33 -0800
What platform are you on?
If UNIX, make sure your i/o settings for reads and writes (asynch or
Jamadagni, Rajendra wrote:
Well,
Let me point out one thing following is the original query ...
-- this returns no rows ...
select ea1.ep_number, ea1.est_dt, veas.est_dt
from (select a.ep_number, ea.est_dt
from v_episode_avail_summary_break a, episode_airings ea
A quick question out to the masses..
How many of you out there are ACTUALLY USING 9i RAC technology?
If not already using it - how many have plans to use it (or at least plan to
investigate it)?
Cheers
Mark
===
Mark Leith | T:
Tom,
If the string matches the NLS_DATE_FORMAT, Oracle will convert it to a
date.
Try this:
create table d( d date );
alter session set nls_date_format = 'dd-mon-yy';
insert into d values('21-dec-02');
insert into d values('22-dec-02');
insert into d values('23-dec-02');
insert into d
This is what we have in mind.
For the partitioned tables that are going to have the 'rotation' logic,
we will convert them to LMT when they become empty. We drop the
'oldest' partition and create a new one for next month. This will be
carried out every month. Partition for November data is empty
Jared:
PPM search Tie::Registry
PPM search Win32::Registry
Packages available from
http://ppm.ActiveState.com/cgibin/PPM/ppmserver.pl?urn:/
PPMServer:
Win32-Registry-File [1.09] Perl interface to MS-Windows registry files.
PPM
Is 1.09 really what I want to install?
Cary Millsap
Hotsos
I run it at home on the laptop if that counts :-)
But seriously, I'm working with a client who are
migrating from a large Sun box to a 4node Tru64 RAC
architecture on 9.2
Do I think it will workprobably not
Cheers
Connor
--- Mark Leith [EMAIL PROTECTED] wrote: A
quick question out to
Sorry in advance, but I didn't think I'd need this.
There was a discussion about 4 weeks ago if memory
serves correct, about denying users logging on to
Oracle directly either through SQL*Plus or other tools
such as TOAD. Tried searching the archives but
getting too many hits.
Someone posted
I beg to differ Mr. Holman. The sqlplus command should work if the / as
sysdba is enclosed in quotes. So , the command would be
sqlplus / as sysdba . This works in Oracle9i on Unix and Windows NT/2000
environmnents. At least it does so in my environments.
RWB
Rodd Holman [EMAIL
No, 1.0.2 is a leaner product - no infrastructure required.
Scott Shafer
San Antonio, TX
210.581.6217
-Original Message-
From: Gene Sais [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, October 29, 2002 10:24 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Installing iAS
The BLOB can be in line if the size is less than 4k, otherwise it is
stored as out-of-line.
RWB
Gene Sais [EMAIL PROTECTED]@fatcity.com on 10/29/2002 07:39:01
AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
We are planning to use it on Solaris.
Gerardo
-Original Message-
Sent: Tuesday, October 29, 2002 8:30 AM
To: Multiple recipients of list ORACLE-L
A quick question out to the masses..
How many of you out there are ACTUALLY USING 9i RAC technology?
If not already using it - how many
Title: sqlplus /nolog
Ah ha. It's the double quotes you use. These were not necessary with svrmgrl
Rodd
On Tue, 2002-10-29 at 09:49, Toepke, Kevin M wrote:
It doesn't?
$ sqlplus / as sysdba
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct
Am I looking for trouble by mixing an OLTP type database
with a DSS type database?
I currently have a relatively small database that is used
for quick lookup type actions. The company wants to add a much bigger and
constantly growing application for historical reporting on the same
Esto me dio mucha risa. Alguien lo va a traducir al ingles para el
resto de la lista?
Esteban
[EMAIL PROTECTED] 10/24/02 12:05PM
Ups colegas !
@lex
Lic. Alexander Ordóñez Arroyo
Soporte Tru64Unix BD Oracle
Caja
Mark,
If you read the latest Oracle Mag (Peer-to-Peer), you will find that a
(sometime?) list member Murali Vallath is using RAC and is actually planning
a book sometime later. Maybe you can address the question to him? Murali
presents/attends IOUG and I know for sure that he 'speakes from the
Title: RE: analyze table takes forever
what's the structure of the table?
And try taking an export of this partition and import it into it's own table in a development box... see if you can analyze it there.
Nick
-Original Message-
From: Andrey Bronfin [mailto:[EMAIL
We are currently running 8i OPS and having serious issues with global cache
request waits that kill the performance on the machines. Because of this
issue, we are almost being forced to upgrade to 9i RAC.
I hope and pray that this will work out, but I've learned to not count on
much until you
Jared,
Of course, I have been corrected!
Woo-hoo! I win! I learned something new today! I get to go home early!
Wow. This was really a shocker to me. I tried a little test myself on an
817 database and it works as Raj (and the documentation) said it would.
Does this mean I will change my
Title: RE: 9i RAC
forget 9201 ... 9202 has about 20+ fixes that are related to RAC code. ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that
Cary,
Here's what my search of Registry revealed:
PPM search Registry
Packages available from
http://ppm.ActiveState.com/cgibin/PPM/ppmserver.pl?urn:/PPMServer:
Win32-Registry-File [1.09] Perl interface to MS-Windows
registry
files.
John Kanagaraj wrote:
Mark,
If you read the latest Oracle Mag (Peer-to-Peer), you will find that a
(sometime?) list member Murali Vallath is using RAC and is actually planning
a book sometime later. Maybe you can address the question to him? Murali
presents/attends IOUG
What is more
1 - 100 of 144 matches
Mail list logo