Hi Gurus,
I have annihilated our test system trying to achieve this. Does anyone have
any links to sites or Metalink which documents this.
What I have done is try to load two versions of Oracle 7.3.4 and 8.1.6 onto
an NT system.
I did the obvious by placing the versions in their own Oracle Base
Can anybody explain to me what the average load figures you can get vith
the top - command really means.
Someone is telling me that our Sun Solaris Server, running a suncluster with
two database instances where we have Oracles emailserver and Oracles
ldapserver combined with Oracles Unified
Hello list,
I haven´t seen many questions about Developer tool in this forum, maybe
it´s not the correct one to make this question, but I´ll try it.
Although there is a lot of information about LOB´s in manuals and
Metalink, I haven´t found anything about displaying an image stored in a
BLOB
Hi everyoene,
Is there any way I could cause my pl/sql to proceed with executuion when an
exception is raised? Im thinking of a kind of 'On Error Resume Next' thing
we've got in VB. Ive got a loop and I need to continue executing the code in
the loop after when an exception is raised and after I
Hi,
You have to first install v7.3.4 in the default_home. Then install v8.16 in
a new Oracle_home (specified during install). There actually shouldn't be a
problem as we have multiple homes running fine on one of our systems. Just
make sure u install 7.3.4 first.
There is a info abt this in the
Other things to consider as well as size:
- type of I/O (lots of sequential versus lots of
random)
- distributing the I/O across all of your devices
- readonly versus read/write. If you can move chunks
of data to readonly tspaces then this shrinks backup
times
hth
connor
--- VIVEK_SHARMA
A logical volume is not necessarily associated with
a single disc as in most cases people tend to
mirror/stripe a volume group across many disks
before creating logical volumes in the volume
group.
However, if you execute
vgdisplay -v /dev/vg00
then the tail end of the report will show you
There is a SuSE-specific Oracle-List
Send a mail to
[EMAIL PROTECTED]
or visit
http://www.suse.de/en/support/mailinglists/index.html
Stephan
-Original Message-
Sent: Thursday, August 23, 2001 1:51 AM
To: Multiple recipients of list ORACLE-L
Do you mean ORACLE-LINUX-L at [EMAIL
Hello All,
I am getting ora-12542 error while loading the data using sqlloader.
What could be the problem how can i fix this problem.
Regards,
Saroj.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dash, Saroj (CAP,CEF)
INET: [EMAIL PROTECTED]
Fat City
Thanks Sujatha,
I think it could be that exact problem, Oracle 816 had been loaded earlier
and in the default HOME.
I have one question if you would not mind answering for me. How do the two
listeners work together? Should I name the Oracle 8 listener something other
than LISTENER, or do they
and here you have it !!!
12542, 0, TNS:address already in use
// *Cause: Specified listener address is already being used.
// *Action: Start your listener with a unique address.
Regards
Lee
-Original Message-
Sent: 23 August 2001 10:35
To: Multiple recipients of list ORACLE-L
Hi Listers
I don't intend to start off some sort of 'flame' here...
But I really would like to know 'how' important
is an ERP DBA and 'how much' does he NEED to know..?
I personally feel that with ERP products giving
an interface to the ERP DBA..there is NOT much
that an ERP DBA can
My question is how to resolve this problem.
-Original Message-
Sent: Thursday, August 23, 2001 PM 07:36
To: Multiple recipients of list ORACLE-L
and here you have it !!!
12542, 0, TNS:address already in use
// *Cause: Specified listener address is already being used.
// *Action:
I personally have not attended any training class
But I've seen people come back
with a lot of what I learnt thro' 'hard work'
from the OCP DBA class offered by Oracle.
Regards
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cyril Thankappan
INET: [EMAIL
no
Volker Schön
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 22. August 2001 19:27
An: Multiple recipients of list ORACLE-L
Betreff: Delete Alertlog on NT
Is there any problem
Denham Eva wrote:
Hi Gurus,
I have annihilated our test system trying to achieve this. Does anyone have
any links to sites or Metalink which documents this.
What I have done is try to load two versions of Oracle 7.3.4 and 8.1.6 onto
an NT system.
I did the obvious by placing the
Hello,
Oops..its alright..I was 'able to retrieve' it!!!
However, if you want to 'add any details' to it..please feel
free..
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cyril Thankappan
INET: [EMAIL PROTECTED]
Fat City Network Services--
Jared , thanks a lot !
Yes , i did it a minute after i posted this question (just did not think of
it earlier).
But i'm still interested to know Is there a way to let the user insert into
tableA , and capture the inserts
into tableB that the trigger should perform , and do those inserts manually
Hi all,
When I do
Select * from v_$sga;
NAME VALUE
--- ---
Fixed Size ###
Variable Size ###
Database Buffers###
Redo Buffers
THANKS A LOT FOR ALL WHO REPLIED !
-Original Message-
Sent: Wednesday, August 22, 2001 7:12 PM
To: Multiple recipients of list ORACLE-L
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
isn't that what the Action part of the mail I sent you below tells you to do
?
-Original Message-
Sent: 23 August 2001 11:46
To: Multiple recipients of list ORACLE-L
My question is how to resolve this problem.
-Original Message-
Sent: Thursday, August 23, 2001 PM 07:36
To:
It seems that the column format of col. VALUE is less.
Before giving the first command give the following command
column value
It will display the current column format of column VALUE
Now second SELECT doesn't gives any problem 'coz col format is assigned on
col. VALUE not on VALUE + 0.
Beatriz,
You don't see many discussions of Forms, Reports, Graphics, Developer,
Jdeveloper on this list because this is a DBA list.
It doesn't mean that the list members become annoyed when people ask
questions not directly related to DBA work. In fact, sometimes I wish there
were more answers
Hi,
I was wandering if
anyone has any experience of updating and inserting records in a SQLserver
database from Oracle?
Someone has
mentioned DB links to me but I'm not convinced.
The reason being
that I have a back office system with oracle as the database and a third party
system
It is an strictly listener's error. Often related to
ipc address of listeners. However try increasing the
queue size of the listener. You need to stop the
listener to do this.
Regards.
--- Dash, Saroj (CAP,CEF)
[EMAIL PROTECTED] wrote:
Hello All,
I am getting ora-12542 error while
Hi,
I'm joining a table with 32000 rows with a very large table (3 Gb),
resulting in 97000 records. When I execute the query without hints, it uses
a full table scan and a hash join, and returns a result in 4 minutes. When I
use a hint forcing a nested loop (and part of an index (range scan)),
The 3 numbers are the average number of processes in the run queue
over the last 1, 5 and 15 minutes. For a process to be in the queue, it
must be ready to run, but not actually on the CPU. If the system is
swapping lots, that means that the io wait time will be high. If I
remember correctly, if
Those sound like SSADM artifacts - try searching for SSADM Version 4
on Amazon.
g
-Original Message-
Sent: Wednesday, August 22, 2001 7:26 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am looking for some examples of DFD(data flow diagram), BPM(business
process module), and
Title: RE: ORA-12542 Problem !!
Saroj
I am trying (but failing) to see how you get that message when using sqlloader?
Can you expand please
John
-Original Message-
From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]
Sent: 23 August 01 12:35
To: Multiple recipients of list
We really need more details about the data
and the query to give you the 'correct' answer.
But let us assume that the 97,000 result rows
joining one row in the large table to a related
parent row in the smaller table.
If you index to find those 97,000 rows - with
a perfect index, not a range
Hi,
AFAIK
It does the index range scane 32000 times, whereas the hash join reads both
tables just once.
Jack
Daemen,
Try local exception processing:
LOOP
begin
your PL/SQL inside the loop
EXCEPTION WHEN your_exception THEN
do your processing
end;
END LOOP;
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Thanx Jonathan,
I was assuming that more reads could be done in 1 second. I'll try sorting
the data based on the index to speed up the query.
-Oorspronkelijk bericht-
Van: Jonathan Lewis [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 23 augustus 2001 14:21
Aan: Multiple recipients of
But I really would like to know 'how' important
is an ERP DBA and 'how much' does he NEED to know..?
It depends on the company.
I have seen some places where the ERP DBA just deals with administering the
application and some that are also responsible for all the system DBA work also.
2:42AM? $2/pint night must have been a success :)
From: Paul Drake [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Installing 73 and 816 on one NT server?
Date: Thu, 23 Aug 2001 02:42:26 -0800
Denham Eva wrote:
Hi
Jonathan,
OK, what am I missing? All of the PX sessions have to
access the segment header in order to get blocks off
the free lists so can't that result in buffer busy
waits on the segment header unless it was created with
more than one free list group?
-- Anita
--- Jonathan Lewis [EMAIL
Paul,
No it's more like, Hey, I heard there is a new version of the database
out, do we have it yet? Why not? Can we have it? Yeah let's do it, that
would be cool. Oh and by the way I installed a beta service pack on my
machine, that's ok right?...crap like that:)
KK
-Original
Here is a strange problem. We recently upgraded our Coldfusion Server
from 4.0 to 4.5. Under 4.0, CF used the date format from Oracle and we
had no problems; however, since upgrading to 4.5, the problem is that
insert and update of date fields from CF are correct (we verified using
SQL*PLUS);
Leo,
Include a sub-block within the main block and include exception handling in
the sub-block. The sub-block will contain the code for which you want to
trap the error and continue/fail:
begin
for c_rec in (select ename, sal from emp) loop
begin
insert into foo (ename, sal)
In which order did you install them? I believe you would have to install 7
first into the default home(Orant) and then install 8.1.6 into a different
home, like ora816.
KK
-Original Message-
Sent: Thursday, August 23, 2001 3:40 AM
To: Multiple recipients of list ORACLE-L
Hi Gurus,
I
Hi,
We need to disable PrintScreen key on Oracle Forms/Reports. Does anyone
know how to setup this in Oracle Terminal ??
TIA,
Antonio Belloni
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
I suffered from similar problems. Most of them using a
bad X terminal or from console. However I managed to
install from an X terminal using XDMCP and it works.
Even you don't have any pointing 8.1.5 try to remove
all the files from the OraInventory.
Regards.
--- Dharani Ravi [EMAIL PROTECTED]
Paul,
Do you mean that support for 8.1.6 ends in October?
KK
-Original Message-
Sent: Thursday, August 23, 2001 6:42 AM
To: Multiple recipients of list ORACLE-L
Denham Eva wrote:
Hi Gurus,
I have annihilated our test system trying to achieve this. Does anyone
have
any
How many copies of jre.exe should be running on an iAS 1.0.2.2. server?
My server has four copies running, and the HTTP server NT service refuses to
start.
I am wondering whether I should shut down all the Oracle Web-related
components, kill.exe any remaining jre.exe processes, then start
The original comment was about PQ
slaves reading data blocks - not
PX slaves running parallel update/inserts.
When PX slaves do parallel inserts the
processing is usually split to avoid
contention - e.g. each slaves gets
one partition of a partitioned object;
or each slave gets a new extent
yep -- check metalink... 8.1.6 is desupported as of October. no new releases
From: Kevin Kostyszyn [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Installing 73 and 816 on one NT server?
Date: Thu, 23 Aug 2001 05:52:53 -0800
I'm sorry to say that I can't tell you whether or not that is normal
behavior, because I just don't know. But one thing that I CAN say is
this...count your blessings that you're not running iFS...that thing runs
like 8 different instances of jre.exe on average. It's crazyyou need a
pretty
I know this is a really stupid and lazy question, but where do I find this
on metaslack? I am looking now and can't seem to come across it?
KK
-Original Message-
Carmichael
Sent: Thursday, August 23, 2001 10:42 AM
To: Multiple recipients of list ORACLE-L
yep -- check metalink... 8.1.6
Oh great!:)
-Original Message-
Carmichael
Sent: Thursday, August 23, 2001 10:42 AM
To: Multiple recipients of list ORACLE-L
yep -- check metalink... 8.1.6 is desupported as of October. no new releases
From: Kevin Kostyszyn [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple
I think that is absolutely the problem Denham. I had the same problem at
home. 8.1.6 was loaded and I needed to add 7.3.4 so I could test something
for work. Blew away my 8.1.6.I reinstalled in order of version , and
all worked fine.
-Original Message-
Sent: Thursday, August
Title: RE: OT - Vaccines
Amen.
btw,
some other "authorities" don't think vaccines had the played the sole, or even
majority role, in
disappearance or "de-virulence" of a given disease.
Read,
for example "Evolution of Infectious Diseases" by Dr. Paul Ewald.
He is
a professor at
How
many angels can dance on the head of a pin?
And
what is the sound of one hand clapping?
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001
10:53 PMTo: Multiple recipients of list ORACLE-LSubject:
w2k db connections... shudder
Title: Message
Take a look at www.vampired.net under scripts and locks,
there are a few decent scripts there.
"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:
its in the box on left called product lifecycle and then when that window
comes up, at top is desupport notices.
hth, joe
PS: here is the specific doc id: 123178.1
[EMAIL PROTECTED] 08/23/01 11:00AM I know this is a really
stupid and lazy question, but where do I find thison metaslack? I
Hi Denham,
A word of warning: We used to have an app that used an Oracle 7.3.4 DB on
NT 4.0 SP5. After the *second* datafile corruption in less than a month, we
moved the DB to OpenVMS where it happily lived out it's usefulness. (Thanks
to a proper setup, we were able to completely recover in
left side bar has product lifecycle when you click on that, there are
tabs product availability, certifications, desupport notices and alerts
it's under desupport notices
From: Kevin Kostyszyn [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
Hi,
I'm trying to figure out if there is any way to lower the highwater mark for
a locally managed temporary tablespace (the kind that shows up in
dba_temp_files) so I can shrink one of the datafiles.
Couldn't find any references on metalink but that might be because I have a
bad cold right
Leo:
Just nest your PL/SQL command inside a BEGIN...END block that has a
WHEN OTHERS THEN NULL statement in the EXCEPTIONS block. You can
nest PL/SQL to a surprising depth.
This example is pseudo-code:
BEGIN
LOOP
BEGIN
PL/SQL Statement(s) that may throw an exception;
Anyone who can help,
I've been asked if Oracle can somehow audit the DBA ie. Raise an alert if
the DBA were to execute DML statements against sensitive tables, this
assumes the DBA has the SYS password. I thought this was a pretty
reasonable question but couldn't think of an answer. My trail
Rich, What was the disk, controller, and RAID vendor?
hw or sw raid?
who did volume mgmt?
what the corruption hard or soft?
why on SP5 vice 6a?
thanks.
hope your luck holds!
Ross
p.s. funny you put it on OpenVMS. The lead OS architect
for VMS was a key player in NT development. small
This becomes rather easy with some naming standards in place.
We define Volume Group Name that represents a set of disks in it (d01vg,
d02vg..)
The Logical Volume names contain the lower case sid name, a portion of the
mount point directory name and a portion of the VG name.
These two things
Hannibal,
I wouldn't have thought that you fell under that category - common man
?!!? Surely people that enjoy a bit of homo-sapien meat from time to time
are not all that common at all? :^P
Dorothy
-Original Message-
Sent: Thursday, August 23, 2001 16:16
To: Multiple recipients of
Morning All;
Does anyone have some hints on how I might be able to print the results of
a PL/SQL procedure to a HP Printer on UNIX (Oracle 8.1.7/HP-UX 11.0)?
My first thought would be to use utl_file to create the file, but (not
being a developer), I'm not sure how to embed the printer strings
Hello listers,
I have got two options in order to upgrade/migrate my RDBMS from 8.0.6 to 8.1.7.
The first one is by using the migration tool. The second one and more interesting is by
using exp/imp.
I don´t like the first option because it doesn´t help me defragment the database. I
like the
Click on Product Lifecycle on the side then Desupport Notices toward the top
-Original Message-
From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Installing 73 and 816 on one NT server?
Unfortunately I'd want to simply prevent the users from connecting in the
first place. I don't think it would go over too well if they could connect,
and then get bumped out 2 minutes later.
-Fred Smith
From: Nick Wagner [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients
Title: Message
Thanks Christopher. I will see
what I can get out of them.
-Original Message-From: Christopher Spence
[mailto:[EMAIL PROTECTED]]Sent: Thursday, August 23, 2001 10:24
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
Locking Issue
Take a look at
Thanks all:)
KK
-Original Message-
Sent: Thursday, August 23, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Click on Product Lifecycle on the side then Desupport Notices toward the top
-Original Message-
From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]
Sent:
This has been discussed before, I'll try to summarize it as I remember.
Sure, you could put triggers, turn on auditing, whatever. But the DBA
by nature of his job function, can disable, remove, whatever you turn
on.
So it basically comes down to trusting your DBA, or getting a new DBA.
Dear list !
I've got an OPS database named OPS with 2 instances OPS1 and OPS2 .
I want the clients to connect to the instance OPS1 and , if OPS1 becomes
unavailable , to connect to OPS2 .
The Oracle version is 8.0.5
I put the following lines in clients' tnsnames.ora file :
OPS.world =
Oh hell, if you don't trust him, just fire him, not the trigger.
-Original Message-
Sent: Thursday, August 23, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Anyone who can help,
I've been asked if Oracle can somehow audit the DBA ie. Raise an alert if
the DBA were to
you'd better audit changes to the trigger, and then changes to SYS.AUD$
otherwise the DBA could disable the trigger, make the changes and re-enable
it
From: Dave Leach [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: How do
Dave,
Your question is somewhat puzzling. Anyone with DBA privileges can get to
any table they want since the DBA role contains the 'select any table', 'update
any table', 'delete any table', and 'insert any table' system privileges. You
would not require the sys or system passwords to
Hi Again DBA's
We are running Oracle 8.0.5 on NT 4.
I read that Oracle is implemented as one multi-threaded process on NT.
I observe two ORACLE80.EXE proceses running in the Task Manager.
There are also two STRTDB80.EXE processes running as well.
Does the number of ORACLE.EXE processes represent
Okay, I know some of you are going to call me crazy but here goes...
**We're now using 9i in Production**
There, I admit it. But I have to ask you this- do you think 9i will be more
buggy than the 8.1.6 that we were running that was causing core dumps,
referential integrity violations, etc.?
I got the answer for the problem I was having. I am including the following
solution for the sake of the users like who may be having same problem.
After setting up the following environment, following is the steps to
compile any proc program ( ex. my_test.pc).
1 Copy the
Good for you, David. We are moving in that direction, too. I convince
people by saying 9i is really 8.2.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 23, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Okay, I know
If you don't trust the DBA then fire him!
DBA has access to do everything including the audit records which he/she can
modify easily!
Waleed
-Original Message-
Sent: Thursday, August 23, 2001 12:52 PM
To: Multiple recipients of list ORACLE-L
you'd better audit changes to the trigger,
I like to know if it is possible, from an on-login trigger, to fire an
applet on the client machine that will open a browser window and direct
that to a particular URL? It doesn't necessarily have to be an applet,
just any mechanism that will automatically direct the client to a
particular URL,
Hi Ken,
Try revoking the connect permssion from the users you want to restrict . But the user will not be able to connect to database using sqlplus also.
HTH.
Jyoti
From: "Fred Smith" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
I can't revoke connect permissions. I am simply looking for a way to
prevent users from connecting via TOAD. They need to still be able to
connect via the application and sqlplus.
Any ideas?
From: Jyoti N [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Waleed,
Regrettably in our 'legalistic' world this is not possible if all you have
is a suspicion, you need facts to back them up. And getting facts in this case
can be very difficult at best. What could be a solution in this case is that
someone has a suspicion that this person is
you are crazy :) but i like it anyways.
since i'm running it on a non -supported platform anything i find wouldnt
be any good anyways :)
we'll look forward to you sharing your experiences :)
joe
[EMAIL PROTECTED] 08/23/01 12:40PM
Okay, I know some of you are going to call me crazy but
I think i see where this thread is going.
You'd better audit change to the trigger that audits changes to the data
that
audits the DBA that you don't trust.
Maybe throwing another trigger at it will help?
Maybe installing a 24x7 DBA-cam above his cube?
Maybe feeding him a higher grade of
'..fire him, not the trigger.'
ver-y clever.
-Original Message-
Sent: Thursday, August 23, 2001 9:47 AM
To: Multiple recipients of list ORACLE-L
Oh hell, if you don't trust him, just fire him, not the trigger.
-Original Message-
Sent: Thursday, August 23, 2001 11:56 AM
To:
I am not going to say anything. That's cool, you'll find all of the bugs
and report them back to us:)
hehehe...whoo ho!!!
Just kidding Dave, good luck!!
Kev
-Original Message-
Wagoner
Sent: Thursday, August 23, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Okay, I know
Hello,
has someone already started a silent/unattended distribution of Oracle
(client) software, i.e. net8 client and ODBC/OCI?
All I can find in metalink is the information that response files are now
used for silent installation.
How are the steps (8i/NT)?
- modify a *.rsp template (which?)
OS: NT 4.0
I have scheduled a query against a database that pipes results to a log
file.
Ex. Select * from any_table; logfile.txt
Since I need a trend on this query I need to keep the logfile names unique.
Best case scenario is to append a date/time stamp to the logfile name as in
but the banner says 9.0.1 :)
joe
[EMAIL PROTECTED] 08/23/01 01:27PM
Good for you, David. We are moving in that direction,
too. I convincepeople by saying 9i is really 8.2.Paul
BaumgartelMortgageSight Holdings,
LLC[EMAIL PROTECTED]-Original
Message-Sent: Thursday, August 23, 2001
IIRC, Oracle uses one of two methods for authentication into the DB;
either Oracle-specific passwords, or OS ones. I was wondering if it is
possible to write a custom authentication method to use 3rd party
authentication methods, and if so, where I would look for information on
this (books, URLs
Write a letter to the IRS stating that he did not report
all his income last year. They will be happy to audit
him.
Ken Janusz, CPIM
I think i see where this thread is going.
You'd better audit change to the trigger that audits changes to the data
that
audits the DBA that you don't
Yup, sort of. I am sure someone will correct me if I am wrong, but on NT
that is a little tricky. The NT service for the Oracle db could start and
it will appear. However, if you didn't start it with server mangaer the db
might not actually be open if there were errors. Although the process
1. I have a full export dump, I know the objects owned by sys are not
exported/imported. What happens to the objects owned by system?
Listers, please correct me if I am wrong here, but that's not my understanding. I have
recreated a complete database from a full export in the past and the 8i
DBA-cam now there's a kewl concept :)
Then we can see what the goddess's desk looks like.
Whether Lisa looks like Laura or not, etc.
This has serious potential
joe
[EMAIL PROTECTED] 08/23/01 01:11PM
I think i see where this thread is going. You'd better
audit change to the trigger that
David,
There are a number of different ways to do it. One method I use is to
define the codes in the package header
ie: FONT_COURIER10 varchar2(15) := chr(27) || '(s0p10h12vsb3T'
Then, in the package body, when I want to print a special code I either
use utl_file.put() or
LOL!!! The IRS Audit trigger! New in Oracle 10i!!!
-Original Message-
Sent: Thursday, August 23, 2001 2:23 PM
To: Multiple recipients of list ORACLE-L
Write a letter to the IRS stating that he did not report
all his income last year. They will be happy to audit
him.
Ken Janusz,
Hi.
I would highly recommend the book (its my current train reading)
Oracle Net8 Configuration and Troubleshooting
By Jonathan Gennick and Hugo Toledo - O'Reilly
January 2001
Chapter 8 - Load Balancing and Failover covers this subject in detail for
Oracle 8.1.6.0.0.
You can specify that the
Look into product user profiles.
[EMAIL PROTECTED] 08/23/01 01:42PM
I can't revoke connect permissions. I am simply looking for a way to
prevent users from connecting via TOAD. They need to still be able to
connect via the application and sqlplus.
Any ideas?
From: Jyoti N [EMAIL
Nope, NO SYS objects are exported during a full export,. recreate the
database then run full import.
joe
[EMAIL PROTECTED] 08/23/01 02:00PM 1.
I have a full export dump, I know the objects owned by sys are not
exported/imported. What happens to the objects owned by system?Listers,
please
Chuck,
It's doable, and I've seen scripts on the net that do it, but it's a
bit cumbersome. However, you could also do it in sqlplus,
using spool, where the name of the spool file is taken from a
new_value of a date query, i.e.,
col x new_value fn
select to_char (sysdate, 'DDMMHHMI') ||
1 - 100 of 195 matches
Mail list logo
