Hello Sami,
Check the environment variables.. such as ORACLE_HOME, LD_LIBRARY_PATH, and just PATH.. Are they set .. when you execute from CRON ? You will have them when you execute from unix login.
Hope this helps.
Nikunj
From: Oracle DBA <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To:
You would require something like this:
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:504432994857
HTH
GovindanK
Hello Listers,
I need some SQL help.
Not sure if this is possible in plain SQL or not, but here it is:
I have a table with two columns:
EMPNBR LINENBR
We need to extract
the data of a datafile directly, because we don´t have
the rest of the
database (other tablespaces, controlfile, etc).
Are there some
utility like DUL ?
What about Unicenter
Fast Unload ?. Works it with the datafile directly ?
Does it need the
database open ?
thanks
I was thinking along the same lines minus the outer query which is totally
unnecessary, but it is the beginning of my day here :-).
SF
- --- Original Message --- -
From: Wolfgang Breitling [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue,
Title: RE: Nosort parallel dml uses TEMP tablespace
I'm even more confused now.
TEMP ran out of space at 20GB - I'm only inserting 12.2GB!
So I kicked it off again with the hint just as /*+ APPEND */ and it completed successfully in 1/6th the time to failure of the parallel insert.
- --- Original Message --- -
From: Mark Richard [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Tue, 16 Sep 2003 19:59:41
I guess I should have added some criteria like:
1) user_objects must have enough rows in it to
cover the range (if not
create viex xdual
as select rownum ID
from sys.col$;
Cannot have a column named rownum ... Going to be a difficult day. And we are only
half-week.
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: [EMAIL
Lies, all lies. I've heard myself snoring.
Pete Sharman wrote:
I can guarantee that won't happen, since Cary's singing is pretty much akin
to Mogens's snoring! :)
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not. It's much harder than that!
So have I and to me it sounded pretty much like The hills are alive
with the sound of music which is pretty much what I imagine Cary likes
to sing.
Gudmundur
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Mogens Nørgaard
Sent: 17. september 2003
Hi Stephane,
I commiserate with you 8-)
Regards,
Guido
[EMAIL PROTECTED] 17.09.2003 10.44 Uhr
create viex xdual
as select rownum ID
from sys.col$;
Cannot have a column named rownum ... Going to be a difficult day. And we are only
half-week.
Regards,
Stephane Faroult
Oriole
--
Please
We are working with windows servers and we check the error level after Rman
finish.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 8:39 AM
Posted on behalf of Rich Holland ([EMAIL PROTECTED]):
Thanks for the input Praveen, if only it were that easy.
The sql is a straight insert into tab1 select * from tab2 but with a parallel dml
hint. Remove the parallel and it doesnt use TEMP. Theres no distinct, group by, order
by or indexes on the target table (there are 12 or so on the source
Vrey off tpoic but vrey insreettnig .
In article [EMAIL PROTECTED], Sinardy Xing
[EMAIL PROTECTED] writes
Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn't
mttaer
in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng
is
taht frist and lsat
Hi,
There is a tool called jDul on sourceforge but it wasn't available for
download last time I looked, you might want to take a look again and see
if it is now?
hth
kind regards
Pete
--
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit
Title: RE: SQLPLUS with cronjob is giving problem
Dear Sami,
As a matter of fact whatever environ. values are set in your .profile are not in operation through a crontab process.
To deal with this issue we do something that I have seen others do as well. We basically create a
that must bve cause usually i type that bad and can read it nayways
joe
Sinardy Xing wrote:
Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn't
mttaer
in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng
is
taht frist and lsat ltteer is at the rghit pclae. The rset
Title: RE: Checking RMAN backup results
Alghough I use the RMAN catalog and so backup success/failure can be seen from there. I find it easiest to write out a log of the entire backup process in my calling script to a specific directory
/dblogs/backups
All my backup scripts are written
Hi!
This one is a very interesting consideration. The use of 'pivot' tables,
as in this case, without being something you meet daily is fairly frequent
(completing series like here is one usage, otherwise I commonly use them to
generate test data). It should be some standard feature, a kind of
Title: RE: Nosort parallel dml uses TEMP tablespace
Hi!
It could be that parallel slaves are passing
intermediate results using TEMP tablespace for some reason. (When table queues
are full in some cases or smth like that). It can depend on parallel execution
plan as well (whether it's
Thanks Dick.
I like that last quote in the article...
Patrice.
-Original Message-
Sent: Tuesday, September 16, 2003 5:50 PM
To: Multiple recipients of list ORACLE-L
Patrice,
ANALYSTS: PER-PROCESSOR PRICING TO DIE OUT | SearchOracle.com
As Oracle Corp. prepares to release new
Jp,
No idea as never used. Pretty much happy with STS so far.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 16 Sep 2003 21:09:44 -0800
Rafiq, How about Boson Practice tests compared to STS ?
has anyone on this list found Boson
Title: RE: Nosort parallel dml uses TEMP tablespace
Hi!
Btw, I did a little testing with PARALLEL 2, and
yes it seems to be a parallel slave communications issue, despite the segments
show type "SORT".
When i traced sorting with 10032 10033, I saw
sort segment allocation, but no real
Title: RE: Nosort parallel dml uses TEMP tablespace
Thanks
for having a look Tanel; that makes great sense.
I'll
have a quick play to convince myself but I'd say its a lesson
learned.
BTW
did you too experience more temp allocation than you would have
expected?
Thanks
again,
Adrian
Hello All,
Thanks for your wonderful ideas.
I just forwarded those to my dear Developer (my wife, that is :)
After posting my question to the list last night, I was told that the query will be
run against
an Informix database :)
Typical Developers !!! ;)
Cheers!
- Kirti
---
Dear Friends,
Good day. Hope doing well , sorry for OFF topic.
My Friend has got an offer with Oracle India at Hyderabad (as a support engineer in Indian support centre , Hyderabad, India ).
I need your suggestions , inputs and valuable thoughts for making a decision. What will be the work
It looks like you don't have your ORACLE_SID specified correctly since, if I
read this correctly, the database you are trying to restore is on dick c:.
Set you ORACLE_SID which will be the target and try again.
HTH,
Ruth
p.s I do not have any databases on Windows so I am not sure how to set the
Erm... would "42" be a sufficient
answer?
Tanel.
- Original Message -
From:
Ora DBA
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, September 17, 2003 4:44
PM
Subject: +++Need an urgent info+++
Dear Friends,
Good day. Hope doing well ,
i think, you have problem permission.
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 5:25 PM
To: Multiple recipients of list ORACLE-L
While exporting synonyms , export hangs.
Help ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Title: RE: Nosort parallel dml uses TEMP tablespace
You're welcome, please let me know the
results.
It was news to me as well, that so much temp space
would be used in your type of parallel direct load insert...
Btw, you can use nologging hint as well in your DML
if you haven't already
Rich,
I parse the Rman output using Perl and look for RMAN-00569 in the output
file. If I find it, then I send email to myself with a subject line
indicating that the backup failed.
Pretty simple. And it's been working well for a few years now.
The Perl script is available free. Just email
Find out what are the job responsibilities of a Support Engineer.
If your friend needs a job badly, and if the salary is acceptable, this could be a
good opp to
learn on the job while helping the Customers.
Hyderabad is an interesting but a crowded city (no surprise there, it's India :) with
a
Ruth,
Set you ORACLE_SID which will be the target and try again.
c: set ORACLE_SID=AUX92
AUX92 is the name of my auxiliary instance on Host A ( target host ).
c: rman target [EMAIL PROTECTED] catalog [EMAIL PROTECTED] auxiliary sys
trace=c:\tspitr.log
where PE92 is the target on same Host A
Melanie
The story I got from an Oracle instructor was that somebody was bragging
about how they passed the OCP without ever logging into Oracle. I guess this
caused some consternation in Redwood Shores. The quickest fix was to require
everyone to take one class. When I asked the instructor if
For what I have heard, Bangalore is a more pleasant place than Hyderabad :-). I
personally know neither, but somebody on this list worked for Oracle India in
Hyderabad, he might tell you more about this ...
SF
PS : Please don't have this tragical vision of life (importance of decision etc).
Title: Message
Wow! I was atcaully albe to
raed taht amolst as fsat as nroaml. I have new funod aprpceaitoin for waht my
brian deos for me.
-Original Message-From: Sinardy Xing
[mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16,
2003 9:50 PMTo: Multiple recipients of
Has anyone had all objects in a schema return ORA-08103 on any select,
describe or analyze?
I have an instance on Oracle 9.2.0.1.0 on Solaris 5.8 64-bit. With no
apparent change, all access to objects in this schema returns ORA-08103. I
bounced the instance. I dropped and rebuilt the instance,
Hi All,
I am facing one problem explained below:
Our application is using a trigger on view a based on some table b.
IF :new.IND = 'Y' THEN
UPDATE b set
IND = NVL(RTRIM(:new.DIND),' ')
WHERE ROWID = :old.OROWID;
...58 minutes if I've calculated correctly. And yes, you're right: if
you have 50 sessions and 49 are waiting for 1 minute each, then you have
49 minutes of waiting. Any system has an infinite capacity for waiting.
In case you pick up the book Optimizing Oracle Performance, this
phenomenon (what
Title: Is Cary's new book shipping now?
Toms book, by the way, is
spectacular.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic101
in Sydney
- Hotsos Symposium 2004
March 710 Dallas
- Visit www.hotsos.com for schedule
details...
Title: RE: invalid ROWID
use PK ... rowid is not reliable in views ...
-Original Message-
From: ManojKr Jha [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 17, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject: invalid ROWID
Hi All,
I am facing one problem
Dennis,
Thank you for this.
BTW, I like your signature. :-) I think it sums up quite a number of
us.
Best regards,
Melanie
-Original Message-
DENNIS WILLIAMS
Sent: Wednesday, September 17, 2003 10:45 AM
To: Multiple recipients of list ORACLE-L
Melanie
The story I got from an
Is this OROWID a column in your table or is it just a typo?
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 5:59 PM
Hi All,
I am facing one problem explained below:
Our application is using a trigger on
you dont need to hawk your book... of course ill buy it. yeah. i think im screwed. I
dont have mount points to multi-plex my redo logs. :(
From: Cary Millsap [EMAIL PROTECTED]
Date: 2003/09/17 Wed AM 11:09:50 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: wait
i have a table with 27 million records that is about 1.2 GB in size. I have a 'staging
table' with 18 million records. 16 million records have a 'delete' flag. I have
indexed the column in staging with a delete flag. both tables have indexed primary
keys. Is the following my fastest option or
Dennis,
Yes. Sometimes, Oracle doesn't want to do some additional work.
Although I can't understand how the backup controlfile is different from
the active controlfile
in that manner.
The last Support Analyst's response was
... the backup binary control file does not store information about
How is backup controlfile different? It doesn't contain the last SCN.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Hemant K Chitale
Sent: Wednesday, September 17, 2003 11:45 AM
To: Multiple recipients of list
Unfortunately, users do not have infinite capacity for waiting, at least not
my users.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Cary Millsap
Sent: Wednesday, September 17, 2003 11:10 AM
To: Multiple recipients
You could use LAST_SEC (from dba_jobs)
specification for broken job, which is time portion
of LAST_DATE, when you calculate NEXT_DATE for dbms_job.broken.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
OROWID is column of view a based on table b.
With Regards,
Manoj Kumar Jha
A transcendentalist engaged in auspicious activities does not meet with
destruction either in this world or in the
We have SUN ultra Sparc server with two Gigabit
Ethernet cards on
it. Those two Ethernet card will connect to big
IP (firewall/router). The reason we need two Gigabit
Ethernet cards is
securiyt (in case one card fail). I know I can
configure
two listener entries on listener.ora like:
Try anti hash join.
-Original Message-
Sent: Wednesday, September 17, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
i have a table with 27 million records that is about 1.2 GB in size. I have a 'staging
table' with 18 million records. 16 million records have a 'delete' flag. I
IA,
The following code should be close to what you want
select replace(replace(replace(a,chr(13),'R'),chr(10),'')) from table
John
-Original Message-
Sent: 16 September 2003 16:15
To: Multiple recipients of list ORACLE-L
Hi,
I have a column with carriage returns (chr(13) ) and line
If OROWID is a column, the
WHERE ROWID = :old.OROWID; would certainly fail.
If OROWID is expected to be of type ROWID, check the View definition.
Are you really getting the right rowid ?
Hemant
At 07:59 AM 17-09-03 -0800, you wrote:
OROWID is column of view a based on table b.
With Regards,
Hi list,
Recalling the yesterday problem, here is my profile, what arrangement
should I do
To make RMAN work from the ORACLE_HOME/bin without to specify the path.
Kind of new in UNIX/LINUX.
TIA,
export EDITOR=vi
export TERM=xterm
#*
# Variables de Oracle |
Looks like you've got one too many REPLACEs.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Hallas, John, Tech Dev
Sent: Wednesday, September 17, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
IA,
The following code should be close to what you want
select
i explain planned it and it was much worse than not exists.
my understanding is hash_aj is faster when the table in the sub-query returns results
that are significantly less than the one in the outer table.
ill try it, but i think exists is faster. we dont want to do an index scan here and my
Yes, you are correct Igor.
It was taken from an example I had which did 3 replaces.
I did manage to substitute the 13 and 10 correctly though
select replace(replace(a,chr(13),'R'),chr(10),'') from table
John
-Original Message-
Sent: 17 September 2003 17:20
To: Multiple recipients of
Ryan - One solution that is often suggested would be to copy the rows you
wish to retain to another table, then truncate the table. Oracle is
relatively slow at deletes compared to inserts. Would this method work for
you?
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
you ALWAYS want to use the path, you dont want to use a different
version of binary for rman that does NOT correspond to the database
you're backing up.
joe
Ramon E. Estevez wrote:
Hi list,
Recalling the yesterday problem, here is my profile, what arrangement
should I do
To make RMAN work
When tuning queries, ignore the fact that explain plan shows a cost. The
optimizer finds the lowest cost it can. If you mess with hints you will
almost certainly get a higher cost. I've tuned queries that ran for hours
with a cost of less than 10 -- the tuned versions had costs in the
How abuout:
create table ani_prx_new parallel (degree 5) nologging
as
( select * from ani_prx
minus
select * from from bo_owner.ani_prx
where ba_recode='V')
/
I assume that the description of the bo_owner.ani_prx is identical
to the description of the ani_prx. Furthermore, a bitmap index
Syntactically incorrect (one 'replace' too much). IMHO translate() is the one to use
here. Probably a negligible performance benefit but I find a single function call
easier to read than a function taking another function call as argument. The fewer
characters the better (I type slowly and
Roy,
NOT EXISTS is to be avoided when it is the only criterion - the subquery is
executed for each row in the outer query. The way the CBO behaves varies wildly
between 8.1.7 and 9.x. Richard's suggestion is quite correct and a fairly safe way to
get a 'right' behaviour with most versions
i tested the minus in the explain plan and the estimate was very large. dont i need a
large sort_area_size for that?
bitmap index on all columns right? not just one?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/17 Wed PM 12:59:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
16 million of the 18 million records in the staging table have delete records. how
would indexing help there? wouldnt a full table scan be better?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/17 Wed PM 12:59:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Why oh why did I not wait? I tracked down and purchased Tom's previous
Expert One-on-One Oracle a couple months ago. I even checked to make sure
a new edition was not forthcoming. *sigh* Did not check enough I guess.
I'll have to compare the two to see if I want to 'upgrade'.
I am waiting,
Looks like it's still in the planning stage.
-Original Message-
From: Pete Finnigan [mailto:[EMAIL PROTECTED]
Sent: Wed 9/17/2003 6:59 AM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:Re: How to extract data directly from a datafile ?
Hi,
There is a tool
Have a laff! See Note 240863.1 (esp the first sentence). This seems to have
been around since 11-Jun-2003 (if the Modified date can be believed)
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Kanagaraj
INET: [EMAIL PROTECTED]
Fat City Network Services
But you still need to do a cold copy of the database files, right?
-Original Message-
Sent: 15 September 2003 22:30
To: Multiple recipients of list ORACLE-L
Your belief was wrong.
Actually, the belief was correct for some versions of oracle and some platforms. Case
in point was
Way off topic, but I just have to vent.
I'm working with a guy who really is hot stuff when it comes to project
management. He's so good that they brought him in as an outside consultant
to manage a priority project that touches on national security. He knows
all about the mythical man-month
Just proves, what's TEST today is Production tomorrow.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Wednesday, September 17, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L
Have a laff! See Note 240863.1 (esp the first sentence). This seems to
Tom has a NEW, different book out, from Oracle Press. That is the one
Cary is referring to. Which means you'll have to buy a new book.
As for Cary's book, I have it on order at Amazon as well, but according
to the site today, it's still not released. :(
--- Dwayne Cox [EMAIL PROTECTED] wrote:
Well, large sort area size would certainly help, as well as the parallel
hints.
As for the bitmap index, I din't know what was the percentage. It probably
wouldn't
help much.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
So, now we're less secure? And the hurricane Isabel is coming fast.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Thomas Day
Sent: Wednesday, September 17, 2003 2:00 PM
To: Multiple recipients of list ORACLE-L
Or that the developers test in production!
-Original Message-
From: Goulet, Dick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 2:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: 'Test' Note on Metalink...
Just proves, what's TEST today is Production
Hi List,
Does OCP emembers get any discount on Tom's Effective
Oracle by Design (Osborne ORACLE Press Series), since
it is coming from Oracle Press.
Any idea?
TIA
Sami
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
Tom has a NEW, different book out, from Oracle
Press. That is the one
Cary is
I wonder how long it's going to stay in Metalink now...
: )
Patrice.
-Original Message-
Sent: Wednesday, September 17, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L
Have a laff! See Note 240863.1 (esp the first sentence). This seems to have
been around since 11-Jun-2003 (if
I got my note from Bookpool last night, that my copy, that I pre-ordered a
couple of weeks ago, has been shipped. Now, it remains to be seen if I can
get the time to read it.
-Original Message-
Tom has a NEW, different book out, from Oracle Press. That is the one
Cary is referring
OK, call me senile, but I've been following this thread for so long I can't remember
the titles for
Cary's and Tom's books. Anyone wanna lend a hand with the ISBN number or title?
Thanks,
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. --
Mine shipped from Bookpool yesterday... It's currently listed as In Stock
there if you're in a hurry...
http://www.bookpool.com/.x/t9mrg8o9b1/ss/1?qs=059600527X
Tim
-Original Message-
Sent: Wednesday, September 17, 2003 2:15 PM
To: Multiple recipients of list ORACLE-L
Tom has a NEW,
Hi:
I did RTFM, but I could not find any answer.
I created two TEMPORARY Tablespaces (see below) and I moved all users to
TEMP. Now I want to drop TEMPLMT. When I tried alter tablespace TEMPLMT
offline; I got
alter tablespace TEMPLMT offline
*
ERROR at line 1:
ORA-03217: invalid option for
I'm not real up on this stuff, but here is an example (I think) of a
tnsnames.ora file. It's possible (not sure) you might have to configure
listener and/or database for the SERVICE_NAME part.
Assuming XYZ1 is the instance name
In local tnsnames.ora, have:
XYZ.world =
I got an email last night from
bookpool that my copy of Cary's
book had shipped.
From: Rachel Carmichael [EMAIL PROTECTED]
Date: 2003/09/17 Wed PM 02:14:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Is Cary's new book shipping now?
Tom has a NEW,
Title: RE: Is Cary's new book shipping now?
Optimizing Oracle Performance
Effective Oracle Design
-Original Message-
From: Ron Thomas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 17, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Is Cary's new book
If you search for Millsap and Kyte on Amazon they should pop right
up.
-Original Message-
Ron Thomas
Sent: Wednesday, September 17, 2003 2:35 PM
To: Multiple recipients of list ORACLE-L
OK, call me senile, but I've been following this thread for so long I
can't remember the titles for
Yes, you are right, I should have looked at ts# = 2. BTW, I tried several
ways to resolve this issue by doing these and none of them worked,
1. alter tablespace temp default storage(pctincrease 0); -- a tip from
Steve Adam's site
2. alter session set events 'immediate trace name
I know you said that this was Informix, but I'll post the article below anyway for the
benefit of other listers.
Oracle Technology Network Oracle Magazine September/October 2002
Turning On Pivot Tables By Jonathan Gennick
http://otn.oracle.com/oramag/oracle/02-sep/o52sql.html
Describes a method
Kirti,
Welcome back after a while. Hope you have finisihed your new book. Banglore
may be a better choice in terms of better salary and level of living. I
think Oracle Corp also hring for Banglore too.
Regards
Rafiq
_
Get 10MB of
I agree with Dennis Williams. Large deletes do have an overhead on indexes. Try this.
- Create table new_table nologging as select * from existing_table where [condition]
OR you may use COPY command in lieu of that
- get the index definitions
- exp grants,constraints,indexes=n ,rows=n for
DROP TABLESPACE TEMPLMT;
I don't think a LM temporary tablespace can be off-lined.
-Original Message-
Sent: Wednesday, September 17, 2003 2:45 PM
To: Multiple recipients of list ORACLE-L
Hi:
I did RTFM, but I could not find any answer.
I created two TEMPORARY Tablespaces (see below)
Title: RE: 'Test' Note on Metalink...
I'm curious as to who has time to search for such an item these days:-)
greg
-Original Message-
From: John Kanagaraj [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 17, 2003 1:50 PM
To: Multiple recipients of list ORACLE-L
Subject:
Oracle Press is not a subsidiary of Oracle but rather of
Osborne/McGraw-Hill
--- Oracle DBA [EMAIL PROTECTED] wrote:
Hi List,
Does OCP emembers get any discount on Tom's Effective
Oracle by Design (Osborne ORACLE Press Series), since
it is coming from Oracle Press.
Any idea?
TIA
Sami
create table ani_prx_faster parallel (degree 5) nologging
as
select b.*
from bo_owner_master.ani_prx b,
bo_owner_stage.ani_prx a
where a.cusip = b.cusip (+)
and a.fund_no = b.fund_no (+)
and a.add_cymd = b.add_cymd (+)
and nvl(b.ba_reccode, 'X')
Title: RE: Is Cary's new book shipping now?
I believe, per one of the other DBAs here, OCPs get like either a 20% or 30% discount on books.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/ \
/ \
\ /
\/
\
\
\
\
Few people really enjoy the simple pleasure of
Allright I am making some changes to some pl/sql code that handles batch
inserts into the database. I am making changes to correct an error where
our clients are sending us data with invalid state information in their
address fields. A constraint prohibits the insert with records with invalid
Never mind, I found the answer. For those who are interested, here is what I
did (tested on dev first, then ran on production against 8173 db).
-- login as sys, ran
select count(*) from dba_segments where TABLESPACE_NAME ='TEMPLMT';
-- got 0 returned, then ran
ALTER DATABASE TEMPFILE
You cant take a temporary lmt temporary tablespace offline, just drop it.
The drop command will wait until there is no needed temp data left.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 9:44 PM
Hi:
I did
Title: RE: Is Cary's new book shipping now?
I
usually get 100% ... company reimburses ... sometimes.
-Original Message-From: April Wells
[mailto:[EMAIL PROTECTED]Sent: Wednesday, September 17, 2003 4:00
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Is Cary's new
Good. And I would add... Test on a regular schedule to see if some yahoo has
altered the server or environment and invalidated your recover procedure.
Brian
-Original Message-
Sent: Tuesday, September 16, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L
LeRoy
One of my bigger
0-596-00527-x Millsap/Holt 2003
0-07-223065-7 Kyte 2003
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101 in Sydney
- Hotsos Symposium 2004, March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Ron Thomas
1 - 100 of 141 matches
Mail list logo