Hi Mike
Siebel has released a note whereby they approve CBO for the EIM process.
Also what I have is a SM Data warehouse logon into the OLTP Siebel db. The
activities this logon does is more akin to OLAP. So what I am doing is
giving this logon a big sort area size, enabling parallel access for
Thx, I also found this last night.
I will wait for the developers so arrive
so that they can test their process.
George
George
Leonard
Oracle Database
Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel:(+27
Hi Gurus,
i know there's 'add_month',
is there any built-in function like 'add_hour' or
'add_minute'?
or i have to write a function to add it?
thanks in advance.
I have a table test((NAME
VARCHAR2(10),AGE NUMBER(2));
data of the table is
NAME
AGE--
-ANAND
1BALU2CHANDU3DAVID4
I want a query which give
me the result as
NAME
AGE--
-ANAND
4BALU3CHANDU2DAVID1
Can any body pl. help me.
Anand KumarITW
3 ïËÔÑÂÒØ 2002 12:03, ÷Ù ÎÁÐÉÓÁÌÉ:
I have a table test((NAME VARCHAR2(10),AGE NUMBER(2));
data of the table is
NAME AGE
-- -
ANAND 1
BALU 2
CHANDU3
DAVID4
I want a query
This errors I got,
I did the same installation on an other server same 8.1.72 and never I got
any errors with statspack.
Why those objects does'nt exists ?
How can fix this problem ?
thanks
grant select on V$FILESTATXS to PERFSTAT
*
ERROR at line 1:
ORA-00942: table or
Hi all
Ok if I execute these
commands/SQL in sqlplus it works. When I add to the
trigger for after logon it does not work.
I get the feeling it is only valid for the
current block, begin -
End.
Any ideas to work around
this.
grant alter session to smload;
drop trigger
In dates, a single day = 1.
Thus
sysdate + 1 = same time tomorrow
sysdate + 7 = same time next week
sysdate + 1/24 = one hour from now
sysdate + 1/24/60 = one minute from now
sysdate + 1/24/60/60 = one second from now
etc
etc
You can also use trunc and round
hth
connor
---
cannot perform an aggregate function on an expression containing an
aggregate or subquery
is the error i am getting while i am executing the query.
SELECT name
FROM (SELECT c.name, COUNT(p.clientid) p_count
FROM client c, project p
WHERE c.clientid = p.clientid
GROUP BY c.name) a,
(SELECT
Throw in the fact also that most of the default
accounts are installed with their account locked...
Love it.
--- Grant Allen [EMAIL PROTECTED] wrote: Hi
all,
Just thought I'd comment on the fact 9i R2
dbassist-created databases
actually prompt for SYS and SYSTEM passwords now ...
no
if you
do a_date + n, it increments a_date(if it is of datatype DATE) by'n'
days.
So
to_date('04-OCT-2002', 'DD-MON-') + 1 = to_date('05-OCT-2002',
'DD-MON-')
If you
want to increment one hour add 1/24, if you want to increment by 1 min. add
1/(60*24) and so on
Regards
Naveen
Most commonly this is due to poor coding, where poor
means the sequence value is obtained explicitly in a
trigger or before the insert/update/etc is done.
Certainly plain old insert into xxx values
(bbb.nextval, ... )
is a lot faster than
a) select nextval from dual
b) do insert
and the
not only that but most of the sensitive accounts are created LOCKED and
you actually have to unlock them to make them work.
Geez, they are asking us to THINK
Rachel
--- Grant Allen [EMAIL PROTECTED] wrote:
Hi all,
Just thought I'd comment on the fact 9i R2 dbassist-created databases
why do
u want such a query?
-Original Message-From: Anand Kumar N
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 03, 2002
1:33 PMTo: Multiple recipients of list ORACLE-LSubject:
SQL Query
I have a table
test((NAME VARCHAR2(10),AGE NUMBER(2));
data of the table
I think it's just that there is no need for a function as hour, minute and
second are always known fractions of a day
i.e 1/24, 1/1440, 1/86400
whereas month is variable. Given that a functions seems a bit excessive.
Iain Nicoll
-Original Message-
Sent: Thursday, October 03,
Depends on the version I think. Oracle has always
allowed DESC indexes, but only in 9(?) is the keyword
actually used in the index build.
hth
connor
--- [EMAIL PROTECTED] wrote:
but there is a create index ... desc?
ASC | DESC
specifies whether the index should be created in
TRY THIS :
SELECT NAME, 4-AGE+1 FROM test;
--- Naveen Nahata [EMAIL PROTECTED] wrote:
why do u want such a query?
-Original Message-
Sent: Thursday, October 03, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
I have a table test((NAME VARCHAR2(10),AGE
NUMBER(2));
the below query adds/substracts the value in the age column...
SELECT NAME, 4-AGE+1 FROM test;
does not work..
-Original Message-
SALAYMEH
Sent: Thursday, October 03, 2002 5:28 PM
To: Multiple recipients of list ORACLE-L
TRY THIS :
SELECT NAME, 4-AGE+1 FROM test;
--- Naveen Nahata
Robyn,
We used the DD method on pre 7.1 oracle with RAW devices. It worked
fine except that it used a lot of tape dumping a raw device when only a
small portion was used. Using a dd command to place a copy of the data
on tape should not be a problem if a restoral is needed. The dd function
is
On unix, multiple entries in the init.ora file results in the last entry being the
only valid value (i.e. last time variable is set). I tested below and only dir3 is
listed as a utl_file_dir parameter. But if you comma delimit them w/ 1 instance of
the variable then all dir's are listed.
If you are running the statspack script as SYS, and still getting these
errors, then it appears that catalog.sql (and may be catproc.sql) was not
run (as sys) on this new database.
- Kirti
-Original Message-
Sent: Thursday, October 03, 2002 3:58 AM
To: Multiple recipients of list
Hi All,
We have users that have OPS$ accounts that have full DML privs when they
run forms application via citrix. Currently they do
not have sqlplus,etc. There is a requirement that some can have
sqlplus,toad,etc. I know you can set up security for sqlplus,etc
using product_user_profile but
I'm administering a number of production databases (mixture of standard and
enterprise editions) most of which are version 8.1.7.0.0 on Windows NT and
2000. All are functioning fine and I have no issues.
I'm considering patching (to 8.1.7.4) some if not all databases and just
want to know if
Santosh,
If you could tell why do you want the ages be reversed?
Aleem
-Original Message-
Sent: Thursday, October 03, 2002 5:35 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: SQL Query
the below query adds/substracts the value in the age column...
SELECT NAME,
huh?
new value
ANAND 1 4-1+1 = 4
BALU 2 4-2+1 = 3
CHANDU 3 4-3+1 = 2
DAVID 4 4-4+1 = 1
looks right to me.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, October
I'm not so sure. I created a DESC index, but the optimizer refused to use
it in a simple query containing an ORDER BY DESC on the indexed DATE column
without hinting, even after I analyzed it (8.1.7.4 and CBO).
Without spending too much time on it, I created a good ol' fashioned b-tree
and it
If you want to be able to use any OS backup for restore/recovery that
database must be closed when you do the backup. If it is not, you won't be
able to recover.
Just a thot,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October
I just loaded 9.2.0 on a Win 2K yesterday,
ran the DBCA and saw neither action.
When I checked the scripts it generated,
it still used the standard passwords for SYS SYSTEM.
Are your setups for WIN or UNIX/LINUX ?
-Original Message-
Sent: Thursday, October 03, 2002 05:23
To:
Hi,
Thanx everybody for the numerous inputs on the issue. It helped clear up
the basics (not just for me, but for several others who go thru the posts
regularly :-)
Cheers,
Shantanu.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shantanu Datta
INET: [EMAIL
Santosh,
Till now you haven't exactly specified what you want and WHY you want such a
thing.
So I can only make a guess at what you want. If you want the age of the last
record to be shown with the name of the first record and so on, then
following is the query:
SQL SELECT * FROM test;
NAME
What flavor of unix...ON HP-UX 10.20/11 Oracle ver 7.3.4.5 we have no
problem with separate entries as mentioned by Jared. However, don't keep gap
between these entries...and define it the way it was explained by Jared.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of
Already did -- and deftly checking the list archives I see that MS Lookout
has once again thwarted me by throwing away a reply by Tim Bunce himself.
Time to get back to tracing -- after I figure out why a listener freezes
while confirming startup on another system sigh
Thx!
Rich
Rich Jesse
Sort of putting on my devil's advocate hat...
- perhaps the document is old and just hasn't been updated. A lot of the
documentation that we have lying around is marked as 7.3, we just haven't had the time
to update them, since were overwhelmed with real work, and can't hire additional DBAs.
Thank you Rachel.
Jared,
here is what I meant:
select
100 * (a.value + b.value - c.value)
/ (a.value + b.value)
from v$sysstat a,
v$sysstat b,
v$sysstat c,
v$sysstat d
where a.statistic# = 37 and /* db block gets */
b.statistic# = 38 and /* consistent
I have enabled Database Session Audit [with AUDIT SESSION]
I then added a program to run every 15 minutes to identify failed login
attempts
for some specific schemas :
connect / as sysdba
set pages60
spool autoreport_failed_APPS_logins
col os_username format a12 hea 'OS User'
col username
Santosh,
your
query is working. See below
SQL CREATE TABLE CLIENT ( 2 CLIENTID NUMBER PRIMARY
KEY, 3 NAME VARCHAR2(10) 4
);
Table
created.
SQL CREATE TABLE PROJECT( 2 PROJECTID NUMBER PRIMARY
KEY, 3 NAME VARCHAR2(10), 4 CLIENTID REFERENCES
CLIENT(CLIENTID) 5 );
Table
created.
SQL
Has anybody put on the patch to resolve this. On Nt, looks like fixed
in 8.1.7.4.5. However, searching on the bug 2410612 reveals two other
corruption bugs that appear unresolved.
Have people put this patch on or waiting for a complete resolution.
Jeffrey BeckstromDatabase
I receive the mails of this late after a long delay approx 1-2 hours. Is this
common?
Sometimes i get the reply first and then i get the question
Regards
Naveen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
INET: [EMAIL PROTECTED]
Fat City Network
In 9i all accounts are created as locked except sys, system and scott.
For sys and system password is required to be defined at creation time as
change_on_install or manager are not created as default. In essence all
accounts has to be unlocked to make them operational
Regards
Rafiq
I disagree. ALTER TABLESPACE tblsp_name BEGIN BACKUP, and you can copy the
datafiles of that tablespace using OS commands and use them for restore
Regards
Naveen
-Original Message-
Sent: Thursday, October 03, 2002 7:48 PM
To: Multiple recipients of list ORACLE-L
If you want to be able
What does your utl_file_dir parameter look like in your init.ora? I am using AIX.
[EMAIL PROTECTED] 10/03/02 11:43AM
What flavor of unix...ON HP-UX 10.20/11 Oracle ver 7.3.4.5 we have no
problem with separate entries as mentioned by Jared. However, don't keep gap
between these entries...and
echo $ORACLE_SID logfile
Scott Shafer
San Antonio, TX
210.581.6217
-Original Message-
From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 6:28 PM
To: Multiple recipients of list ORACLE-L
Subject: svrmgrl echo v$database in script
Oracle
In homemade applications, by default users have a role
with read only, in the applications we change the
default role that allows insert, update, delete.
I've not tested this scenario but how about if, in a
database logon trigger, you check the
v$process.program field then depending of that
I have raised this before and never seen a good explanation.
It is very frustrating to see a reply to a post prior to the post appearing.
What is even more frustrating is when you hit the send button and realise
you have made a mistake or mistyped something.
There is no way of withdrawing it and
Actually, we are aware about TAF setup in the TNSNAMES.ORA
SQLPlus sessions fail-over perfectly well with the TNSNAMES.ORA
file.
It is our custom Pro*C programs [originally written against 8.1.5]
that
don't seem to be handling failover when it is doing DML.
Quoting from the 9iRAC Concepts
Hi All
What shall be the best path for moving Oracle Financials 10.7 Char with
manufacturing/Bill of material Oracle ver 7.3.4.5 under HP-UX 11 to Oracle
Financials with 11.5.7 with Manufacturing/Bill of material Oracle 8.1.7.4
under HP-UX 11.11
1) either to upgrade to 8.1.7 with sever
This doesn't sound right. Put the database in hot backup mode,
backup (whether using cp to a staging point like the poster here
is doing or straight to tape using dd or dump or some other utility),
come out of hot backup mode. Why wouldn't you be able to recover?
John P Weatherman
Database
Yes. This is very normal for me as well.
Naveen Nahata wrote:
I receive the mails of this late after a long delay approx 1-2 hours. Is this
common?
Sometimes i get the reply first and then i get the question
Regards
Naveen
--
ltiu
OCP 9i DBA
--
Please see the official ORACLE-L FAQ:
IMHO, If it ain't broke don't fix it! I know some of the patch releases introduced
new problems. I am at 8.1.7.0 and all is fine for 21 databases. Soon, I wil upgrade
to 9iR2 using RMAN. I believe RMAN has improved some for 9iR2.
Gene
[EMAIL PROTECTED] 10/03/02 10:03AM
I'm
Except for the fact that they could always change the program name that they
are running to match what you need. Then that security is bypassed.
-Original Message-
Sent: Thursday, October 03, 2002 11:08 AM
To: Multiple recipients of list ORACLE-L
In homemade applications, by
Like these
utl_file_dir=/u327/applmgr/10_7/finprod_output/hfs_data
utl_file_dir=/u327/applmgr/10_7/har/1.0.0/mm_cbdata
and these are the last entries in initSID.ora file.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 03 Oct
Title: RE: Restrict certain database access using 3rd party tools.
From the TOAD help file ...
Although TOAD is intended as a developer's tool, TOAD can be made read-only via the two license files that come with TOAD, READONLY.LIC and FULLTOAD.LIC.
TOAD.EXE only reads TOAD.LIC to determine
When I see this happening at our site it simply means that ARCx is free to
work and looking for something to archive. It grabs the oldest unarchived
file, only to discover that ARCy is in the midst of recovering that same
fileso it fails. So the message is a bit misleading. This happens at
they haven't been around as a company all that long so I doubt the doc
is from 7.3
as for the methodology, I've talked to their DBAs and they are forward
thinking, which is why the doc suprised me
--- Grabowy, Chris [EMAIL PROTECTED] wrote:
Sort of putting on my devil's advocate hat...
-
It must be that 386 mail server that is the bottleneck. Or it's the perl program
handling the mail that has the
SLEEP(7200);
line of code in it.
;o)
Dave
-Original Message-
Sent: Thursday, October 03, 2002 12:03 PM
To: Multiple recipients of list ORACLE-L
I have raised this before
FWIW, do not place the terminating semicolon in the execute string, ie,
begin
execute immediate 'Alter session set OPTIMIZER_MODE = choose' ;
end ;
/
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
If fyou want to do it from within a script, you either need to code the
select into a .sql file that you run OR you need to escape the $ with
a \ in your ksh script
--- [EMAIL PROTECTED] wrote:
echo $ORACLE_SID logfile
Scott Shafer
San Antonio, TX
210.581.6217
-Original
Hi,
This works
#!/bin/ksh
export ORACLE_SID=ADW
export ORACLE_HOME=/usr/app/oracle/product/8.0.5
export PATH=$ORACLE_HOME/bin:$PATH
svrmgrl EOF
connect internal
select name from v_\$database;
exit
EOF
Just escape the $ sign with a backslash.
HTH
Lee
-Original Message-
Oh...I dunno...it breaks up my day to figure out the
order of some of the posts. I just figure it's an artifact
of mailing over the internet, with propagation delays and
traffic and whatnot, and our own mail server doing it's
intrusion and virus detection 'thing'.
I suppose if you switch to
Rick,
Can you change the forms application?
If so, then a really simple way of doing this is to grant insert, update and
delete access to the tables to an Oracle role.
When the form starts, enable that role to grant access to the tables. By
default, the role would not be enabled for the user.
Use \ to escape the $ sign.
select name from v_\$database;
- Kirti
-Original Message-
From: Baker, Barbara [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 6:28 PM
To: Multiple recipients of list ORACLE-L
Subject: svrmgrl echo v$database in script
Oracle
What happens if the ORACLE_SID is set to one value and the caller uses
SQL*Net to access a different database? While this is not usually the case
in scripts, it could be a problem if the script is parted of a called
function.
ORACLE_SID=DEV
sqlplus scott/tiger@PROD -- I'm not connected to DEV
In order for the K Shell to let you use a Dollar Sign ($) as a litteral
you need to use the escape character before it (\)
So, instead of
select name from v$database;
use
select name from v\$database;
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03,
I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman
to do online backups. No problem with recovery!
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 12:18 PM
This doesn't sound right. Put the
Oups ! you're right.
--- Kevin Lange [EMAIL PROTECTED] a écrit : Except
for the fact that they could always change
the program name that they
are running to match what you need. Then that
security is bypassed.
-Original Message-
Sent: Thursday, October 03, 2002 11:08 AM
All Im trying to run the following statement
EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)
And get the following error
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be
declared
ORA-06550: line 1, column 7:
PL/SQL:
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.
Lee, you're alive. I'll let the OT list know! Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 1:33 PM
Hi,
This works
#!/bin/ksh
export ORACLE_SID=ADW
export ORACLE_HOME=/usr/app/oracle/product/8.0.5
A) Change your unholy methods to use the light side of the force.
or
B) Just use a different variable to hold the tnsnames.ora entry of wherever
you happen to be connecting to. Or initialize the $ORACLE_SID variable to
whatever you want it to be. This allows you to iterate through a list of
Dan,
You can use a anonymous PL/SQL block like the following in you login.sql or
script file is necessary, it keeps those errors from happening:
whenever sqlerror exit
declare
db varchar2(30);
begin
select global_name into db from global_name;
if(db not like 'DEV%') then
Or a here document that allows you to iterate through a list of SID's if
necessary. Env variables don't have to be static on *nix...
Scott Shafer
San Antonio, TX
210.581.6217
-Original Message-
From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 12:44
Lest we not forget the archivelogs also during this backup procedure.
Ron
[EMAIL PROTECTED] 10/03/02 01:53PM
I forgot about alter tablespace begin backup; etc. I am spoiled, I use
rman
to do online backups. No problem with recovery!
Ruth
- Original Message -
To: Multiple recipients of
Me too. I sort the messages by subject and then date received, and I often
see the responses before the original question.
I don't think it's unique to this list, though.
Dave
-Original Message-
From: ltiu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 11:53 AM
To:
Stephane,
Sounds like you know the answer really.
If your reference tables are all like (CODE, VALUE) or similar, and they
are pretty static values, why not move them all into one table? Probably
gives you performance advantages and maybe code reuse:
SELECT value
FROM ref_values
WHERE code =
I've used cpio, dd, and fbackup to do hot and cold backups before, but never
again. With those utilities the burden of keeping track of what is on which
tape rests with you and normally a stubby pencil pad of paper because you know
what won't be available when you need to do a recovery. They
On Thu, Oct 03, 2002 at 06:38:28AM -0800, Jesse, Rich wrote:
Already did -- and deftly checking the list archives I see that MS Lookout
has once again thwarted me by throwing away a reply by Tim Bunce himself.
That'll be this one...
Tim [also who skims oracle-l sometimes...]
On Tue, Oct 01,
Bob,
It can only be one of two things:
Try EXECUTE SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)
or
connect as SYS and grant execute on DBMS_SYSTEM to your_Oracle_account and
try it again.
Hope this helps
Tom Mercadante
Oracle Certified Professional
-Original Message-
Title: RE: Restrict certain database access using 3rd party tools.
Stupid DBA trick #32, or how to drive your DBA colleague wild on April Fool's day:
go over to her machine, and change the name of the SQL*Plus executable (%ORACLE_HOME%\bin\sqlplusw.exe, plus80w.exe or whatever it is) by
Title: RE: RE: Backups
Yes I personally run Veritas Netbackup for both cold and RMAN. A fiber
SAN has its added benefits as well =). I have never really explored the
implications of these other utilities. My head filled with many
distasteful visuals. Yes, I agree with you and I realize that I
Title: RE: Restrict certain database access using 3rd party tools.
P.S. IIRC this will happen with any client program using SQL*Net:
e.g. change My_program.exe to (My_program).exe and SQL*Net will be unable to establish a connection.
-Original Message-
From: Jacques Kilchoer
It's just like the game show Jeapordy. First you see the answer and then you get the
question.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 1:19 PM
To: Multiple recipients of list ORACLE-L
Me too. I sort the messages by subject and then date
Position: Oracle DBA
Location: Hartford, Connecticut
Salary Range: 60-80K-depends on experience plus excellent benefits
and wonderful work environment.
Candidates already in the Greater Hartford, CT area will be given first
priority..
this company strongly prefers not to
Have you ever scrutinized the email headers to find out where the delay is
coming from?
We have had a rough couple of weeks with delays in and out due to
virus/content scanners that check every message in or out. Some days the
delays have been up to 6 hours!
Brian
-Original Message-
Title: RE: identifier 'DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION' must be declared
You might not have a public synonym for dbms_system.
Try
execute SYS.dbms_system.set_sql_trace_in_session (:sid, :serial#, true)
-Original Message-
From: Bob Metelsky [mailto:[EMAIL PROTECTED]]
All Im
I still prefer cold backups when performing full OS backups.
[EMAIL PROTECTED] 10/03/02 02:28PM
Lest we not forget the archivelogs also during this backup procedure.
Ron
[EMAIL PROTECTED] 10/03/02 01:53PM
I forgot about alter tablespace begin backup; etc. I am spoiled, I use
rman
to do
But of course, rman... backup archivelogs delete. Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 2:28 PM
Lest we not forget the archivelogs also during this backup procedure.
Ron
[EMAIL PROTECTED] 10/03/02 01:53PM
hmm, when you go into svrmgrl connect internal and show parameters, do both show up or
just the last one? on my system, i only see the last.
[EMAIL PROTECTED] 10/03/02 01:13PM
Like these
utl_file_dir=/u327/applmgr/10_7/finprod_output/hfs_data
From which schema are you trying to run this procedure?
I can run it from Sys schema. If you are not running it from Sys schema then
use
EXEC sys.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)
This should work if you have the privileges
Regards
Naveen
-Original Message-
Sent:
Title: RE: Backups
Lots
of folks here on the list canexplain it, but really you would get more
from the Oracle Backup and Recovery Manual. In short, you place your
tablespaces in 'backup mode', one TS at a time is the prefered method. You
backup the datafiles associated with the Tablespaces
Remaining 10% on normal Oracle DBA function.
Platforms used are oracle/unix, oracle/wintowe, sybase/unix, etc.
Person will be trained on other databases/platforms in 'slack time'.
hmm, sounds like 90% developer + 10% dba still = dba. lets not forget slack time for
learning sybase *rofl*
Dick,
That is one method. My rule is that all destructive actions are run
from scripts that require the database name as a parameter. If the
$ORACLE_SID and parameter don't match, the script terminates. I realize this
is redundant, but better safe than having to perform a production
Position: Sr. Oracle 8i DBA
Location: New York, New York
Industry: Publishing, Ecommerce
Salary Range: 90-110K-depends on experience plus excellent benefits and
bonus plan.
*PLEASE DO NOT send your resume for this position UNLESS you already live in
the
Greater New York City area and have
Rman keeps track of everything. No hand documentation..I like that!
You have to use a third party media manager to go directly to tape but you
can backup to disk and then use the OS utilities to put the backups on tape.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L
some Oracle sites still believe in the myths and ratio based
tuning. It can be difficult to convince a client that their long
practiced tuning methodology is obsolete.
In such cases, Connor's wonderful script comes very handy ;)
http://www.oracledba.co.uk/tips/choose.htm
I have used it to
Here you are right. You will see here only one because of width. Please
don't rely on svrmgrl for such info. Instead use sqlplus and check it from
v$parameter
result is
PARAMETER
--
VALUE
Richard,
Distateful is being nice. Try down right horrifying is a more appriopriate
description. Been There, Done that, now have three Unix SA's who handle it.
Life is so grand!!
Dick Goulet
Reply Separator
Author: Markham; Richard [EMAIL
Dan,
For the most part I wholeheartedly agree. But on the same note I do install
stuff like that in scripts that I expect developers to run I know exactly what
database their suppose to be in. On top of that, since the developers don't
have the ability to perform an alter database command
I haven't done nor recommended a cold backup in 3 years since I've been
using Rman. Just not needed anymore.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, October 03, 2002 3:14 PM
To: Multiple recipients of list ORACLE-L
I still prefer cold backups
Damn, I had a smart%% remark I could make on this one, but then Rachel would
never forgive me.
Reply Separator
Author: OraStaff [EMAIL PROTECTED]
Date: 10/3/2002 11:37 AM
Position: Sr. Oracle 8i DBA
Location: New York, New York
Industry:
Ahh... Duh... Prefix it with the owner
Yes
EXECUTE SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (9, 89, TRUE)
Worked!
Thanks for shedding light on this..
I should have saw that, too many pots on the stove ;-)
bob
Bob,
It can only be one of two things:
Try EXECUTE
1 - 100 of 148 matches
Mail list logo
