Rather than re-invent the wheel, I'll let Steve Adams explain it.
Besides, his explanation is better than the one I was going to give. :)
http://www.ixora.com.au/tips/design/synthetic_keys.htm
Jared
On Friday 11 May 2001 23:55, Vikas Kawatra wrote:
> Reverse key indexes are good for columns
abdul latif wrote:
>
> 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
I agree with Dick whole heartedly on this. Access can kill your db
management. Especially if you allow the end users DDL capability. It's
bad enough with the posibility of runaway dml stuff, but the real
nightmare is with allowing DDL. To open up your db for such could
really
have people a
Ron,
That's the good old Oracle Intelligent Agent for Enterprise Manager. It
is the ID that talks to the OEM console for events reporting.
Rodd Holman
>> Original Message <<
On 5/11/01, 2:45:31 PM, "Smith," Ron "L." <[EMAIL PROTECTED]> wrote
regarding
DBSNMP u
Scott,
Your posts to this list have been prolific today.
Thanks for sharing your expertise, I hope we can
hear more from you on occasion.
Thanks
Jared
On Friday 11 May 2001 13:15, [EMAIL PROTECTED] wrote:
> Eric, Sales and marketing have 1 job and that is to sell
> and market. These marketi
Reverse key indexes are good for columns populated by sequence no's
Does that mean that for surrogate Primary key's on OLTP systems - which are
populated by sequences - performance could be enhanced by creation reverse
key indexes - rather than using the B*Tree unique indexes which are
automatical
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 uncommitte
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
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
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
--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 sh
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
Rache
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 tim
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. This
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 of
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 detai
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: http:/
> || -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
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. W
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 adv
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", th
- 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 sp
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 di
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 di
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
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 sen
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 log
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,
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
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,
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 8.
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
Ron,
Thanks for your kind reply.
I'll give it a try.
Cherie
"Ron Rogers"
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: http://www.o
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 o
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,
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 ;
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 t
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 o
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 add constraint primary key();
HTH
Vadim Gorbounov
Brainbench Master Oracle DBA
www.
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,
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
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 hav
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 L.
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 f
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
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 PR
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 create
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
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
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
Title: RE: Password with special character
> -Original Message-
> From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
>
> I am using Oracle 8.1.6 Solaris 7
> Install patch bug122 for SQL*PLUS
>
> How can I change user password with special character
> alter user teddy identified
Oracle will automatically create an index for your primary
key constraint.
I have a lot of large partitioned tables in my data warehouse.
All of my primary key indexes are non-partitioned. I would
like them to be partitioned.
When I drop the constraint and re-enable it, can I specify
at that t
well if you are lucky and all the files are there, yes, backup the physical
datafiles and when you bring the database up again, Oracle will recover.
You MAY have to open the database resetlogs.
Questions though:
is the database still up? Can you shut it down cleanly (shutdown) and then
do a c
Unal, What part of the block sturcture? Segment Header,
Datablock Header? There are things in the blocks that are
no different than they where in 6,7,8 or 8i. However with
some of the new features such bitmap freelists, low
highwater mark, high high waterwater, and changes to
pctfree. There a
ftp the file to the server again in binary mode instead of ascii...
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: Mohit Goyal [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 6:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: import from co
Cherie,
I take it that you built your indexes as create index xxx on table(col) local
(partition x1 on tablespace 95,
partition x2 on tablespace 96..)
then you truncated the table in the partition 95 and then dropped the partition.
If I remember correctly the index for the dropped partition
On Fri, 11 May 2001,Boivin, Patrice J scribbled on the wall in glitter crayon:
->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 people even
->more.
Because they can?
--
Bill Thater Certifia
dbms_lock.sleep will do this...
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
05/11/01 10:20 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Your archiving is TRUE instead of false
Check for log_archive_start FALSE
change this parameter to false and rebounce your database.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Fri, 11 May 2001 08:46:06 -0800
DBA
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
have not found any white papers on RAC.
Scott
> Dear Friends
>
> Does anyone have any knowledge or experience with "Oracle
Title: RE: When to go for ORACLE NAMES Server
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> We have 20+ instances & this mess called PeopleSoft, so
> keeping track of
> TNSNAMES is a real tedious thing to do. Consequently we
> migrated to Oracle
> Na
Jared,
You may have just earned yourself a dinner. (And I
promise you will not receive it the way you did my
$0.02 recently ;-)
Can you tell me more...alot more would be grand...about
how Forms needs tnsnames?
*thanks*
Ross
|| -Original Message-
|| From: Jared Still [mailto:[EM
Try
DBMS_LOCK.SLEEP (
seconds IN NUMBER);
Regards
Karthik Ramachandran
>>> [EMAIL PROTECTED] 05/11/01 11:20AM >>>
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
Title: RE: When to go for ORACLE NAMES Server
There is one thing to be aware of. In a very large
environment, (which you may or may not have) you
don't always want everyone to be able to connect to
everywhere. By using tnsnames.ora files, we can control
which clients are allowed to connect
Hi:
use the procedure:
dbms_lock.sleep(seconds);
HTH
> --
> Von: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> Gesendet: Freitag, 11. Mai 2001 17:20
> An: Multiple recipients of list ORACLE-L
> Betreff: PL/SQL Question
>
> I need to whip out a PL/SQL procedure real quick to
Too much of a kill? Not at all. We are currently running ONAMES, and are
planning on going OID as soon as we can get some time. OID (Oracle's LDAP)
has other benefits like being able to authenticate more than just Oracle
connections.
ONAMES is relatively easy to setup. For your configuration,
>For those of us who are beyond paranoid ... and would be carrying the
>tapes to the remote data center.
HEY! I resemble that remark!
Rachel
>From: Paul Drake <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re: Contigency
Pat,
I could be totally off base here, but I believe that errors in the
-2 to -20100 range are user defined via the RAISE_APPLICATION_ERROR
procedure. That being the case you may not be able to find the error unless you
have the source code.
Dick Goulet
Reply Separ
Love it! It's open to change.how cool.
|| -Original Message-
|| From: Gary Boyd [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 10, 2001 9:16 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: PostGres WAS: RE: Oracle 9i Articles - self
|| tuning, launch
||
||
||
Sinardy Xing wrote:
> Hi all,
>
> Can Oracle User change their password with special characters?
As with other Oracle identifiers, you have to put double quotes around the
password to include nonstandard stuff.
SQL> ALTER USER SCOTT IDENTIFIED BY "*&^%$$# L";
User altered.
SQL> CONNECT scott/
FYI I am forwarding this to the list, so please address
replies to the original sender.
-- Forwarded Message --
Date: Fri, 11 May 2001 12:45:43 +0530
Hi jared
This is Nihar from india. I am having some query regarding Oracle
Replication.
Basically i am having 2 diffrent se
I ran a few tests of this on both a 7.3.4 and 8.1.6 database and found there
is definitely a difference in the way Oracle handles FK constraints. In my
tests, I created a PARENT and CHILD table, with FK constraint, and with a
trigger on the CHILD. I used two differenct after update triggers: one s
Eric, Sales and marketing have 1 job and that is to sell
and market. These marketing things are teasers not
necessarily giving detailed information. I have not
checked but there may be some Oracle9i stuff on OLN. I
think OLN has a trial membership (for 30 days?). However
I am not sure of the
dbms_lock.sleep(second in number);
>>> [EMAIL PROTECTED] 05/11/01 11:20AM >>>
I need to whip out a PL/SQL procedure real quick today and have a quick
question for fellow-listers ( since today is Friday, hopefully I don't get
RTFMed on this one :) )
The purpose of my procedure is to collect stats
Is this truly the beloved authoress of Oracle DBA 101 I hear?
You speak sourly of our Lord in front of his very home?
|| -Original Message-
|| From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
|| Sent: Friday, May 11, 2001 10:21 AM
|| To: Multiple recipients of list ORACLE-L
|| Subjec
Diana,
Sounds like an excellent alternative to higher end systems (shoots self in
oracle-foot). Have you tested how well it scales yet?
Scott Shafer
San Antonio, TX
210-581-6217
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 10:27 A
[EMAIL PROTECTED] wrote:
> I am wondering if there is a similar
> function in PL/SQL similar as the Unix 'sleep' command.
Use dbms_lock.sleep -- it's pretty much like Unix sleep, but requires you to
grant execute on dbms_lock to whichever account needs it.
Bill
--
_
Thanks to all who replied, it works.
>>> [EMAIL PROTECTED] 05/11 1:42 PM >>>
> -Original Message-
> From: james ellis [mailto:[EMAIL PROTECTED]]
>
> connect as sys or system.
> drop user "username" cascade;
> The user and all objects will be removed.
>
> --- Mujeeb Chowdhry <[EMAIL PR
Hi,
I've installed RMAN 8.1.7 with my db on NT. I also
use it to back up another NT cluster instance, also
8.1.7. I also wanted to use it to backup a HPUX 8.1.5
instance but i get an error Target DB is not
compatible with version of RMAN. Now I get two
answers from Oracle. The first one says
Dan,
While this does not work as is, but probably could be in
some fashion, you win the days raspberry for the most
obfuscated answer. :)
Jared
On Friday 11 May 2001 09:56, Dasko, Dan wrote:
> while trunc(sysdate, ss) = 30 loop
>
> I think this should do whatever's in the loop every minute on
I was also under the impression that Oracle was just splitting up the cost
for Upgrades and Support mainly because these two pieces can be dealt with
differently for tax purposes. I have no clue what makes large (or even
moderately small) corporations happy, but apparently this is one thing that
d
Write a package.
David A. Barbour
[EMAIL PROTECTED] wrote:
>
> How can I write procedure which runs 3 different subprocedures.?
>
> Roland Sköldblom
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services
On Fri, 11 May 2001,Mohan, Ross scribbled on the wall in glitter crayon:
->question: "Are you an idiot?"
Yes, but everybody already knows that.;-)
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta
If there is a lot of objects in the schema you may need to increase
parameter enqueue_resources. If not enougn enqueues this command will give
you an error and user and some objects will not be dropped. If you don't
want to increase this parameter you can repeate this command until user will
be d
We had a similar thing when we upgraded OS last weekend. Re-linking sqlplus from the
correct (i.e. new) ORACLE_HOME resolved our problem.
HTH
Stephen
>>> [EMAIL PROTECTED] 05/11/01 01:35AM >>>
Hello DBA's
I have recently upgraded from 8.1.6.0 to 8.1.6.3.
I seem to be having a weird problem
If you're using the a profile with a password_verify function, then you
shouldn't be using ALTER USER to change a user's password. If you are
trying to change the password through SQL*Plus, then you should instead be
using the SQL*Plus PASSWORD command:
SQL> PASSWORD
Using this command will va
I think if you offline a tablespace (or is it
read-only? I can't remember), then any relevant
buffers are flushed out...
hth
connor
--- "Hillman, Alex" <[EMAIL PROTECTED]>
wrote: > Mark, how do you manually remove objects from
buffer
> cache? I saw you
> writing before that you know how to do it
Yes, I join you in significant frustration with oracle.
( Although I had a visitation from an OWS goddess just
recently that ameliorates my rancor significantly.)
Things like
Postgres www.postgresql.org
and Kdb www.kx.com
are becoming increasingly interesting to me.
But, even if I leave
Yes, it's open source.
My personal project uses Apache, PHP and Postgres on Linux servers -- pure
open source. Guess how long the servers and the web server and hence the
site have been up? Pretty much since we installed. Love it!!! For those
of you who don't know, PHP is a server-side "temp
I am confused now, I thought Oracle was "rolling up" the support costs into
the license cost calculations now that they discontinued the Bronze, Silver,
Gold support options.
This is like income tax forms! Why can't they just create an income tax
form that is only half a page long! I can't beli
Somewhat of a pain to setup for the first time, for sure.
But after you get it implemented, you will never want to
go back.
One caveat: There is a fair amount of software around
that *requires* tnsnames.ora or it won't work. Oracle
Forms on unix comes to mind. Yes, Oracle's own software
does
This one's got me stumped. We are on 8.0.4 on Sun Solaris 2.6.
I have some locally indexed partitions on a table that's
partitioned by time. I dropped the '96 and '95 partitions
of the underlying table and I no longer see them. I used
the following statements:
alter table xx truncate parti
We have 20+ instances & this mess called PeopleSoft, so keeping track of
TNSNAMES is a real tedious thing to do. Consequently we migrated to Oracle
Names & have loved it ever since. If your going to get on Onames, use either
7.3.4's version of 8.1.6's. 8.0.x's version has way too many bugs.
Di
if the "tedious"ness exceeds your perception of the difficulty, do Names.
if not, not.
In my very limited experience, a truly robust, well-managed Names service
is great, but takes some work to set up, test, and document.
YMMV
|| -Original Message-
|| From: Johnson Poovathummoottil
LOL!
There are enough disasters in the world to support a journal?
: )
(I know, I know... it's to plan ahead, just in case. I still think this was
funny though. It's Friday, OK?)
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèm
while trunc(sysdate, ss) = 30 loop
I think this should do whatever's in the loop every minute on the 30 second
point.
-Original Message-
Sent: Friday, May 11, 2001 11:20 AM
To: Multiple recipients of list ORACLE-L
I need to whip out a PL/SQL procedure real quick today and have a quick
On Fri, 11 May 2001,Mohan, Ross scribbled on the wall in glitter crayon:
->Is this truly the beloved authoress of Oracle DBA 101 I hear?
->
->You speak sourly of our Lord in front of his very home?
Ross be careful. Remember "do not meddle in the affairs of dragons, for you are
crunchy and go
Title: RE: Drop schema and all related objects
> -Original Message-
> From: james ellis [mailto:[EMAIL PROTECTED]]
>
> connect as sys or system.
> drop user "username" cascade;
> The user and all objects will be removed.
>
> --- Mujeeb Chowdhry <[EMAIL PROTECTED]> wrote:
> >
> > How
Paul,
Clarification: I didn't write the material, I was just
posting an excerpt from an Oracle document.
Anyway, I vastly enjoyed your comments. so. I take it
that you also found the lack of detail about "self tuning"
to be problematic. :)
Presumably we now have a lot to look forward to in
1 - 100 of 147 matches
Mail list logo