Dear DBA Gurus,
I have a .sql file which contains a series of insert statements. I want to
call this .sql file and run it from a stored procedure. Is it possible? If
so, how?
Please post your answers to me directly as I am not receiving messages
directly from the list rather
but doesnt make utility uses C compiler ? (or it's a bare bones installation
of a C compiler?)
i guess i;m wrong on this one...
--
From: Rao, UmaSankara S (CAP)[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Thursday, August 16, 2001 1:25 PM
To:
No - if you draw a diagram showing the 4 calls given in the original test
data, you can see clearly that at no time are there more than 3 calls in
progress simultaneously. Unless you're using some strange definition of the
word simultaneous of which I'd previously been unaware...
Hi list,
a quick question about oracle optimizer.
a customer has database migrated from 7.3.4 to 8.1.6 on AIX. Data was
transfered via full exp/imp. After migration the performance of the new
database is very poor. I looked at the parameters and saw that no object is
analyzed. So now me
I agree with you on that one, but what I was saying, (and I posted this in
an earlier message) was that I interpreted the intial email wrongly. I was
looking at:
- over all the time periods how many simultaneous calls were there (not at
any particular moment in time)
therefore I was getting
Sorry to resurrect this thread and pick holes, but I was thinking about this
query on the way home last night (sad, I know) and came across a problem
with it. It works fine with the example we have been using, but only
because none of the calls has more than one *non-overlapping* call start
Damn this lag!!
I see Andrey has already posted a note saying thanks and yet my emails are
just filtering through to the list now...my apologies for taking up the
bandwidth!!!
Kev
(off to prime the Carrier Pidgeon which seems quicker than email!)
-Original Message-
Sent: 15 August
Yes, and this morning my manager just asked me for something similar
too. How fortunate :0)
g
-Original Message-
Sent: Wednesday, August 15, 2001 7:26 PM
To: Multiple recipients of list ORACLE-L
Hi All:
There's one really neat thing about this thread...it's helped me solve
an
Hi Roland,
look at the execution plan of your subselect. Start sqlplus then
set autotrace on;
SELECT PBK.VARUKORGEANREL.varukorgid, rik2.vare.ean_nr, 'rsm' ,
PBK.VARUKORGEANREL.lagstapris, 0, rik2.vare.varenavn,
rik2.vare.str,
rik2.lev.navn, rik2.vare.hylletxt2,
Hi Roland,
I would suggest that it pretty much depends on the number of rows that are
being returned from your select statement as well as the way the select
statement has been put together.
Try cutting the select statement from the insert and running it against an
explain plan to determine
Hi David !
It's perfectly fine : four calls started during the period of the first call
, but the maximum of 2 were carried out simultaneously .
Your PL/SQL block addresses this , since U subtract 1 from the current
number of concurrent calls each time the second person hangs up. So , the
Dear gurus !
Is there a way to know the time of insert/update for each row in a table ?
Or , which rows in a table were inserted/updated since a certain time.
( Sort of find ... -mtime ... for UNIX files) .
I CAN NOT modify the structure of the table , i.e. i CAN NOT add a
timestamp or other
Hi,
it must be doing full table scan.check your column positions of the
indexes in table user_ind_columns and change your where condition according
to the column positions.
rukmini
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August
All make does is track dependencies on things. The general format of an
entry in a makefile is:
label: dependent on
actions to execute
So if you wanted to make label, then you would first have to have made
dependent on. Once you gave it, you can then execute actions to
execute.
the answer is it depends. since you can't modify the table, why not
put a trigger to put a last updated, etc time into another table.
joe
Andrey Bronfin wrote:
Dear gurus !
Is there a way to know the time of insert/update for each row in a table ?
Or , which rows in a table were
Hi Aviv !
Thanks for your reply !
Yes , i thought of this snapshot log option .
2 problems :
1) performance overhead - for each DML on my table , i have a DML on the
MLOG$_ (snapshot log) table , carried out by a trigger.
2) For each access to the rows in my original table , i need to join with
If you can't modify the structure to add a timestamp column or add a
trigger to insert a timestamp into another table, there's no way I know
of to track it. Oracle doesn't track this sort of thing on its own; you
need some sort of timestamp field.
Jon Walthour
-Original Message-
Bronfin
It simply uses RBO instead.
g
-Original Message-
Sent: Thursday, August 16, 2001 9:46 AM
To: Multiple recipients of list ORACLE-L
Hi list,
a quick question about oracle optimizer.
a customer has database migrated from 7.3.4 to 8.1.6 on AIX. Data was
transfered via full exp/imp.
Create a trigger on insert/update of zour table and let the trigger write
tuple in other table with datetime of modification of ROWID of your table.
Jan Pruner
Dne èt 16. srpen 2001 13:15 jste napsal(a):
Dear gurus !
Is there a way to know the time of insert/update for each row in a table ?
Volker:
If optimizer_mode = 'choose', then the optimizer chooses between
cost-based optimization and rule-based optimization based on whether or
not statistics are present. In your case, since they aren't it's using
rule-based.
-Original Message-
Volker
Sent: Thursday, August 16, 2001
My perception of intelligent people is that they know a lot of trivia, can
repeat many theories, and can talk a lot when you ask them regarding
something on which they collected many associations.
Intelligent people don't make fortunes all that often, because theories and
knowledge do not
Relinking only requires 'make' and 'ld'. The components which make up the
Oracle binaries are provided as compiled object code, so no C compiler is
necessary for relinking.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 16, 2001
Sounds like in the U.S. you have the same tax-shelter...
Find yourself a horse-breeding farm that makes profit only 2 years out of 7,
hopefully it will make multi-million losses 5 years out of 7.
; )
I wish they would get rid of all these loopholes.
Patrice Boivin
Systems Analyst (Oracle
Do we have the concept of deferred CHECK constraints?
For a constraint of this nature, I don't Oracle to check the whole table as
I
have done the fixes to ensure there is no occurrence of invalid condition.
I only want the future ones to be checked.
ALTER TABLE KB.table
ADD CONSTRAINT
If the objects in a query have not been analyze, then rule mode is
defaulted.
If there are objects in the database which are analyze, yet the tables you
are using are not analyzed, rule mode will still be used.
If one table is analyzed, and it is joined with 5 others which are not
analyzed,
Rahul,
I installed different versions of Oracle (804,816,817) on Sun boxes without
c compiler. Oracle installation went through.
By this, I could say that on Sun Solaris machines we do not require c
compiler for Oracle installation.
Perhaps, on HP boxes the story might be the same or
Zsolt,
The correct call for the function if the function exists within the package
would be:
Insert into A
( Select Col1 ,PackageName.MyFunction(Col1)
from B );
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, August 15, 2001 6:44 PM
Well whoever you are talking to probably is vaugely familiar with java.
Java's execution speed is fairly close but not quite to C++.
Although there is a large delay in the initial interperation as well as
graphical interfaces. Java also uses more resources.
So basically, on a client
Alex,
It's tough to guess how long an import will take. It all depends on how
many indexes and constraints you have - these are what take the most time at
import time. The data gets sucked in real fast. Using Direct Load really
speeds the import up but, again, rebuilding the indexes takes
Hello!
I'm using Oracle Portal (3.0.6) and there (creating reports) you can select max. 3
break columns, but I need 5 or so. So far I've found that SQL*Plus have similarly
acting command break on column_name. So I tried to find where or/and how Portal
calls those commands but haven't found
One interesting note to this.
When I was benchmarking my quicksite application, which is completely java
jdbc.
Using this query:
select 100 - (sum(getmisses) / sum(gets) * 100)
from sys.v_$rowcache;
I was able to get 786.3 queries in per second against the database.
10,000 in 12.8
I am NOT the guy who beats up calculators. I might slip stick them a bit.
Interesting concept. Almost like the NorthStar from american car monitoring and
trying to control what you do.
ROR mô¿ôm
[EMAIL PROTECTED] 08/15/01 06:43PM
Well, if the subject didn't cause you to delete this message
There is no application, just wondering. I'm a ASP/ColdFusion developer atm,
and have been wondering for some time if Java was worth learning, and it
appears now, based on your answers, it might just be worth it.
Thanks Guy.
anybody else have any input on this topic ?
cheers,
michael
someones gloating :)
thanks again chris.
-Original Message-
[mailto:X]
Sent: Thursday, 16 August 2001 11:23 PM
To: X
One interesting note to this.
When I was benchmarking my quicksite application, which is completely java
jdbc.
Using this
DOH!
mixing up my tools again!
thanks Joe!
"Last i checked there was no direct=y
on imp only on exp (ok and sqlldr) :)"
Tom Mercadante Oracle Certified
Professional
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 8:48
AMTo:
Use UTL_FILE to read your .sql file, and then execute your sql-statements
using dynamic sql (DBMS_SQL or 'EXECUTE IMMEDIATE').
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
On Thu, Aug 16, 2001 at 02:15:55AM -0800, Guy Hammond wrote:
I have another CLOB question, what is the best way to do a
search-and-replace?
Something like a c/oldvalue/newvvalue/ on the SQL*Plus command line, or
$variable =~ s/oldvalue/newvalue/; in Perl.
The only thing I can think of
Thanks Chris, your input is appreciated.
Can anybody recommend any good java programming books, specficially
something designed at working with Oracle 8i ?
Thanks,
Michael.
-Original Message-
[mailto:X]
Sent: Thursday, 16 August 2001 11:18 PM
To:
I may be starting a project in the near future to
migrate an IMS database to 8.1.? on Windows 2000. I
would like to know if Oracle provides a tool to do
this? Data profiling, mapping, etc.? I could not find
anything for IMS on OTN or the Oracle site. I know
there are some non-Oracle
Okay, can you add a trigger?
At a prior job, management wanted us not only to track last update/insert
but WHAT was done.
so I created a second table, duplicate of the first with addition fields of
trans_date,user and action
then I added a trigger (insert/update/delete) on the original
Not at all,
Just showing that java is not in fact slow, especially when it comes to
database drives. JDBC drivers are quite fast.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R.
Last i checked there was no direct=y on imp only on exp (ok and sqlldr)
:)
joe
[EMAIL PROTECTED] 08/16/01 09:18AM
Alex,It's tough to guess how long an import will
take. It all depends on howmany indexes and constraints you have -
these are what take the most time atimport time. The data
Jared,
I would have liked to have been the room when the speech was given, to hear
the reactions to the inside references. Pretty clever!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, August 16, 2001 9:35 AM
To: Multiple recipients of list ORACLE-L
Hint: There may be a good java book coming out in december.
Just a guess.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707)
Well, I'd have to recommend Professional Oracle 8i Application
Programming 'cos I wrote some of it :0)
If you're completely new to Java, there are tutorials available for free
on http://java.sun.com/ - learn the language first, then maybe start on
JDBC (which is very simple) and then advanced
If you're interested in a great opportunity, then consider this position in
Clifton, New Jersey that needs an Oracle/SAP DBA to join its' I.T. staff.
This is a full time staff position so no sub-contractors or third parties
please.
Please do not call or send a resume if you are not in the U.S.
Rahul,
All UNIX OS's come with a rudimentary C compiler and linker, mainly for the
purpose of rebuilding the kernel. What Oracle needs is the make utility and the
linker. The compiler is only needed if your building a program from source code
and since Oracle ships object code it needs to
** Egghead Files For Chapter 11
Egghead.com Inc. has filed for Chapter 11 bankruptcy protection
and laid off 200 employees. The online computer and electronics
retailer was felled by weak consumer computer sales and wary Wall
Street investors. The Menlo Park, Calif., retailer will sell its
Hi list,
Does anyone have the word on when Oracle plans to discontinue support
for Oracle 8.1.6?
Cheers
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL
This Textiles Client in Greensboro, North Carolina needs an Oracle DBA
to join its' I.T. staff. This is a Jr/Mid level position.
* Candidates local to the Greensboro-Burlington area only will be considered.
This is a full time staff position so no sub-contractors or third parties
please.
[EMAIL PROTECTED] wrote:
what's missing!! Is it doing this to embarrass and annoy me or am I just
being paranoid (and if I'm going to be nuts I'd rather be paranoid than a
single-noid).
just because you're paranoid doesn't mean they're not out to get you.;-)
--
Bill Shrek Thater
Statistics can in fact hurt. If your queries are tuned for rule based
optimizer, it is very possible that cost base will perform suboptimal,
perhaps a little, perhaps a lot. You may need to tune the database to be
more efficient for CBO by changing parameters.
Although adding statistics and
-Mensaje original-De: Ramon Estevez
[mailto:[EMAIL PROTECTED]]Enviado el: Thursday, 16
August, 2001 9:23 AMPara: '[EMAIL PROTECTED]'Asunto:
RE: Lost of all Control Files
Friends
Thanks to
all of you helped me with the problem. The create controlfile worked fine,
why bother sending these things to the list, when there are SO MANY
RESTRICTIONS, its a waste of bandwidth more than anything else.
NO aliens(foreigners or the outer space kind), NO one unless you live
there, NO subcontractors, NO one with green eyes, NO one who has ever known
anyone who
They did already, they just still take phone calls.
Oracle drops support the day the release the product. ;)
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone:
Imports/exports only use about 1/10 of your available sustained io
generally. Although direct exports are noticably faster and less stress on
the database.
Locking, rollback generation, constraints, triggers can affect the
performance of the import/export process as well. Also network io if it
One good reason for this is:
What happens if it did put from there?
Now your going to write scripts, make that same mistake, the database is
going to fix it for you.
Your going to port/share your scripts, and someone else's database won't be
so helpful, they are not going to want to dig
Hi list,
I want to change col-types in one table. I have table T1 with two columns
COL1 LONG and COL2 VARCHAR2(2000). Now I want to change the col-types vice
versa, that means COL1 should be VARCHAR2(2000) and COL2 should be LONG. I
have a lot of data in that cols, but all data is smaller than
Very dangerous. Like, Captain Kirk might say, Mr. Spock, cancel the
self destruct sequence so Mr. Spock goes to his SQL*Plus terminal and
types:
SQL ALTER STARSHIP SET AUTODESTRUCT
But at that moment, Dr McCoy walks in, slips in a puddle of Romulan Ale
and grabs Mr. Spock for support, whose
Oracle
Support ServicesProduct Obsolescence andDesupport NoticeOctober
2000Product / Platform: Oracle8i, Release 2 (8.1.6) Error
Correction Support ends on: 31 October 2001Extended Assistance Support ends
on: 31 October 2004 Product Obsolescence / Desupport
Summary:Oracle Corporation
-This Textiles Client in Greensboro,
North Carolina needs an Oracle DBA
Working for a textiles client in the US
sounds like good job security!! Maybe the next job they have will be for a
steel mill client in Bethlehem PA. ;-)
Dave
-Original Message-From: JOE TESTA
Title: Message
Why, I think that is good being up front so
you know not to waste time if it doesn't fit you.
Too many jobs don't say anything, you apply
and go through an interview and then they tell you, well we are looking for this
or that.
"Do not criticize someone until you walked a
Doc id: Note:123178.1
Subject:
Oracle8i, Release 2 (8.1.6.) Desupport Notice
Type:
DESUPPORT
Status:
PUBLISHED
Content Type:
TEXT/PLAIN
Title: RE: OT: cryptography speech
Even paranoids have enemies
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying to club someone to death with a loaded Uzi.
- Larry Wall (creator of Perl)
-Original Message-
From:
Title: RE: 8.1.6 support cut off?
According to docs I saw on metalink about 6 months ago
Error Correction support ends Oct 31, 2001,
Extended support ends Oct 31, 2004
Matt Adams - GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying to club
"I just paid my
price."
We all
feel your pain.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Ramon Estevez
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16,
2001 11:23 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Lost of all Control
Imports/exports only use about 1/10 of your available sustained io
generally. Although direct exports are noticably faster and less stress on
the database.
And why do we need to read this?
Locking, rollback generation, constraints, triggers can affect the
performance of the import/export
IMS is a hierarchical database, not relational. It is also quite old
technology. I doubt Oracle will have any conversion tools for that. I
started my career working with IMS DB/DC in the late 70's. You will really
need to design a new database from scratch and then convert and import data.
I
The desupport notice states 10/31/2001, with extended support until
10/31/2004. It's on metallink. If you are an Oracle Applications customer,
then support is extended until 3/1/2002.
Mark Leith wrote:
Hi list,
Does anyone have the word on when Oracle plans to discontinue support
for
Cheers Joe!
Mark
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent:
Thursday, August 16, 2001 16:16To: Multiple recipients of list
ORACLE-LSubject: Re: 8.1.6 support cut
off?Oracle Support ServicesProduct Obsolescence
Title: RE: OT: cryptography speech
Think
yourselves lucky, we're paranoid schizophrenics.
They
are all out to get us !!
-Original Message-From: Adams, Matthew (GEA, 088130)
[mailto:[EMAIL PROTECTED]]Sent: 16 August 2001
16:36To: Multiple recipients of list ORACLE-LSubject:
-Original Message-
From: Christopher Spence [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 1:16 AM
To: Multiple recipients of list ORACLE-L
Subject: Comment on 'Practical Oracle 8i'
Well, I just got this book, and just started reading through it.
Looks good so
I agree with Joe.
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001
11:23 AMTo: Multiple recipients of list ORACLE-LSubject:
OT Slam for the day: Re: Oracle DBA Needed in Greensboro,
why bother sending these things to the list,
Dear gurus !
A customer wants to have a backup database on a remote in case of disaster
site.
That database needs to be as much in sync with the primary DB as possible,
and a sort of failover must be implemented ,
i.e. if the primary site fails , the users will be AUTOMATICALLY routed to
the
analyze the select statement that extracts the rows to be inserted.
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date: 8/16/2001 1:45 AM
Hallo you DBA's
Can anyonetell me why this insert statement takes 30-40 minutes to run?
What can I
But there's
an opportunity to become a key member of the team! Surely you wouldn't pass that
up? *snicker*
g
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 4:23
PMTo: Multiple recipients of list ORACLE-LSubject: OT
Slam for
I do not think that the Oracle Migration Workbench does, but here is something that
might be useful.
http://otn.oracle.com/tech/migration/mti/listing.htm
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 9:48 AM
To: Multiple
Title: RE: OT: cryptography speech
paranoid schizophrenics with multiple personalities think they are out to
get themselves.
:-)
-Original Message-From: Robertson Lee - lerobe
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 12:11
PMTo: Multiple recipients of list
Neither!
It simply does not exist.
There IS no number right next to zero.
Amazing stuff.
-Original Message-
Sent: Wednesday, August 15, 2001 10:26 AM
To: Multiple recipients of list ORACLE-L
So, would that be irrational or imaginary?
BTW - I once made a mistake on a
Title: RE: Speed up Truncate tables - rebuild index
Actually Chris if you truncate a table, the indexes on the table are truncated right along with it. You don't end up with a sparse index, like when you delete many rows. Try it. I did (8.1.6) and was very happy to see this behavior.
Lisa
Hi Listers,
I repost here again.
Here is our install log.
Calling query areasQueries1.7.1.6.0 getProductHome
name = oracle.swd.jre
startVersion = 1.0
endVersion = 1.2
acceptCompatible = null
Query returned : /u01/app/oracle/jre/1.1.8
Does anyone know how the jre home set to this
Imports/exports only use about 1/10 of your available sustained io
generally. Although direct exports are noticably faster and less stress on
the database.
And why do we need to read this?
Use the delete key, personally you can read what you like, judging
by some of the posts, it is
Hi All,
I did a typical installation of Oracle 8.1.7 on Win 2k. It appears to have
installed Ok. I can use srvmgrl - create database - etc.
However when I try to use worksheet I get no listner. I should not need one
from the server. Anyway the install did not create service
to start the
Hi DBAs,
I have ready many conflicting notes on MetaLink whether or not a SYSTEM
tablespace can be locally managed. Most
of the article state definitely not in 8.1.6 and less. While others say Yes
and No in 8.1.7
Anyone know for sure thru actual use.
Thanks
Rick
--
Please see the official
Title: RE: Speed up Truncate tables - rebuild index
Lisa,
I think Chris referred to 'alter table ... move',
in which case you need to rebuild indexes (ROWIDs
changed).
Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED]
- Original Message -
From:
Koivu, Lisa
Hi Ravindra,
I guess you can set"log_archive_dest_n" parameter dynamically by using "alter system" ,at least in 8.1.6.
Also, you need to add it also in the init.ora not to loose the parameter value in case of a restart.
HTH,
Jyoti
From: "Ravindra Basavaraja" <[EMAIL PROTECTED]>
Reply-To:
Hi All,
I am having great difficulty in getting Oracle 8.1.7 installed on Win 2k. I
have completely removed Oracle, i.e., directory,registry entries,
program groups and services. When I try to re-install it again Installer
says 167 products installed when in fact there are none. Where
is
Standby... even if I have to be paged in the middle of the night to bring it
up and live.
replication is a nightmare to implement unless you plan for it. Standby is a
breeze to implement and maintain.
From: Andrey Bronfin [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients
Since you are likely to get conflicting answers
from the list, how are you going to decide ?
At present there is no syntax line in CREATE DATABASE
for making the system tablespace locally managed,
which is a hint.
The other hint is that the Oracle 9 Concepts manual
(Ch 4 page 10) states
it can't
From: Cale, Rick T (Richard) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Can a SYSTEM tablespace be locally managed.
Date: Thu, 16 Aug 2001 08:28:22 -0800
Hi DBAs,
I have ready many conflicting notes on MetaLink
Hi there , We have UTF-8 database. We are using
OAS with UTF-8 setting and java at front end connects to OAS socket to send data
to be inserted into oracle .Is it required to convert data send by Java to be
converted to UTF8 ? OAS (OAS NLS_LANG=AMERICAN_AMERICA.UTF8)When we
send some
I don't know how bookpool does it - it's been
at deep discounts since publication, whereas
Amazon managed to cut it by 10% for about
two weeks in 9 months.
A comment like yours came up on the
comp.databases.oracle.server newsgroup
very soon after the book came out. The
convenient weasel word is
Thanks to you and Kevin!
You'd think I'd have noticed this behavior sometime before, but obviously
not.
Hmm, I'm also thinking now about my partioned tables in the datawarehouse,
some of which have a global index on them. After exporting and dropping an
older partition, I assume all that space
Oh my, we were right, they are picking on us, I told you didn't I.
No, I told you
No you didn't.
Use the delete key, personally you can read what you like, judging
by some of the posts, it is better read than some other posts on paranoid
schizophrenics.
The information
I can't actually get to metastink - so I thought I would ask you guys that
can :)
oO(Don't know whether not being able to get at it really hurts me anyway
:) )
Cheers anyway
Mark
-Original Message-
Canaan
Sent: Thursday, August 16, 2001 16:43
To: Multiple recipients of list ORACLE-L
Title: RE: Speed up Truncate tables - rebuild index
Ahhh... Thank you. Pre-coffee over here.
LK
-Original Message-
From: Igor Neyman [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 12:58 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Speed up Truncate tables -
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k
Hi Rick,
I ran into this as well. I figured I didn't need a listener on my w2k box because everything was going to be local. However I couldn't connect via sqlplus gui without a listener (no listener error - maybe because I am
Exactly ;)
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
Before I reply, so far at page 100 I think the book is great.
I plan on finishing it this weekend.
Anyway, I agree entirely. I think it really depends.
But there are strong reasons in both directions.
One thing that would make that test very difficult is MHz to MHz isn't the
same.
For
Didja look in 'Program Files'? On my system (8.1.6) there's an Oracle
directory with 'Inventory' underneath that.
HTH,
Mike
---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304
-Original
1 - 100 of 212 matches
Mail list logo