Title: RE: RE: Silver vs. Gold support
-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
I am confused now ...
Likewise with Oracle, and other vendors - why complicate
things needlessly?
Life is bad enough as it is, why try to mess things up for
other
You should check size of table from dba_segments like
select segment_name,bytes from dba_segment
where segment_name = 'TABLE_NAME';
HTH
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Fri, 11 May 2001 06:51:17 -0800
OK,
To answer a
Walter,
Are ODBC connections, not really. Are Access connections bad, damn good
possibility.
The problem that I see with ODBC is two fold, 1) there are additional DLL's
needed to make it work and 2) there are s many ODBC drivers out there.
DLL's are probably the worst of the
So, there I am. An Oracle DBA with a host of MS Access databases that
end-users have created to do reporting via linked tables. Fine.
All of a sudden, one of these MS Access databases gets corrupted. Guess
what? It was also used to enter and hold production data! Eek!
I would like to
Does anyone have instructions or know where to find concise instructions on
setting up the Intermedia database objects (i.e. CTXSYS and what not) in an
8.1.6 instance? Like what scripts to run or is there a utility.
TIA
Bryan M. Miller
Junior Oracle DBA
IT Operations
Telergy Inc.
Email: [EMAIL
Jared,
I'm replying to the list since I don't see Nihar's
email address.
Multi-master replication would be an ideal candidate
for this situation as long as there is a primary key
on the table or one or more columns which can be used
to simulate a PK. It's always important to implement
conflict
Look how much you are saving using Silver support. The tell you the 800 # to call for
support 24 / 7. You never had that with Bronze support.. You had to pay the phone
company to place the call and then you couldn't get any price break for calling in the
evening because the Bronze support was
I have a user that keeps showing up in my NT database called DBSNMP. The OS
user name is SYSTEM. Does anyone know where this user might be coming from?
Ron Smith
Database Administration
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron
Hello,
We're Running Oracle 8.1.6.2 on Sun 420R with solaris
7. We have a front-end Siebel 2000 Sales Package. We
have about 50 concurrent users and a lot of Siebel
Workflow Process (which basically just route the work
from one user to the next... so lot of sql it send to
the server...) and
Check COMPAQ site for info. They partnered with Oracle to produce Oracle RAC.
ROR mª¿ªm
[EMAIL PROTECTED] 05/11/01 04:25PM
Rajnedra, Oracle9i RAC is what we now call Oracle
Parallel Server. Oracle9i RAC is still BETA, so there may
not be any white papers at the moment. I have looked and
Title: RE: When to go for ORACLE NAMES Server
I am
trying to find out the schema differences between two databases.
Differences like Column size,column datatype,column data length,
indexes,tables,constraints etc.
If
anyone has a script or know where I can get one that will accomplish this,
Hello, Cherie,
Short note first - when you drop primary key the associated index will be
dropped too.
To partition the index you will create this index first and then
alter table table name add constraint index name primary key(column
list);
HTH
Vadim Gorbounov
Rich,
As I stated in a previous post, we've got that GOD forsaken tool running
around here as well. Now Access is capable of doing it's own DDL in Oracle, but
I would not allow it since you get all of these object names with spaces case
sensitivity in them. Basically to access them from
Arkeia's rman media manager is only aviable for linux. I've asked them, maybe
they're too stupid or too lazy to port its interface library to other
platforms :-(
oli
[EMAIL PROTECTED] wrote
Does anyone use this? It looks funky and I am interested in any opinions
before I try it out. Im
On Fri, 11 May 2001,A. Bardeen scribbled on the wall in glitter crayon:
-Bottom line... if you implement replication without
-knowing what you're doing it's only a matter of time
-before your luck will run out and you'll have
-problems. Keeping your resume up to date would be a
-good idea ;)
-
Don, I hate to be a stick in the mud but there are some
things I think need to clarified.
I can think of no practical(?) use except for parallel server.
In parallel server an instance will aquire private rollback
segments specified in init.ora. If none (or too few) are
specified, it
Title: RE: Shared Memory Problem
Try to flush shared pool.
Rivaldi
-Original Message-
From: Upanesh Patel [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 4:06 PM
To: Multiple recipients of list ORACLE-L
Subject: Shared Memory Problem
Hello,
We're Running Oracle 8.1.6.2
If I use NOLOGGING as part of a CREATE TABLE or INDEX - it means that I
don't want the creation of these objects logged.
However , say I want to turn off the logging for conventional Inserts -
through transactions - how can I do that ?
vikas
--
Please see the official ORACLE-L FAQ:
Ron,
Thanks for your kind reply.
I'll give it a try.
Cherie
Ron Rogers
honey if I am the goddess here then who would I be afraid of exactly?
lol
From: Mohan, Ross [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: Silver vs. Gold support
Date: Fri, 11 May 2001 08:50:50 -0800
Is this truly
Oh, you wanted to set it up on NT? I CAN'T EVEN GET 8.1.6 ONAMES
*INSTALLED*, much less running! I finally just gave up and went with our
development HP9000 L-class as the backup server.
Erm, one other thing I just remembered: We are running 8.1.6 Networking on
the HP. Since my ONAMES is
Hi all,
I know how to generate the query plan but how to
interplate the query plan, really? The only thing I
know is if there is a FULL TABLE SCAN, that most
probably is bad, need to build an index. However, if
the query plan shows me something else, I don't know
what to improve.
For example,
Bryan,
A good start is Note: 101493.1 QUICK START GUIDE:
InterMedia Text Installation
There are others on metalink:
Technical Libraries button
Server - Oracle interMedia Text and ConText Option
HTH,
-- Anita
--- Miller, Bryan [EMAIL PROTECTED] wrote:
Does anyone have instructions or know
Raj,
It's new archiving tracing introduced in 8i. If
you're on 8.1.6 or later you can control the level of
tracing with the LOG_ARCHIVE_TRACE parameter.
See the following docs:
Note 94055.1 Init.ora Parameter LOG_ARCHIVE_TRACE
Reference Note
Note 104405.1 ARCH tracefile messages VALIDATE,
When you are doing a DIRECT LOAD INSERT, I know of a way to disable logging.
First what is a Direct LOad Insert,
An Insert stmt is said to be a Direct-Load insert when the INSERT INTO SELECT
command is used. This option is not available when INSERT INTO
VALUES command is used.
So, to disable
Hi Gurus
When I run one complex query I get the following statistics.
Statistics
--
832 recursive calls
4 db block gets
98502 consistent gets
0 physical reads
0 redo size
995 bytes
To install Intermedia as a separate product, the db has to be shutdown for
oracle exe to be relinked
Once the Intermedia product has been installed, the following steps must be
performed to configure it as shown below.
How to configure Intermedia?
Create the CTXSYS tablespace
create tablespace
Dear List,
I have a target database on host A and trying to duplicate to host B and
getting the following errors. It seems to me that host B is unable to read
the RMAN backup (tape file) created by host A. I tried setting NSR_CLIENT
variable at unix level, but without any success.
If I take
Dear List,
I have a target database on host A and trying to duplicate to host B and
getting the following errors. It seems to me that host B is unable to read
the RMAN backup (tape file) created by host A. I tried setting NSR_CLIENT
variable at unix level, but without any success.
If I take
- Original Message -
The $130 billion conglomerate, which boldly predicted last June
that it would use Internet technology to cut $10 billion in costs by
mid-2002, conceded last week that it will only record $1.6 billion in
savings this year.
Hmmm, sounds like GE has already spent
I think that is essentially what I said ... with a lot less detail.
I seem to have muddied it up a bit by not saying but only for Oracle7.
The specific case in point for the first correction was indeed
Oracle7. Later, in the discussion of rollback segments, you say
that can't happen, then
hai gurus,
i am getting the error ORA-00356. the redolog file
cannot be applied to the disaster site. i ran trace
but could not find any thing.
oracle support could not give a proper answer.
does any one got this error before. what could be the
possible reasons to cause this error.
Thanks in
There is a problem with multithreaded OCI programs connecting to an 8.1 database via
an Oracle ODBC driver. A long running query can block all other access to Oracle
from the same application server. We have some Visual Basic programs running on an
IIS webserver which have run into this.
|| -Original Message-
|| From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
|| Sent: Friday, May 11, 2001 10:21 AM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: RE: Silver vs. Gold support
||
||
|| so the support bill we just paid should get refunded because
||
HELP
On 11 May 2001, at 10:41, Mohan, Ross wrote:
...
But, even if I leave the happy world of Power Units,
Armani suits, and self-tuning apps, I will still
stay on this list, just to ask people my favorite
question: Are you an idiot?
--
Please see the official ORACLE-L FAQ:
Scott,
Agreed, but we were just letting off some steam due to the
great ongoing decline of civilization (a decline, which as the old
saying goes, started as soon as civilization was invented) as
epitomized by the meaningless insanity of reading an article about
details that contains no
Hi,
To shutdown the database for daily backup, I issue the following commands :
1) shutdown database abort
2) startup database normal
3) shutdown database normal.
Is this the recommended procedure, could gurus share your experience ?
Thanks.
Regds,
New Bee
--
Please see the
Ross,
What I was referring to was using Oracle Forms directly on
Unix, *not* through iAS. iAS takes care of that stuff for
you.
Lesse, I tried using forms 5.x on Solaris a couple of years
ago, and much to my dismay found that tnsnames.ora was
*required* in order to connect to a database.
Hi,
Preferably try for
1) Shutdown (normal mode ) .If your application has many user
connected tell them to disconnect first else this might take eons.
or
1) shutdown immediate . (Remember this will rollback transactions ,
but for long uncommitted transactions this will take a long
Eric,
Hm, I guess I will have to be a bit sharper next time (too much time spent
being nice to people, have to stop that)... yes I was being sarcastic. :)
I want to see you, Ross Mohan and lately Paul Drake in a face-off somewhere
for posts that are large, esoteric and wonderfully funny
--Boundary-00=_I6J7K4TVKE7DS65S6BN5
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Perhaps this will help.
If the attachments don't go through, I will resend
as part of the message.
FYI I haven't used the schema_diff.sql script in awhile, but
it
Hi Shreepad,
For scheduled batch job, I need to shutdown the database regardless whether
there are users connected to the system. Hence I use 1) shutdown abort 2)
startup normal 3) shutdown normal.
I know if I were to use shutdown immediate or shutdown normal, the database
will not be able to
Does anyone know why system tablespace is changing?
I'm doing an fromuser touser import and the system
tablespace is for some reason is being written to.
Here what is being reported:
IMP-00017: following statement failed with ORACLE
error 1652:
CREATE UNIQUE INDEX PK_BF ON PAGE (ID ) P
Robert Chen wrote:
hi,
Because a hacker hackered our system, I have to re-install the solaris. How
can I backup the oracle database?
Just backup all the physical files? I am not a back up and recover expert.
Please help me...
Robert,
If your Solaris box is truly compromised, a
Shreepad Vaidya wrote:
Hi,
Preferably try for
1) Shutdown (normal mode ) .If your application has many user
connected tell them to disconnect first else this might take eons.
or
2) shutdown immediate . (Remember this will rollback transactions ,
but for long uncommitted
101 - 145 of 145 matches
Mail list logo