Tamas,
you
could use the "RAISE" statement as last statement in the execption handler
to re-reaise the exception.
e.g.
begin
null;
exception
null;
raise
end;
regards,
Michael
-Ursprüngliche
Nachricht-Von: Szecsy Tamas
[mailto:[EMAIL PROTECTED]]Gesendet am
Partition. Even on 7, obvious in this case would be
partition views with maybe some changes in the app. Or
maybe not depending the app.
Stripping. Oracle stripping and OS stripping.
Freelists. It seems that the app insert and query.
Because of the inserts it is a perfect case of
freelists. If y
...AND SHARE PLEX from QUEST.
--- Traci Rebman <[EMAIL PROTECTED]> wrote:
> Aldi,
>
> You can use LogMiner to view activity in the archive
> logs.
>
> See Note:111886.1 for how to set it up.
>
> Traci Rebman
> Database Administrator
> D&E Communications, Inc.
>
> --
> Please see the
Michael,
Thank
you for the help!
Tamas
-Original Message-From:
[EMAIL PROTECTED] [mailto:[Szecsy
Tamas] ]Sent:
Wednesday, August 22, 2001 10:06 AMTo: Multiple recipients of list
ORACLE-LSubject: AW: Reraising exceptions
Tamas,
you
could use the "RAISE"
Hello,
It's "Unal Bilisim".
Ethan mentioned about itrprof SQL Analyzer, which is superior to tkprof.
web: http://www.unal-bilisim.com/products/itrprof/itrprof.html
Thank Ethan.
regards...
Babette Turner-Underwood wrote:
> What is "unil-bialism" ??
>
> - Original Message -
> To: "Mul
Title: Message
Better than no log too!! :^P
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Christopher
SpenceSent: Tuesday, August 21, 2001 20:13To: Multiple
recipients of list ORACLE-LSubject: RE: What is in archive
log...
better than n
On Tue, Aug 21, 2001 at 01:53:07PM -0800, Aldi Barco wrote:
> Hi,
>
> My database generated so many archived log now, let say 20 archived log per
> minute. The application and the number of rows in the database is not too
> much different with few days ago.
How did you determine this to be tr
The behavior you describe is normal for PRODUCT_USER_PROFILE.
Once you understand how it works, it all becomes clear ;-)
This is my understanding of it, hopefully someone will correct me if I'm
wrong...
When a user connects to the database via ORACLE's SQL+, the *application* checks
the PRODUC
Help!!,
Can anyone shed some light on this or am I just going mad!!.
We have a situation whereby multiple users need to access (both selects and
dml) tables belonging to 1 specific schema, this must also be achieved
without prefixing the tables with the userid as the SQL is driven by the
applica
One of the ways round this is to have the priv's needed for anything other than
select granted to a role, rather than the generic userid. Make the role
non-default, and require a password to enable it - that way, using the ODBC
connection won't give users any godlike powers.
The issue is how t
Hi !
My previous employer has several DBs (8.1.5 & 8.1.7) on Solaris for Intel.
It's pretty stable and i enjoyed working with it.
Although the trend is to install Linux instead of Solaris on Intel.
Unfortunately , i did not see any comparisons of Oracle on Solaris-Intel ,
on Linux & on NT on the s
You can do this with
ALTER SESSION SET CURRENT_SCHEMA = USERB;
You can find it in Oracle 8i SQL Reference, Volume 1.
Best regards,
Marco
-Oorspronkelijk bericht-
Van: Dave Leach [mailto:[EMAIL PROTECTED]]
Verzonden: woensdag 22 augustus 2001 12:02
Aan: Multiple recipients of list ORA
are we talking about
alter user set current_schema = new schema ?
you require a BECOME USER priv for this
> --
> From: Dave Leach[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Wednesday, August 22, 2001 5:01 PM
> To: Multiple recipients of lis
Dave,
You can use the following :
alter session set current_schema = USERB
Check out the SQL Reference manual - Chapter 7 SQL Statements, ALTER SESSION
(page 387)
HTH
Mark
-Original Message-
Sent: Wednesday, August 22, 2001 11:02
To: Multiple recipients of list ORACLE-L
Help!!,
Ca
I thing that the answer should
be
E) At
least two teachers will receive a 10% salary
increase.
Think if there are the same 2 teachers for class
102,105
Ivo
From: Stephen
Andert [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August
21, 2001 06:57 PMTo: Multiple recipients of list
ORA
Hi all
If I run dbverify on the system ts (or rbs ts AND on different dbs) I get
the following:
DBVERIFY - Verification starting : FILE = /dpp/test01/HOUR/HOURsystem01.dbf
Block Checking: DBA = 67108867, Block Type = Undo data block
ERROR: Undo Block Corrupted. Error Code = 2005
ktu4ubck: Undo
-Original Message-
Sent: 22 August 2001 10:42
To: 'Rahul'
Fantastic, what a relief!!
I have just looked this up on Metalink and have read a note saying this is
an undocumented parameter, I'm now in 2 minds as to whether to use it,
although it sounds exactly what we want.
Many thanks
You may be thinking of the 'proxy user' feature:
alter user xxx grant connect through yyy with role rrr;
However, the features that this enables are currently
available only through OCI programming at present.
The other thing you may be thinking of is
alter session set current_schema =
Yosi, here is the output from v$parameter and
v$system_parameter. As far as I was aware, ismodified will be non-false if an
alter session or alter system command has been carried out. isadjusted will be
non-false if Oracle has dynamically adjusted the parameter.
Show SGA has the following o
OS: NT 4.0
I need to delete the TNS Listener service . and
create a new one .
How can I do that ?
TIA
Bunyamin
I've not really checked out Suse, you have to buy it versus being able
to get RH for free?
joe
Scott wrote:
>
> I believe that Oracle has decided that when porting to
> linux all products will be ported to SuSE and then
> perform post release certifications on Redhat. I
> believe stability and s
It *used* to be undocumented because it used to have a
nasty memory leak (8.0 and below). When they fixed
this (in 8i), it appeared in the doco.
It may have been fixed in patches for earlier releases
- but I dunno.
hth
connor
--- Dave Leach <[EMAIL PROTECTED]> wrote: >
>
> -Original Mes
we had a solution for home-grown powerbuilder apps using
set_client_info, that triggers verified that info from v$session before
any dml happened.
if you're interested in that solution, drop me a line and i'll explain
it.
joe
Larry Hahn wrote:
>
> Jon,
>
> This is one of the options we have ta
Many thanks for all the replies on this,
it is indeed a documented parameter under the ALTER SESSION command. I
can't believe I missed this bearing in mind the time I spent searching.
My sanity is restored for now!!
Dave Leach
-Original Message-
Sent: 22 August 2001 11:32
To: Multi
There is a way. Check Metalink for document 73974.1. It has the complete
instructions. I do this for a report database copy of production.
If you need anymore info let me know,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August
Hi Unix Gurus,
I submit a job to monitor the CPU utilization etc every 15 mins using the
command vmstat 5.
How do I kill the submitted unix process of the batch job ?
I tried to kill the submitted process using a batch job using the following
command :
var_pid=`echo $var_grep_vmstat | (read u
Hi
One table has following information
userid superid
14 -1
4 0
8 2
9 2
15 2
24 4
16 4
25 4
6 5
7 5
26 5
2 16
18 16
10 18
11 18
1 24
5 24
13 24
I want the output in following format
userid superid
possibly the world's most unfortunate name for
an application? I see it posted alot.
seriously, I think it's a web server or a name for
an application?
-Original Message-
Sent: Wednesday, August 22, 2001 1:06 AM
To: Multiple recipients of list ORACLE-L
What is "unil-bialism" ??
-
With 8i you could use the net 8 assistant, or manually edit the
listener.ora file to make the changes
HTH
Peter
At 09:45 PM 22/08/2001, you wrote:
OS: NT
4.0
I need to delete the TNS Listener service . and
create a new one .
How can I do that ?
TIA
Bunyamin
Now Caldera is opening up original unix code under GPL (or a modifed version
of that), there will be even more fun in various versions that are available
freely.
Cheers
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni
Selam Bunyamin,
If you don't want to remove them by installer, you can remove by manually.
to remove( as I remember ), go to
registry:
- HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
- HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services
- HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services
to c
List,
OS Novell 4.2 Oracle 7.3.4.5
I have a table test desc as fld1 number(5,3), fld2 varchar2(1).
The control file has ,(comma) delimited, optionally enclosed in " (quotes).
The data file contains 99.999,C
It fails with an ORA-01401: inserted value to large for column.
Question. Why did O
PostGresSQL has been out for years, and is not RedHat specific, all
distributions have included it.
"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-5
the STIME is always earlier for the command then for the grep, unless
I haven't had any coffee.
On Wed, Aug 22, 2001 at 04:05:24AM -0800, CHAN Chor Ling Catherine (CSC) wrote:
> Hi Unix Gurus,
>
> I submit a job to monitor the CPU utilization etc every 15 mins using the
> command vmstat 5.
>
Can't you just change your grep to additionally pipe into a "grep -v grep"
to exclude the "grep vmstat".
I'm sure all the unix gurus will give you a much better way but this should
work
-Original Message-
Sent: 22 August 2001 13:05
To: Multiple recipients of list ORACLE-L
Hi Unix Gurus
Hi
Have a look at setting the second value with the vmstat command so you use
something like vmstat 5 5 instead. This runs vmstat 5 times with a 5 second
interval
Try it on the command line and see if that is the result you require
HTH
Peter
At 10:05 PM 22/08/2001, you wrote:
>Hi Unix Guru
I am getting the below error where I run STAT
or STOP command of LSNRCTL on 8.1.7 on NT. Content of listener.ora is also
below.
Why is that ?
Note : I can remotely connect to this database from
client.
Connecting to
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))TNS-12541: TNS:no
listener TNS-125
You can download Suse, but you have over 6,000 files to download. It's all
in a specific directory on there FTP server.
On the other hand, for RH you can just download a few ISO files and burn
them into CDs. Easy.
I believe that Suse Personal, with CD and manuals, is 30 bucks. I am
assuming t
http://technet.oracle.com/index.html
Also
get the book Oracle DBA 101 by Marlene Theriault, Rachel Carmichael, and James
Viscusi. It is an excellent book to start with!
Dave
-Original Message-From: Ha Duy Thien
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 9:06
Hello, does anyone know if there is a time limit on exams taken for the OCP DBA 8i
track? More specifically, from when the first test is taken, do you have to complete
the others in a specified amount of time, say within 1 year?
Thanks
Traci
--
Please see the official ORACLE-L FAQ: http://ww
Partitioning, Parallel Query.
"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, Chelms
Yeah, the other thing, 6000 files which consist of 500Mb is about 10x slower
to download than 1 file which is 600Mb
The TCP protocol, ramps, which means, it gets up to speed within the first
few seconds of delivery, when your downloading many small files, your
bandwidth is cut down by 10 fold if
Hi all,
When querying the view X$KSMSP can anyone tell me whether memory chunks with
a value in KSMCHCLS of 'freeabl' can be used immediately. We currently have
an application running against our database which is causing the ORA-4031
error. The app does not make use of shared sql and after flu
Hi Jaouich,
The command
kill `ps -ef | grep vmstat |awk '{print $2}'`
works. Thanks a million.
Peter has also solved the problem for me by advising me to use vmstat 5 5
instead.
Regds,
New Bee in Unix
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 08/22/2001 10:21 PM
select t1.userid, t1.superid, nvl(t2.count, 0) AS COUNT
from onetable t1,
(select superid, count(*) as count
from onetable
group by superid) t2
where t1.userid = t2.superid(+)
order by superid;
Best regards,
Marco
-Oorspronkelijk bericht-
Van: Seema Singh [ma
Thanks, Peter. U've just solved my problem.
Regds,
New Bee in Unix
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 08/22/2001 9:51 PM
Hi
Have a look at setting the second value with the vmstat command so you
use
something like vmstat 5 5 instead. This runs vmstat 5 ti
To keep the rollback segments in buffer, so that rolling around the rollback
segments happens before blocks are written to disk. Which will increase
snapshot to old, but increase performance.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you
Title: RE: Unix - performance tuning (vmstat 5)
I am not sure I understand you question correctly, but here is what I use when I want to kill some jobs ($BATCHJOB = name of the job to kill):
kill -9 `ps -ef|grep $BATCHJOB|awk '{print $2}'`
If I want to kill all of one user's
OK IU have done it . THANK YOU SO MUCH GURUS.
Bunyamin
.
- Original Message -
From:
Danisment Gazi Unal (Unal Bilisim)
I want to thank everyone who gave me input on this
question. It was most helpful.
Ken Janusz, CPIM
> um, I can see possible answers to this question being 2 teachers, 3 teachers
> or 4 teachers.
>
> however, since that isn't one of the multiple choice answers, then it has to
> be "at least 4
Thats certainly the way I would do it Iain.
Lee
-Original Message-
Sent: 22 August 2001 14:51
To: Multiple recipients of list ORACLE-L
Can't you just change your grep to additionally pipe into a "grep -v grep"
to exclude the "grep vmstat".
I'm sure all the unix gurus will give you a
True, but now RedHat pushes it as the 'Red Hat Database'...
http://www.redhat.com/products/software/database/
Christopher Spence wrote:
> PostGresSQL has been out for years, and is not RedHat specific, all
> distributions have included it.
>
> "Do not criticize someone until you walked a mile i
Mark Marsden wrote:
>
> Hi all
>
> If I run dbverify on the system ts (or rbs ts AND on different dbs) I get
> the following:
>
> DBVERIFY - Verification starting : FILE = /dpp/test01/HOUR/HOURsystem01.dbf
> Block Checking: DBA = 67108867, Block Type = Undo data block
> ERROR: Undo Block Corrup
Hi Traci,
There is no time frame from start to finish and as of yet Oracle has no
plans in retiring the Oracle 8i track.
Rick
-Original Message-
Sent: Wednesday, August 22, 2001 10:22 AM
To: Multiple recipients of list ORACLE-L
Hello, does anyone know if there is a time limit on exams
Seema:
Here's my crack at it:
select x.userid
, x.superid
, nvl(y.count, 0) as count
from mytable x
, (select a.userid
, a.superid
, count(*) as count
from mytable a
, mytable b
where a.use
6000 files, what a pita, guess i'll stay with hacking rh to run oracle
:)
joe
>>> [EMAIL PROTECTED] 08/22/01 10:16AM >>>You
can download Suse, but you have over 6,000 files to download. It's
allin a specific directory on there FTP server.On the other hand,
for RH you can just download a
Highly depends.
I tend to stay back from the latest versions for some time.
I also tend to upgrade for functionality, and upgrade when I have existing
problems that are told to be fixed.
Sometimes if I start falling back versions and have no reason either way, I
will upgrade my development datab
Which as we all know courtesy of Mike Hately, stands for redo trace file
manager, now a discontinued feature ...
greg
-Original Message-
Sent: Wednesday, 22 August 2001 03:50
To: Multiple recipients of list ORACLE-L
Or just be like me and spend most of the time saying "rtfm" :)
joe
"Mo
Try to add this entry to DESCRIPTION_LIST in your
listener configuration file:
(ADDRESS = (PROTOCOL = IPC)(KEY = PLNT))
So:
LISTENER = (DESCRIPTION_LIST
= (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bunyamin)(PORT = 1521))
) (DESCRIPTION =
(ADDRESS = (PROTOCOL
SYSTEM objects don't matter, but I wonder how the SYS
objects ended up in the TOOLS tablespace.
Audit tables perhaps?
Jared
On Tuesday 21 August 2001 09:16, Kumanan Balasundaram wrote:
> I was bitten but this badly and thanks to all those people who
> helped me. This may some of you, so I'm p
Hi Listers
I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?)
as I get the occasional ORA-600/ORA-7445.
Do you upgrade to the latest subversion as a matter of policy
(and not test very much) to prevent possible errors
or only upgrade if you have problems?
Do you upgrade to major ve
I have not seen anything of a time frame for the OCP
exams. The only time frame is when the next release
comes out and the previous release becomes obscolete. I
am APICS CPIM certified and APICS has a time limit of
about 3 years (?).
Ken Janusz, CPIM
> Hello, does anyone know if there is a
Dear gurus !
sorry for this RTFMable question , just don't have the docs in front of me
here .
Assume i have a trigger my_trig that performs an insert into tableB after an
insert into tableA .
The question is : what happens if the trigger gets broken (either disabled ,
invalid or unable to do what
Title: Message
Also a
lock will be established on deletes.
"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
Fuelspo
List,
Does anyone know of a method by which I can prohibit users from connecting
into my Oracle 8.0.6.0.0 database by any product other than the
application's executable program? (i.e. - I don't want anyone connecting
through TOAD, etc.) But, I do want to allow anyone with DBA role to be ab
Hi!
I am an Oracle products user (in fact JDBC applications that use Oracle as a
backend) but I used them only under Windows platforms. The installation on that kind
of platform is pretty simple, but I am not so satisfied with the performances.
I have been told that Oracle products wo
Joe,
It's cheap. $60-70 for the pro version.
Even though I've been a long time RH user, I prefer SuSE
simply for the documentation and admin utils.
Jared
On Wednesday 22 August 2001 04:50, Joe Testa wrote:
> I've not really checked out Suse, you have to buy it versus being able
> to get RH
Tom,
Thanks!!
Ed
-Original Message-
Sent: Tuesday, August 21, 2001 3:13 PM
To: Multiple recipients of list ORACLE-L
Ed,
how about:
tnsping {sid} 1000 > ping.lis
will tnsping the {sid} 1000 times, with the result being placed in a file
created named ping.lis
changing it to
*** f
I think only restriction is you have to wait for sometime(30 days?) before
you can
re-take a failed exam.
Surendra
-Original Message-
Sent: Wednesday, August 22, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L
Hi Traci,
There is no time frame from start to finish and as of yet
Try this:
var_pid=`echo $var_grep_vmstat | grep -v grep | (read u v w x
y z; echo ${v} )`kill $var_pid
the grep -v grep will remove any lines with the word
grep.
HTH
Stephen
>>> [EMAIL PROTECTED] 08/22/01 05:05AM >>>Hi
Unix Gurus,I submit a job to monitor the CPU utilization etc every 15
On Wed, Aug 22, 2001 at 07:45:27AM -0800, Mark Marsden wrote:
> Hi Listers
>
> I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?)
> as I get the occasional ORA-600/ORA-7445.
Doc ID: Note:123178.1
Product / Platform: Oracle8i, Release 2 (8.1.6)
Error Correction Support ends on
I still think it's redo block address!
-Original Message-
Sent: Wednesday, August 22, 2001 12:50 AM
To: Multiple recipients of list ORACLE-L
Kevin,
Thanksclarity is always preferable.
As for the acronym inflationI guess when I wrote "block" instead of
"byte", I simply hadn'
and its only 2.3K :)
guess i'm spoiled being able to grab darn near anything that oracle has
from technet.
joe
>>> [EMAIL PROTECTED] 08/22/01 11:00AM
>>>True, but now RedHat pushes it as the 'Red Hat
Database'...http://www.redhat.com/products/software/database/Christopher
Spence wrote:
These messages will show up in your 8.0.x database if you have set
log_checkpoints_to_alert=TRUE. This gives you an easy way of seeing how
long it takes to complete a checkpoint and if any are happening between log
switches.
Mike Hand
Polaroid Corp
-Original Message-
Sent: Tuesday, Aug
I need to do some documenting too.
Person probably driving the bus ;-) (That person thats been stalking
you)
Oracle Versions
Patches installed
File system layout
Instances mapped to Oracle Homes
log files (methods for checking/trimming)
scripts/tools (what/where/when/why)
listener info (name/port
how about this as a solution:
alter user sys default tablespace tools;
@?/rdbms/admin/Put SCRIPT HERE :)
joe
>>> [EMAIL PROTECTED] 08/22/01 12:02PM
>>>SYSTEM objects don't matter, but I wonder how the
SYSobjects ended up in the TOOLS tablespace.Audit tables
perhaps?JaredOn Tuesday 21 Au
Title: RE: database upgrade policy?
Don't upgrade unless there is a very good reason.
All of these are candidates
1. current oracle version is unstable
2. specific bug addressed by an upgrade/patch, as identified by support
3. need to utilize new feature
4. desupport date coming up.
Title: RE: linux & Oracle -- best combination
Have you tried an index hint on the first query yet?
Have you tried NVL(cmm_id,101) = 101,
NVL(cust_id,101) = 101
NVL(Friendly_session_id,100) = 100
loc_to_utc(NVL(creation_date,21-jun-2001')) between ?
-Original Message-
From: Vikas
granted $60 is not much but its A LOT more than free :)
joe
>>> [EMAIL PROTECTED] 08/22/01 11:56AM
>>>Joe,It's cheap. $60-70 for the pro
version.Even though I've been a long time RH user, I prefer
SuSEsimply for the documentation and admin utils.JaredOn
Wednesday 22 August 2001 04:50, Joe
Hi,
my hdd (c:) on server running NT4.0 has been corrupted.
Is it possible to move Oracle db files on other server running linux(!!!),
create instance and mount -> open all db files (not only system)?.
Thanks
Jan Pruner
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Hi,
I am a newbie to this OLAP area.
I have this table (company_dimension) where every company has a parent,
which in turn can be a child to another parent and so on. It is about 10
levels deep.
TEST@D0MARS> desc company_dimension
NameNull?Type
Yes. I was curious, so I did a little test:
Create 3 tables. Note the different datatypes.
SQL> create table dbm_1
2 (a varchar2(5) not null);
Table created.
SQL> create table dbm_2
2 (a number not null);
Table created.
SQL> create table dbm_3
2 (a varchar2(5) not
We're trying to re-write some SQL such that the index on columns in the
where clause is used.Logically ,the query is as below .But this query does
not use the Index .However ,if we re-write it as below(see 2nd query) - the
index is used :but the query returns incorrect results .Can you suggest any
Hi DBA's,
I've recently completed several SQL*Plus scripts and Batch files to do Hot
backups of our production Oracle 8.0.5 database at 8am, 12pm, and 5pm daily.
Currently, I have to double click the batch file icon which calls SQL*Plus
and executes the backup script.
I tried unsuccessfully to
sorry for the incorrect "subject"! See below :
-Original Message-
Sent: Wednesday, August 22, 2001 9:08 AM
To: '[EMAIL PROTECTED]'
We're trying to re-write some SQL such that the index on columns in the
where clause is used.Logically ,the query is as below .But this query does
not use t
We were running 8.1.6.0.0 and just recently encountered the ORA-7445 errors,
which caused core dumps and invalidated the referential integrity of our
database. Oracle recommended the 8.1.6.3 patchset. We decided to skip that
and go for 8.1.7 but for some reason Oracle mailed us the 9i CDs. I gu
Title: RE: User access within/outside of app
What version are you working with?
-Original Message-
From: Larry Hahn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 21, 2001 11:21 AM
To: Multiple recipients of list ORACLE-L
Subject: User access within/outside of app
List,
W
Is there any problem deleting the alert log on NT while the instance is up
and running? V7.3.4 - 8.1.6
Ron Smith
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-505
Tsk, tsk Andrey, this doesn't even require RTFM. :)
create table a;
( insert your columns here)
create table b;
( insert your columns here)
create trigger a_insert_b;
( your trigger code here )
alter trigger a_insert_b disable.
insert into a(columns) values(your values).
And, the docs are on
Jan,
Only if you have a full export of the database. Moving just the files to Linux
will not work since NT and Linux use different ways of writting to disk.
Dick Goulet
Reply Separator
Author: Jan Pruner <[EMAIL PROTECTED]>
Date: 8/22/2001 8:51 AM
You can not move db files between different OSs.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 12:51 PM
> Hi,
> my hdd (c:) on server running NT
I don't think you can do it in 8.0.6.
Starting with 8.1.5 you could use db logon triggers.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 12:16 PM
a a glutton for punishment. Dev, sure why not, just dont let the
developers get to attached to the new features, prod?, i wouldnt update any prod
database(unless forced to by oracle corp) until 9.1 at earliest, yes there are
some kewl things, but heck the latest 8.1.7 patchset has 22 pag
No you can delete it anytime and Oracle will recreate it.
Rick
-Original Message-
Sent: Wednesday, August 22, 2001 1:27 PM
To: Multiple recipients of list ORACLE-L
Is there any problem deleting the alert log on NT while the instance is up
and running? V7.3.4 - 8.1.6
Ron Smith
--
Ple
Hi,
I am looking for some examples of DFD(data flow diagram), BPM(business
process module), and SOW(statement of work); some web-pages with examples
would be great. If someone can point those I would appreciate it.
Thanks.
Lyuda Hoska
--
Please see the official ORACLE-L FAQ: http://www.orafaq.
You can use a password protected role which is only enabled
in the executable using a stored package that executes
dbms_session.set_role.
The package checks which program name invoked it be querying
v$session.program.
If the role is not enabled, users not granted the role do not have access
to
Back to the experts
We have an
application that, litterally overnight, developed locking
issues.
Our users
start working just fine. Then, right now cause unknown, our inserts
start being blocked. Usually there are so many so fast that we do
not even know what
check out $ORACLE_HOME/rdbms/admin/utlockt.sql
joe
>>> [EMAIL PROTECTED] 08/22/01 02:46PM
>>>
Back to the experts
We have an
application that, litterally overnight, developed locking
issues.
Our users
start working just fine. Then, right now cause unknown, our
Lisa,
You need some work to do
Certifiable Gimp Monkey?? Stub you toe while swinging on the trapeze?
ROR mô¿ôm
>>> [EMAIL PROTECTED] 08/22/01 12:45PM >>>
Don't upgrade unless there is a very good reason.
All of these are candidates
1. current oracle version is unstable
2. specific bug
lk-
sorry no specifics, but here are some pointers you might find useful:
http://www.ultratech-llc.com/KB/?File=TaskSched.TXT
-
http://www.ultratech-llc.com/KB/Scripts/?File=!Contents.TXT
-
http://www.ultratech-llc.com/KB/?File=Scripting.TXT
Also, general info:
http://www.microso
1 - 100 of 127 matches
Mail list logo