 | | | Oracle List | |
Morning Niall
> > As some of you will have picked up I am in a relatively new
position.
Nope didn 't notice o)
> > One of the things sadly lacking is any sort of pro-active monitoring
routine.
PHi List
While migrating storage on HP Superdom few of our datafiles were
corrupted and the backup is continuously failing to backup thru rman.
What is the syntax to skip the corrupted files while GRANT EXECUTE ON UTL_HTTP TO NEW_USER
Which view in the data dictionary is queried to show the statement above had
been issued?
I 've been looking for the answer for a couple of hours.
Any clue woul
> This is probably the hardest part depending on the extent of the
damage.
^^^^^^
No pun intended of course!
--
http //www.freelists.org/webpage/Hi
Getting above error when running sqlldr as user not belonging to dba group.
ORACLE_HOME SID PATH etc are set correctly.
Had similar problem with sqlplus which I resolved by chmod 755 to
files ac
What do people think about having a security analyst on a team
with sensitive data? This is not a technical person. Someone who is in
charge of policy and reviews designs to make sure it meets sec
If you are using 9i then you get some clues from
v$sql_workarea - columns max_tempseg_size and
last_tempseg_size give you an idea of space used
xxx_executions give you an idea of how many times
spaHi List
I inherited an Oracle 10g (standard 10.1.0.4) database from my previous DBA.
The task is to change the configuration so the the new emails goes to a new
email distribution where the previouerr otn.oracle.com - the complete documentation set
On 14/08/06 Dean Paul <oracledbam@(protected) > wrote
>
> If any one know good website where I can find Oracle Financial docs let me
> know.PLEASEBe sure you know what you want to increase. I spent of fair amount of
time playing with this before understanding that AWE allows you to
increase ONLY db_block_buffers (ie - move those out of the defHI
Seems inproper index used for some query.
If you can attach a Oracle statspack we could give you more useful ideas.
On 8/15/06 Alfonso Le?n <aleon68@(protected) > wrote
>
> Hi Every one
> weHi
I would suggest you use a free tool to extract oracle rows as flat text
file.
http //www.iamdba.com/ociuldr.html
On 8/15/06 Hand Michael T <HANDM@(protected) > wrote
>
> The next be1-Can I do a direct migration from 8.1.7.4 32-bit to Oracle 10gR2 - 64-bit? - I seem to remember having to do an export/import - yikes!!!
2-Any gotchas from going to 8.1.7.4 32-bit to Oracle 10gR2 -Hey out there.... I 'm looking for DBA 's or Data
Architects who are also members of the LDS church.
How many of you are out there?
Robert
Robert G. Freeman
Author
Portable DBA Oracle (Oracle PWe have a server running 9.2.0.7 and 10Gr2. We are going to upgrade the OS
to Solaris 10 from 8. Anything obvious I should know about in terms of
database gotchas?
Thanks
Ethan
<div >We have a serveScott
Why are the triggers invalid?
Calling SQL*Plus from a extproc seems like overkill. Why not put these
things into dbms_scheduler and run them from there? In any case you
could call SQ
Running under 10.2.0.1
drop table pt_iot
create table pt_iot (
customer_id number(12)
ref_date date
expenditure number(6 2)
constraint iot_pk primary key (customer_id ref_date)
)
organizatGreetings
Oracle 8.1.7.4 HP-UX 11.11 Netbackup
HARDWARE HP9000-800
VERSION NetBackup 5.1MP3AS2
SUN/STK 9840B Tape drives 20mb/Sec 256KB buffer size
We have dedicated 4 tape drives for this backOn 8/11/06 Ethan Post <post.ethan@(protected) > wrote
> I am surprised to see so many negative reactions to this feature. First
> off I want to be able to do what I want to be able to do. Having a fI am upgrading a 8.1.7.4 database (the java component cmpdbmig.sql) to
9.2.0.7 just saw this in the alert
Mon Aug 14 12 45 26 2006
create rollback segment MONSTER storage (initial 2 m next 2 m maxPerhaps you have enabled the trace in a certain session analyzed (and
removed) the tracefile and disabled the event.
If you then later on re-enable the trace for the same session no trace
file willMorning all
Just wondering if anyone else is experiencing the same problem as me - it started a few weeks ago but not sure exactly when.
Emails send to oracle-l from a gmail account do not make it tJoshi
Is your OEM install in the same directory(Oracle Home) as your 9i
client? If not check to make sure that your network/admin/sqlnet.ora
tnsnames.ora files are correct in the Oem Oracle Ho Not sure about 9.2.0.4 but I am pretty sure I have installed
9.2.0.6 in RHEL 4 Update 2 a couple of months ago.
Have you tried
http //www.puschitz.com/InstallingOracle9i.shtml#RunningOracleInstaHI I found this interesting on 10.2 standard edition windows database.
And I was asking if someone know some trick to use restore point on oracle
standard edition 10.2
even when I think this is definI am performing some heavy duty processing through job schedules. In one of
the job queue files I saw this message can 't make head or tail out of it so
if someone can clue me in that would be very ap
> > >If you must bounce the db what is wrong with shutdown abort?
You don 't look as if this is for a cold backup so who cares that some
recovery is required?
...there are 600+ connections. might iOracle 10.2.0.2 Solaris 8
Wondering if anyone could explain this. We have 105 SYS-owned tables where
num_distinct < num_buckets according to dba_tab_col_statistics (see
following query). Even weirdeI am on a rather large team and we are trying to come up with a consistent strategy for performance testing. We want to come up with a way to gather metrics and measure performance and regiment it so > > >a Siebel OLAP/Analytics database
> > > that I inherited after the fact. I 've perused
> > >OTN/Metalink/Siebel and found nearly zilch on
> > > best practices/tuning for Siebel on Oracle.
Iro |
|
|
