Hamid,
You can take a regular table and partition it where it sits.
You don't have to create a new partitioned table and
copy the data into that.
Cherie
Ham
So far I have tried all of the following to stop sending standard output to the
log file and start sending it back to the screen:
exec > db_heartbeat.log 2>&-
db_heartbeat.log >&-
2>&-
exec > db_heartbeat.log >&-
>&-
exec 2>&1
exec 2>&-
None of them worked.
Tom
Tom Terrian
Oracle DBA
WPAFB - D
I was wondering how to do that. My way of doing it was to surround a block
of code with a while loop and redirect the contents of the fake loop.
while (( 1 = 1 ))
do
code here
break
done > script.log 2>&1
cat script.log
In regards to your actual question I think you have to explicity redir
Its supposedly the terminal patch, so yer guess is as good as mine. Of
course, v10.3 will solve world hunger...
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Jesse, Rich [SMTP:
[EMAIL PROTECTED] wrote:
>Here is a good one for you, I have been doing something in my korn shell scripts
>which I really never understood and now need to change. :-)
>
>I have the following line that sends the output from the shell script to a log
>file:
>exec > db_heartbeat.log 2>&1
>
>At the
Thanks, Michael and Jared for the scripts. I really appreciate the help.
Kirti thanks for the metalink references for figuring out the reason the
database shutdown was hanging. I still have not finished processing all the
information I have received. However I will do so and let you all know what
Here is a good one for you, I have been doing something in my korn shell scripts
which I really never understood and now need to change. :-)
I have the following line that sends the output from the shell script to a log
file:
exec > db_heartbeat.log 2>&1
At the bottom of my shell script I now w
Jay - Thanks for looking this up. This note includes the statement: "There
will not be support for prior to EV56 generation Alpha Tru64 UNIX", which
implies that EV56 IS supported. Compaq also lists EV5.6 as supported for
8.1.7. Now, if I could just find someone that has installed there. How about
Here's a Korn Shell script that I use to identify all of the top CPU hogs in
Solaris. It is better than "top" because it gives you the actual command
that is running:
#!/bin/ksh
# Show the PS version of the top 37 processes (by CPU usage)
print "UID\tPID\tPPID\tSTIME\t\tTIME\tCMD"
top -n 37 2>
Thank you. :)
Jared
××ר ××××× <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/22/02 05:30 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Yet Another Off Topic Discus
This link may be useful:
http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=131865.1&blackframe=0
Jared
Pat Howe <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/22/02 08:10 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Yup. That's the number. Looks like it is there for most platforms. Now what I can't
find is the
Applications Inter Op patch for 8.1.7.3 and Apps 11.5. For those who know what I'm
talking about
and have happened across the number, would you let me know...
Thanks,
Ron Thomas
Hypercom, Inc
[E
CTRL-ALT-DEL ? ;)
But seriously, NT will not let you delete the file if it is open.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/22/02 06:10 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:
not that I've ever seen
--- John Dunn <[EMAIL PROTECTED]> wrote:
> Do values in sequences get decremented when a rollback is issued?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dunn
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (8
Cheri,
Just wondered even when you have a table with data still you can partition
it or you have to create a new table with partitioning and load the data
from old to new one. Is it right or not?
-Original Message-
Sent: Tuesday, January 22, 2002 8:10 AM
To: Multiple recipients of list OR
You should in test env before changing the optimizer
through intensive benchmarks. However, if you are
working with 8i, try with outlines. Consider changing
to first_rows and evaluate the set of
optimizer_index_caching, optimizer_index_cost_adj and
optimizer_max_permutations.
Regards.
--- Shaw
Check if there are some cache buffer chains contention
through v$session_wait and v$latchname. Maybe some
sqls have changed their plans. Because of index
dropped or change of code.
Regards.
--- Uma Mohoni <[EMAIL PROTECTED]> wrote:
> Yeah there was a sudden burst of activity in data
> insert, u
This query will show current sessions CPU usage. It may
indicate a particular session is hogging the CPU.
select
sess.username,
stat.sid,
name.name name,
sum(stat.value)/100 valuesum_seconds
from v$sesstat stat, v$statname name, v$session sess
where
stat.sid = sess.sid
and stat
Sorry Ian for the incorrect information. This behavior will be fixed in 9i
R2 (whenever that is) according to Bug# 692232.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is
sort of on the subject.I once had a table with ~88000 extents (most 1
block!)
it took 8 hours to delete and a subsequent coalesce ran for 2 hours before
failing as it ran out of shared memory(8.1.5).
-Original Message-
Sent: Tuesday, January 22, 2002 11:55 AM
To: Multiple reci
"We didn't have any problems with this application until you guys started
writing reports".
gotta-love-it! it is one of the all-time best I've ever heard.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, January 22, 2002 11:47 AM
To: Multiple recipients o
Will this suit your needs?
SET SERVEROUTPUT ON FORMAT WRAPPED SIZE 100
DECLARE
CURSOR c1 IS
SELECT custid, software
FROM customer_software
ORDER BY custid;
idNUMBER;
swVARCHAR2(15);
outputVARCHAR2(100);
temp_id NUMBER;
John,
Unfortunately, no. Sequence increments are considered DDL, thus are not
"rollback-able".
Create a test sequence and try it!
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, January 22, 2002 12:11 PM
To: Multiple recipients of list
At least now you can go with CHOOSE instead of strictly cost based. Its
a much smaller plunge, you can pick and choose which objects to try
first.
-Original Message-
Sent: Tuesday, January 22, 2002 12:06 PM
To: Multiple recipients of list ORACLE-L
I have a large app that is still ru
HI
There is no direct way in Oracle for Export to use a
particular rollback segment.
But you can use the following trick to assign export a
particular rollback segment -
1) Create a rollback segment tablespace with one large
segment and bring it online before export.
2) Offline all existing ro
[EMAIL PROTECTED] wrote:
>Do values in sequences get decremented when a rollback is issued?
>
no, if they did you'd end up with two sessions grabbing the same number.
--
--
Bill "Shrek" Thater ORACLE DBA
[EMAIL PROTECTED]
---
HI Seema,
Export is reading the data from the oracle database and writing it to an
associated binary file. It only uses rollback segments to provide read
consistency of data blocks being read. This will need to use whatever
rbs's have been assigned to the blocks we are reconstructing.
Hop
Hi List,
We are running oracle 8.1.6 on unix I want to upgrade it to 8.1.7 , What
exactly I have to do where can i find the upgrade patch.
Is there any where to look step by step procedure.
I am not very familiar in this upgrade area specially in unix.
Hamid Alavi
Office 818 737-0526
Cell8
Yeah there was a sudden burst of activity in data insert, updates and
deletes over the weekend as a result of a new app module being tested. But
the client app uses Java code and is not in the database. So its nothing I
can ask them to remove. On the other hand sudden bursts of data activity is
so
Hi
Can I use one rollback segment at time of export?Is yes,then
SET TRANSACTION USE ROLLBACK SEGMENT rollbacksegmentname;
Thx
-seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the offici
Do values in sequences get decremented when a rollback is issued?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet ac
I have a large app that is still running rule based, we are finally going to
take the plunge and try to start going cost based. The first time we tried
this the performance was terrible in a lot of places. Does anyone have any
good white papers or hints/tips on what to look for on areas that migh
In Oracle 8.1.6 using autonomous transactions with a distributed query results in a
7445 error and a core dump. In 8.1.7.1
the error is trapped, reported ( I forget the error number, and no corp dump occurs.
I don't know if that's what "fixed" means. Unless there was an additional fix in
8.
And it supposedly fixes the ORA-7445 errors with CURSOR_SHARING=FORCE!
Woo-hoo!
Of course, what does it *break*?
install patch
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
[
AIX 4.3.3 ML8 comes w/ topas, better than top! But I still prefer SUN or HP over IBM
or DEC. Those were the days, when OpenVMS clustering worked :)
Gene
>>> [EMAIL PROTECTED] 01/22/02 10:00AM >>>
The top for Sun is not as good as the top for HP IMO.
-Original Message-
Patrice J
Sent:
HI Dennis,
The er diagram being generated should contain the attributes associated
with an entity and the business rules that affect the attributes and the
relationships between entities. If they are in fact
"real business rules" then we have no choice but to enforce these rules.
The only q
I just found out that its SMON.
-Uma
-Original Message-
Sent: Tuesday, January 22, 2002 11:32 AM
To: '[EMAIL PROTECTED]'
Cc: Uma Mohoni
Uma - Can you identify which Oracle process is using the CPU?
-Original Message-
Sent: Tuesday, January 22, 2002 9:20 AM
To: Multiple recipi
According to this note, EV5.6 and 8.1.7 do not work together:
Note:87.1
Oracle RDBMS 8.1.7 will NOT run on EV5 or earlier systems
-Original Message-
Sent: Monday, January 21, 2002 7:22 PM
To: Multiple recipients of list ORACLE-L
We are trying to install Oracle 8.1.7 on Compaq Tru
Hi Jeremiah,
The problem arose in the catalog upgrade script. It would never
return. My diary says we let one attempt run for 36 hours. The process
showed CPU usage and I/O but nothing happened. Some of the Oracle guys
figured the problem was with the $fet (or whatever tables hold the
ex
Uma - Can you identify which Oracle process is using the CPU?
-Original Message-
Sent: Tuesday, January 22, 2002 9:20 AM
To: Multiple recipients of list ORACLE-L
Hi,
I would like help with this problem I am grappling with since yesterday. One
of the test boxes with Sun Solaris 2.7 OS a
You need to have the auxiliary database started nomount. All you need is the init.ora
to do this. The duplicate will create the control, data, and redo log files.
Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA
>>> [EMAIL PROTECTED] 01/22/02 09:20AM >>>
Hi All,
Trying my
You get a similar error on NT when the jre is installed somewhere other
than the system partition. Don't know how that applies to Unix, but
maybe there is an environment variable or path that needs to point to
the jre?
-Original Message-
Sent: Tuesday, January 22, 2002 9:26 AM
To: Mult
Can you post the 'revised' script?
- Kirti
-Original Message-
Sent: Tuesday, January 22, 2002 8:20 AM
To: Multiple recipients of list ORACLE-L
You are correct but that is not where I am getting the ORA_000904 Invalid
Column Error. That was a typo on my part because I originally had
If anyone knows of an "RMAN Best Practices and/or Configuration" document I
would be interested in seeing it.
I am about to set up RMAN within our division and would be interested to
know how others have configured RMAN at their shop.
I know from experience that after I have implemented something
I have installed 8.1.6 and 8.1.7 on Tru64 5.1. I do not have /cdrom/bin/jre on the
8.1.7 cd.
which jre returns:
/usr/bin/jre
> ls -al /usr/bin | grep jre
lrwxrwxrwx 1 root system22 Mar 13 2001 jre -> ../opt/java118/bin/jre
lrwxrwxrwx 1 root system27 Mar 13 2001 j
Use SELECT TO_CHAR(sysdate,'MM/DD/ HH:MI:SS FROM dual;
Rick
Roland.Skoldb
Cherie,
We used the data volume and performance criterion while deciding to
partition our tables. One of the major tables had grown over 100Mil rows and
had 4 indexes. All tables had 4 digit YEAR field and most queries used YEAR
in them, so it was a no-brainer. A few important queries were modifi
Hi,
Has anyone run into this error. I had an 8.1.6.3 database on Solaris hang
and found hundreds of waits in v$session_wait. I also found the following in
the alert.log:
Dumping the buffer at level 8 instead of level 0
For full buffer dumps enable the following named event
alter session set ev
Real easy - Precreate your DB on UNIX. Create tablespaces, datafiles,
rollbacksegs. Export from NT (sorry, W2K), import to UNIX.
We've got a student app the vendor swore would run ONLY on a W2K Oracle DB.
Have written web apps for the schools to access/generate reports. Ran out
of space, mov
[EMAIL PROTECTED] wrote:
>On Monday 21 January 2002 19:35, Deshpande, Kirti wrote:
>
( list owner, baby sitter and part time DBA )
>>Jared, What happened to that Perl thingy ??
>>
>
>Oh, I guess I felt that somes folks thought it pretentious, and
>others thought I was some kind of open
I found the 32 bit version of 8.1.7.3 for HPUX on Metalstink. Unless its
mislabled. Patch#2189751. See below:
List of selected patches
ID:1335298 Patchset::2189751
README
8.1.7.3 PATCH SET FOR ORACLE DATA SERVER
Pro
Hamid,
Would you be willing to forward a copy of
this paper?
Thanks,
Ross Mohan
-Original Message-
Sent: Thursday, January 17, 2002 12:27 PM
To: Multiple recipients of list ORACLE-L
Hi List,
I have a white paper for Backup Strategy on Microsoft NT but I am looking
for Backup Strate
The top for Sun is not as good as the top for HP IMO.
-Original Message-
Patrice J
Sent: Tuesday, January 22, 2002 4:40 AM
To: Multiple recipients of list ORACLE-L
The sa's here installed "top" on all the solaris servers.
It's not bundled with the OS but it is available as solaris free
Has there been any changes in the applications? I had someone put in new
code this weekend and it sent my CPU up over 80%. When I saw that Monday
morning, I had the developer take the code out and my CPU dropped back down
to around the 5 - 10%. From my little experience I have quickly learned
t
Roland,
Read docs on 'autonomous transactions'.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, January 22, 2002 4:00 AM
> Anyone who can help me with this:
>
> I have 3 procedures which run one
Stephane,
Thanks a lot for you answer. It's a legacy database. They chose IOT.
The performance is terrible. So I came up with the idea of partitioned IOT. The
problem is I still quite confused that why query only one partition took more
time than query the whole IOT. From the plan the
Moses - no clues. There is no bin or JRE on the CD-ROM. The installer has
its own Java environment. One thing you might try is to copy the contents of
the CD-ROM to disk and run it from there. HTH
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, Jan
Agree on both counts. The simple solution, which I believe is stated in the
Oracle Concepts manuals is that all foreign keyed columns should also be
indexed. A step sadly not taken in this particular case. Love it when you can
make a simple suggestion & fix the problem!!
Dick Goulet
_
Hi,
I would like help with this problem I am grappling with since yesterday. One
of the test boxes with Sun Solaris 2.7 OS and Oracle 8.1.7.2 on it has
started showing 97% and above CPU usage mostly by Oracle . It has slowed
down the application to a point where the testers can not test. Does any
Hi All,
Trying my first attempt to clone a database using rman and ending up with
errors.
Situation:
TEST1 database = catalog Status=OPEN
TEST2 database= target database and to be cloned status= OPEN
TEST3 database= future clone of TEST2 status = NOMOUNT (as per docs)
I have all sorts of back
On Monday 21 January 2002 19:35, Deshpande, Kirti wrote:
> >> ( list owner, baby sitter and part time DBA )
>
> Jared, What happened to that Perl thingy ??
Oh, I guess I felt that somes folks thought it pretentious, and
others thought I was some kind of open source demon hacker
from hell. ;)
M
Craig - Thanks for mentioning this J2EE fact. Currently the developers are
using JDBC, but we are trying to decide if we should move up to J2EE. I
spent this weekend reading "Java Programming with Oracle JDBC" by Don Bales
which has just been published, ink still wet. Seems to be a good book, but
John,
I have only seen one situation where referential integrity has caused a
problem that the developer could not prevent. That case involved a foreign key
with the 'on delete cascade' option turned on and the key column in the child
table was NOT indexed. OH, BTW the child table was well
Title: Connect as sysdba on 9i
That
exactly connects you as SYS which u can check with SHOW USER
Just
my $.02.
Regards,
Sergey
Babich
-Original Message-From: eric harrington
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 22, 2002 8:45
AMTo: Multiple recipients of list ORACL
Hi Sergey !
I happened to run all of the aforementioned O/S (Solaris , HP-UX , AIX and
Linux) on most of the platforms.
in my opinion Solaris is far more manageable , documented , scalable ,
stable etc.. O/S than the others.
Sun boxes running Solaris have almost as many installations as all the
ot
Hallo,
How can I change this unixscript so if the PL/SQL procedure
konto.fillbilbotables.anrop;doesnt start for some reason, then I want a logfile to be
created in a directory.
2002-02-23starterror.log. The message in that logfile could be for instance "The
procedure didnt start today, some
Hi Dennis,
Agreed this was not the developers fault, it was the DBA's! I don't blame
this on RI being handled by constraints, but on a DBA that doesn't understand
the consequences, the resulting table level lock could have also been a problem
:-).
BTW, if RI had been handled via the appli
Q$INSTL is a package Savant uses to monitor the database. Drop the
schema from your database and resend your client an export.
http://www.savant.com/products/diagnostic.asp
Todd Carlson
Oracle Database Administrator
Tripos, Inc.
(314) 647-8837 Ext.3246
-Original Message-
Bootsma
Sent:
Cherie,
I use the row count ,table size, and comonality method to determine
which tables to partition. The majority of our data is DATE driven both
in the record and the query so I partition the tables by date range
using the date range most commonly queried. The limits of the OS and
datafile siz
Hi
Do'it the follow steps :
sqlplus /nolog
SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jan 22 15:23:12 2002
(c) Copyright 2001 Oracle Corporation. All rights reserved.
SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
Regards
Rudi
Original Message
Von:
why not just rename the log file after the script runs?
--- [EMAIL PROTECTED] wrote:
> Hallo all you gurus,
>
> Anyone who can help me with this:
>
> I have this unix script: In the script I wamt to create a logfile
> for every day that I run this script so that thel logfile will look
> like:
Jared - Ooh . . ooh . . that last point really grabbed my interest! The part
about "kept the RI overhead low was that all transactions tables had
surrogate keys generated from a sequence". Can you (or anyone else on the
list) give me a reference that discusses this so I can go show it to the
devel
You are correct but that is not where I am getting the ORA_000904 Invalid
Column Error. That was a typo on my part because I originally had the
tables named 'a' and 'b' but renamed them for readability and I thought it
may correct the error.
It is occurring where I try to join the tables.
Log
Title: Connect as sysdba on 9i
Try:
sqlplus "/ as sysdba"
I suspect the /
indicates current OS user and if you belong to the SYSDBA or SYSOPER groups then
you will be connected. SYS is probably not a member of these
groups.
I haven't tested
this.
-Original Message-From: [EMAIL P
I am trying out an installation on Compaq TRU64 but cannot RunInstaller. It
says cannot find /cdrom/bin/jre. The CD is missing JRE files.
Any clues?
Moses Moya
-Original Message-
Sent: Monday, January 21, 2002 7:22 PM
To: Multiple recipients of list ORACLE-L
We are trying to install O
Cherie - This is an OLTP application. I haven't received the schema yet. The
performance goal is a good question, and I will ask it to the group when I
find a good opportunity. Basically, they are looking for "reasonable"
response times for on-line users.
The development manager keeps sayi
While the damage here has already been done, it should be a point of caution for
us all. I make a point of dropping the tablespace in Oracle first followed by
judicious use of the 'fuser' command in HP-UX to see that all processes have
released the file. Now you know it's deletable. BTW: anyone
that will merely tell you the object exists and that it is either valid
(cleanly compiled) or invalid (needs recompilation)
--- Sinard Xing <[EMAIL PROTECTED]> wrote:
> Hi,
>
> You can do
>
> Select object_name, object_type, status
> from dba_objects
> where object_type like '%PACK%' or
>
Thanks,
and can you please tell me how to get hold of the time when the procedures starts and
finishes.?
Thanks in advance.
Roland
"Pullikol Kumar" <[EMAIL PROTECTED]>@fatcity.com den 2002-01-22 04:40 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple r
Hi Dennis,
Just my opinion but I tried to follow these rules as a DBA.
1. If the business rule can be implemented with pk, fk, unique or check
constraints I do it as such
2. If the business rule can be implemented as a trigger I code it as a
trigger
3. If none of the above, I implement as
John - Thanks for your insights. I appreciate you final comment that you
haven't seen RI as the real performance problem.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, January 22, 2002 7:40 AM
To: Multiple recipients of list ORACLE-L
Hi Dennis,
Hello All
I am new to this list (only a few weeks).
I subscribed to this list and another one at the same time.
This list is a source of knowledge and fun and the other is just business.
This one is so much better.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message
Andrey,
I agree with Rachel. You need to fix this problem immediately. You are one
step short of a complete disaster-recovery scenario.
Your choices are:
Restore the database prior to when you deleted the data file and issued the
"drop datafile" command.
or
Export, drop the tablespace, and
I asked one of the SA's here, and he thinks the move to HP might be
political on Oracle's part.
I don't know how the HP - Compaq merger will go, that adds uncertainty.
Esp. since Compaq has traditionally been an Intel supporter and they gobbled
up Digital's Alpha technology.
Meanwhile Scott McNe
Thank you for your input.
Regards,
Sergey Babich
-Original Message-
Sent: Monday, January 21, 2002 4:55 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: HP vs SUN for a UNIX box
I have both Sun and HP boxes. IMHO for OS installation and hardware
replacement, Sun is
Title: Connect as sysdba on 9i
Ave
!
Try:
$
Sqlplus /nolog
SQLPLUS> connect / as sysdba
Br.Jorma
-Original Message-From: ext Daiminger, Helmut
[mailto:[EMAIL PROTECTED]]Sent: 22 January, 2002
14:05To: Multiple recipients of list ORACLE-LSubject:
Connect as sysdba on
hi Roland
Hope below code will help u,
BEGIN
p1;
p2;
p3;
p4;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END;
procedure p1
is
BEGIN
insert into aa values (1,'1');
END;
procedure p2
is
BEGIN
insert into aa values (2,'2');
END;
procedure p3
is
BEGIN
insert into aa v
Dennis,
How many constraints are you talking about? About how many constraints
per table?
What kind of app is it? OLAP? Data Warehouse?
What kind of performance requirements have been set?
Cherie Machler
Oracle DBA
Gelco Information Network
The sa's here installed "top" on all the solaris servers.
It's not bundled with the OS but it is available as solaris freeware.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services techn
Title: Connect as sysdba on 9i
Hi!
I have a question concerning "connect sys as sydba" on 9i.
When I open sqlplus and connect as sysdba (I'm logged in as the Unix oracle user):
sqlplus "sys as sysdba"
Oracle asks for a password. Even if I type in the wrong password, I
Title: RE: Re: How can I tell if a procedure/package is running?
Sinardy,
This only tells you if an object exists not if it is running - or even if it is valid unless status is elected from dba_objects as well.
There was a thread around 30/10/01 with the appropriate title 'How can I tell if a
Hallo,
anyone who can help me with a pl/sql procedure that
I have four procedures that will run one after one:
in an error table logs the procedurename, the start time of the procedure and the end
time of the procedure.the number of rows inserted(there are insertstatements in the
procedures),
Title: RE: Sqlloader
See the following note sent on 4/12/01 - it should assist
John
Try the following example:
TMD=`date '+%Y/%m/%d'`
TMS=`date '+%Y%m%d%H%M%S'`
sqlplus -s internal <
set verif off pages 0 echo off feed off term off lines 200
spool $SHELLSRCDIR/dbcontents.$TMS.
Hallo,
How can I change this script so if the PL/SQL procedure
konto.fillbilbotables.anrop;doesnt start for some reason, then I want a logfile to be
created on the form:
2002-02-23starterror.log. The message in that logfile could be for instance "The
procedure didnt start today, some problems
Hallo all you gurus,
Anyone who can help me with this:
I have this unix script: In the script I wamt to create a logfile for every day that
I run this script so that thel logfile will look like:
2002-02-22laddabsg.log
and when i run the script tomorrow I want it to be:
2002-02-23laddabsg.log
Anyone who can help me with this:
I have 3 procedures which run one after one.
Those 3 procedures does insert statements in tables in the database.
Can anyone give me a good example on how to write the code to trap errors when the
procedures fail.
I want to log in a table, the name of the proc
Hi,
You can do
Select object_name, object_type, status
from dba_objects
where object_type like '%PACK%' or
object_type like '%PROCE%'
order by 2,1;
Sinardy
-Original Message-
[EMAIL PROTECTED]
Sent: 22 January 2002 15:10
To: Multiple recipients of list ORACLE-L
Can anyone
Hi,
We have a batch running about 7 hours on our production system that is
on HP-UX and using OCI-calls to get data from a database thats on another
Unix-machine
This same batch is running on our development-system in about 1.30 hr.
I have run this batch on our production system this morning so
Anyone who can help me with this query?
I have a Microsoft routin, whic calls oracle procedure in database "servername",
which have a databaselink to other databases(located on computers with Linux
system).That procedure is supposed to pick up data from tables which exist in the
other
databa
99 matches
Mail list logo
