Title: need to compare long data against varchar2
I need to devise a method of comparing the TEXT column of dba_views against varchar2.
End result I want to find the views that reference a particular table within its text.
example (which ~obviously~ will not work):
select view_name
from
)
then
dbms_sql.column_value_long(l_cursor, 1, l_buflen, l_curpos ,
l_long_val, l_long_len );
end if;
dbms_sql.close_cursor(l_cursor);
return l_long_val;
end getlong;
-Original Message-
From: Markham, Richard
Sent: Friday, February 21, 2003 10:20 AM
To: oracle-l ([EMAIL PROTECTED
Title: alert log suppression
Is it possible to suppress successful DDL within the alter log?
For example, I have a cron job that coalesces 300+ tablespaces
which creates a couple line entry for each. I would like to
get feedback only if the DDL has actually failed.
TIA
Title: RE: Sun Solaris
sunhelp.org for general.
sunmanagers.org for critical. requires summary post and is more restrictive.
-Original Message-
From: Ehresmann, David [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 10:59 AM
To: Multiple recipients of list ORACLE-L
PROTECTED]]
Sent: Monday, December 16, 2002 12:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: alert log suppression
The obvious question being why you are coalescing tablespaces
--- Markham, Richard [EMAIL PROTECTED]
wrote: Is it possible to suppress successful DDL
within
]
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 16, 2002 1:00
PM
Subject: RE: alert log
suppression
ok. They are LMT's with PCTINCREASE 0. I'm
running 8.1.7.4 and I believe
and allocation type "USER" for dictionary
managed tablespaces.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list ORACLE-L
Sent: Monday, December 16, 2002 2:09
Title: sqlplus ~no~output
for the sake of select * against a pinned table I want row output totally turned off.
in the past I thought set serveroutput off, set termout off, set pagesize 0 was
sufficient, but its still dumping row data on me. What have I forgotten ?
TIA
the top that says "connect
username" - you should connect first b4 running the
script
7) save the file!
8) run the script to create all the
indexes
HTH
bill
-----Original
Message-From: Markham, Richard
[mailto:[EMAIL P
Title: full exp/imp of user to new tablespace; same user
I have a full export of user to where I need to import all his objects/grants
but into a NEW tablespace. What's the easiest way I can assure that
~everything~ is imported. Will I need to use a combination of INDEXFILE
and other
Title: RE: Out of procee memory problem ..
what is 4,50,000 ?
-Original Message-
From: Satyendra K Khare [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 07, 2002 8:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Out of procee memory problem ..
This is the error
Title: RE: SPIN_COUNT - 8i obsolete? What now?
additional factors:
log_checkpoint_timeoutlog_checkpoint_intervalfast_start_io_target90% size of smallest redo
log
alter system
checkpoint
-Original Message-From: Jack van Zanen
[mailto:[EMAIL PROTECTED]]Sent: Thursday, November
Title: RE: full exp/imp of user to new tablespace; same user
well now I can say I'm spoiled. I was given more than enough information to
to accomplish the task (done) and a new tool to boot! =)
Thanks alot everyone.
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Title: RE: System Tablespace and Autoextend
I have read complaints about SYS.IDL% objects having PCTINCREASE 50 and
space problems when they extend, in the forums. I went to check and
mine are already set to 0 along with 2147483645 MAXEXTENTS. I created
a TAR and verified with Oracle that
Title: RE: Oracle DBA with SAP Needed
What does Base Salary is 55K-to maybe high 60s Firm. mean? You can
throw the possibility of a raise out the window? =)
-Original Message-
From: OraStaff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 06, 2002 9:49 AM
To: Multiple
Title: RE: Re Raid 5+
Jared
raid 5 is good over a single disk for the read speed and the fact
you can rebuild if a disk is lost. A raid 5 write includes the
additional overhead of calculating parity, no question about it.
My raid 1+0 spindles are faster than my raid 5 when it comes to
Title: RE: LOCALLY MANAGED TABLESPACE
Metalink Note: 93771.1
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 24, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject: LOCALLY MANAGED TABLESPACE
Hi
I am thinking to change our few
Title: RE: RMAN - It's Here
do list members get a I post where you post discount? =)
-Original Message-
From: Freeman, Robert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 24, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RMAN - It's Here
Just a note that
is
Forms 6i Server not an option?
-Original Message-From: Fink, Dan
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 23, 2002 6:14
PMTo: Multiple recipients of list ORACLE-LSubject:
Deploying a 6i Form to the web
One of our
developers (not a duhveloper) has asked if
I'm a little confused when one is talking about putting indexes and
tables into seperate TABLESPACES and the other is talking about seperate
DISKS. To any extent, I cant imagine how seperating
IO typesacrossphysical controllers could be anything but
rewarding. Yet, splitting across "DISKS"
Tim,
point well said. Thank you.
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 22, 2002 11:15
AMTo: Multiple recipients of list ORACLE-LSubject: Fw:
oraperf comment
...resending, as the original send encountered
some kind of
Title: Archive files and their Management
I'm up
for my backup and recovery class here soon, butthis conversation has
brought up questions
that I think some of you wouldn't mind discussing
anyway. I see
whereimplementing archive logs
requires that youmodify the database startup
procedure
Title: RE: Archive files and their Management
ok thanks for the info. The following was MISLEADING:
http://www.orafaq.com/faqdbabr.htm
Section: How does one put a database into ARCHIVELOG mode?
To enable ARCHIVELOG mode, simple change your database startup command script, and bounce the
I'm
curious how you get sendmail/mailx to send a file as an attachment? I
suppose it can be done.
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 17, 2002 11:59
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
How to zip a file on
Title: SNP acronym?
What does the background job queue acronym SNP stand for ?
Title: RE: OEM can't seem to discover 1 instance
John I had the same issue recently where before the same instance
had been discovered. I had deleted the node after having removed
one instance from the server. Before it discovered all three and
now it discovers only one of two. Go figure. I
Joe are you on UNIX? you could pipe the
stdout to a program called tee
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002 11:14
AMTo: Multiple recipients of list ORACLE-LSubject:
stupid RMAN question
Ok i've been thru all of the 817
Title: Phew ... Finally Migrated
I
appreciate the feedback Raj.
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002
11:24 AMTo: Multiple recipients of list ORACLE-LSubject:
Phew ... Finally Migrated
Over the weekend we
Title: RE: 8.1.7.2 or 8.1.7.4
Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably
be 9iR2 starting with a test db, then from there, onto the least important db upwards.
Of course I'm stalling to let all the venturous customers test thease new realeases
(and
Title: RE: Advice needed on move to Sun 15K (losing spindles)
Lets say a guy only has one finger on each hand to tie his
shoe (mirroring). If he had five fingers (striping) he can
accomplish the job quite a bit faster. Now give him 1000
shoes to tie and listen to him bitch about how he could
Title: RE: Is it possible to copy one db to another if the SID is differ
or consider note: 174625.1
-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 11:04 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Is it possible to copy
Title: RE: DBA place in the business (was RE: DBA work load)
you can write down the known heiarchy, then encompass that within a circle.
add a picture of the DBA holding the sphere in his hand or better yet if you
really want to get creative, place it on his back and have him poised like
Title: RE: Backups
It would be interesting to see how you would explain how either
cp or dd (which know nothing of archive log mode, or the concept
of hot backup, itself, none the less) is going to keep things
consistent, when these utilities themselves are for point in
time operations.
am
spoiled knocking on wood.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 1:38 PM
To: Markham; Richard; Multiple recipients of list ORACLE-L
Subject: Re:RE: Backups
I've used cpio, dd, and fbackup to do hot and cold backups
Title: RE: how to find out the patch applied on different env.
FILENAME adphrept.sql
DESCRIPTION
SQL script that creates a report file showing the patching history
of all patches
also can be used in conjuction with the following SQL, this tends to be more granular:
SELECT * FROM
Title: RE: Oracle D.B.A. required in M.A.
Is it that or is it a new goal to get a developer than can play part time DBA
or vice versa and reap all the benefits for the price of one?
-Original Message-
From: ltiu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 1:15 PM
Title: RE: Degrade a database??
I can't think of any better way to back out of anything other than
a restore from disk or tape.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 26, 2002 2:48 PM
To: Multiple recipients of list
Title: migrating 8.x-9i and charsets
Ron I was reading your response about converting to UTF8 and it has risen some curiosity with my situation and recent upgrade of a DB from 8.1.7.2 to 9.1.0.3. A snippet from the migration manual states:If the old National Character Set is UTF8, then the
has any input.
-Original Message-
From: Markham, Richard [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 25, 2002 9:28 PM
To: Multiple recipients of list ORACLE-L
Subject: migrating 8.x-9i and charsets
Ron I was reading your response about converting to UTF8 and it has risen some
Title: RE: DBA work load
yea I was going to add that as much as the hardware trend
has demanded redundancy for failover so it would make sense
that a production shop would apply that to its personnel
as well.
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Title: RE: rebuilding an instance from a cpio file?
here's an excellent link that will give you more than you asked
for.
http://www.onlamp.com/pub/a/bsd/2002/07/11/FreeBSD_Basics.html
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 2:54 PM
Title: moving non system segments
I was playing around with Tim Gorman's hc.sql (health check) and
would like to move these objects into the USER tablespace. I would
like assistance in additional things to consider.
I haven't actualy used the command but believe I would use:
ALTER
Title: RE: migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my
i had the same issue where all my data files were moved to the same slice
which fortunately i had a large slice. i ended up doing the manual upgrade
steps through the Migration manual.
-Original Message-
From:
are
either of you or any one on this list working with 11i applications? I am
curious as to how the load balancing works against the hard
coding
of web service infomation in the FND profile options which seems to only
provide configurationfor one application tier.Does
the
second
tier only
Title: RE: Estat Bstat
you could always have the utl*stat report output interpreted by oraperf.com for free.
-Original Message-
From: Ora NT DBA [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Estat Bstat
Title: RE: log_file_sync io wait question
well if you have mirrored members that exist on the same disk thats an
issue, if this same disk houses the currently used datafiles that would
add to the situation. I placed my redo on a seperate raid-1 and dropped
the member mirrors and see better
Title: RE: backup controlfile to trace
a non-full proof method that I use is
T_FILE=$(ls -1rt /$ORACLE_HOME/admin/udump | tail -1)
this will assign $T_FILE to the newest file existing in UDUMP.
-Original Message-
From: Ray Stell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
Title: RE: Oracle Version on Unix
Chapter 7 Section Changing the Word-Size of your Current Release
within the Oracle 9i Database Migration Manual.
I dont see why you couldn't do: file ${ORACLE_HOME}/bin/oracle to
determine the word size.
-Original Message-
From: Mercadante,
Title: RE: Decode
an example straight from 9i SQL Reference should do
SELECT product_id,
DECODE (warehouse_id, 1, 'Southlake',
2, 'San Francisco',
3, 'New Jersey',
4, 'Seattle',
'Non-domestic')
quantity_on_hand FROM inventories;
-Original Message-
From: Ruth Gramolini
what are the drawbacks with such a trigger,
what if the code went invalid and would not compile is
it possible that you could lock yourself
out, or would the base login functionality still work regardless
or the status of this trigger?
-Original Message-From: Mercadante, Thomas F
Title: RE: ALTER TABLE MOVE command causes table to grow
you didn't mention the PCT_INCREASE of this segment.
-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject: ALTER TABLE
Title: RE: ALTER TABLE MOVE command causes table to grow
just to be certain we are on the same page,
you mention uniform sizing which is on
the tablespace level, so I want to make
sure the PCT_INCREASE you provided was pulled
from dba_segments. if so then i'd say a bit
more info would need
Title: connection output on clone instance
can anyone guide me in changing the connect output:
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
Where Production will be replaced with TEST
Title: RE: arg list too long in unix
go into the top dir and run
find . -name cz-session-* | xargs rm -f
or
find . -name cz-session-* -exec rm -f {} \;
the first runs faster but keep in mind that
in other scenarios xargs splits stdin into
file names on space and newline.
Title: RE: ROWNUM strangeness?
show the full sql please, perhaps its how you are grouping your
conditions
Paul Baumgartel wrote:
I've been given a query to investigate. The performance varies
extremely depending on whether the entire result set is fetched or a
ROWNUM n clause is
Title: os date, sysdate time synchronization
I am considering ntpd to synchronize my server times but I wanted to check if there are any issues with actively synchronizing the system time when there is an oracle database involved. Does the db maintain its own time clock after its started so
56 matches
Mail list logo
