hi pals,
I defied my customer that this won't work,and thanks to you it worked!!
Now,I have to convince him that what I had said to him was wrong!!
thanks folks!
When Attempting point in time recovery :-
1) Let Control File Online Redo Logfiles be the Latest ( Current )
Ensure that you have WRITE Permission to the Online Redo logfiles so that In
case When the Database is Opened with RESETLOGS After Completion of Recovery
, the Online Redo Logfiles
hey dba ppl,
anyone had a problem with recovering a datafile?
Doesn't seem very hard if you have the archive log asked for... but what IF u
haven't?
running oracle 7.34 and 8.16 on ibm rs/6000
aix
thx for any help
REALLY IT WORKED???
HOW , CAN YOU WRITE THE SCRIPT..
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 10:50 AM
hi pals,
I defied my customer that this won't work,and thanks to you it worked!!
Now,I have
hello fellow dba's
we are currently running a project for updating our
database management tools. We want a pro-active and easy-to-use graphical tool
with a lot of possibilities ( db difference, performance manager, top sessions,
lock managers, ... ).
So i was wandering what all of you
You can lock a table with:
lock table scott.emp in exclusive mode
This should lock that table for the session you are in, not sure what
permissions you need for it though?
Mark
-Original Message-
Sent: Monday, February 12, 2001 07:31
To: Multiple recipients of list ORACLE-L
hi
Larry,
MetaLink doc 1057885.6 will be of interest to you regarding this message.
HTH,
Sean :)
Rookie Data Base Administrator
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
Organon (Ireland) Ltd.
http://www.organon.ie
E-mail: [EMAIL PROTECTED]
Hi Paul,
Thanks for sending the V$MYSTAT data offline.
Try this explanation ...
The first query is fetching all the rows using an array size of 15.
The V$MYSTAT data showed a difference of about 25000 'user calls',
and the 'SQL*Net roundtrips to/from client' data below matches that.
The number
but i did'nt find any bytes column in user_tables
analyzed table in compute mode..
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, February 09, 2001 9:05 PM
analyze the table in compute mode.
Then select bytes from user_tables where
Dear All,
In one of database the developer had deleted a table and
commited it.
database is in online backup but no export backup or table backup
Please tell me how can I recover the the table .
please guide me the exact detailed ed steps to recover the table .
We have online backup
To my
understanding,
Oracle
tools support for JSP, but applications developed in ASP do run on OAS
HTH!
Aleem
-Original
Message-
From: Eriovaldo do Carmo Andrietta
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001
5:15 PM
To: Multiple recipients of list
If you will get some material, please send to me
...
I am also interested to know about
this.
Eriovaldo do Carmo Andrietta[EMAIL PROTECTED]Widesoft Sistemas
Ltda.Limeira/SP - BrasilF. +55 19 451 6300ICQ #102604225
- Original Message -
From:
Sanjay
Sinha
To: Multiple
Hello list,
I know that the answer to my question its going to be a negative one,
but I have to try to do all that I can do.
Until yesterday I was doing some attempt with an Oracle installation,
without a backup copy. And, unfortunately, I had to format my computer
(!!!).
Now I have the data
Arun ,
Bingo , will Check for the Same using the Following SQL script :-
select b.sid,
substr(a.segment_name,1,25) OBJ_NAME,
a.segment_type OBJ_TYPE,
b.p1,
b.p2 BLOCKID,
b.p3 BLOCKS,
b.event
fromdba_extents a,
v$session_wait b
where b.p2 between
Kris:
There is no native way of doing this. You would need to write your own
data-access methods -- maybe a stored procedure that returns a ref-cursor.
The procedure would attempt to lock a table before performing the select.
The DML operations on the table would have to lock the same table
Hi,
Try restoring an old backup first. Make sure that the newest datafile is
older than the point you want to return to.
Than do your PITR again.
MAKE OFFLINE BACKUP FIRST BEFORE ANY CHANGES.
ANother option is to restore on a different machine, export the table and
import the table on the
Did you restore the data files from the last hot backup?
Praveen
"Dash, Saroj (CAP,CEF)" wrote:
Dear All,
In one of database the developer had deleted a table and
commited it.
database is in online backup but no export backup or table backup
Please tell me how can I recover the the
I am starting a Data Warehouse project, possibly using Oracle Warehouse
Builder. One of the databases that I must bring together comes from IBM
DB2 database. We have reverse engineered a piece of their database so that
we can produce an ER diagram so that we can start understanding their data.
Hi Folks,
I'm trying to find out the default "buffer" parameter size Export utility on
NT O.S., 8i Rel 3. The utility manual says see your Oracle operating
system-specific documentation which I have done, or at least I believe I
have covered all manuals, but to no avail. Anyhow, anyone know
As I have not received any response to my following message, I am posting it
again for UNIX GURUS..
My question ius whether is it possible to give name to export dump while
sending it directly to tape? If yes how
Thanks
Rafiq
Date: Mon, 12 Feb 2001 11:25:26 -0800
Hi,
Can somebody guide
Hi,
Has anyone seen database performance degradation by setting this to a high
value?
We set this value to 128 from the default value 4 and noticed a lot more
free buffer waits event.
All database writers (DB01-10) are waiting for Null Event. The
seconds_in_wait time from v$session_wait is
Hi Johan
Will this work ?
Person A books the product he wants with 'select * from t1 for
update'. At this point, he has lock on the row.
Person B comes in, looks at the product and does a 'select * from t1
for update nowait'
If the row is locked for update then person B will
You will have to use your last Hot Backup file set and
create a new database (use the alter database backup controlfile to trace
for the create db statement). Then apply all the arch. redo files since
THAT backup, UPTO the point before
the Table was dropped. Then extract the Table data and
Any system with online 'live' updates as opposed to saving up all the
updates and running them through a batch process
would be considered an OLTP application.
Ron Smith
Database Administration
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13,
Title: Oracle 816 on linux
Recompiler Kernel withnew values in
semaphores. (values is in technical notes)
The Red Hat 7.00 not recompiler Kernel.Have a
bug.
Recomended RedHat 6.2 Kernel 2.2.14 or
2.2.16, this Kernel recompiler an works fine with Oracle 8.1.6 or
8.1.7
- Original
As was pointed out to me a few weeks ago, this info is in Oracle8 Reference
Release 8.0 A58242-01
TX, Transaction
Not sure about the others. They are not in my manual (8.0.x)
John
-Original Message-
Sent: Thursday, February 08, 2001 11:36 PM
To: Multiple recipients of list
Hi All,
I have a really wierd problem with a client who has tried to export the
whole database. They get errors because there is
a public synonym called System created by a user FCAADMIN. This public
synonym caused several oracle supplied objects to go invalid resulting
in the failed Oracle
Hi
How did you find you have corrupt blocks ? Did you have any ORA-1578
errors ? Any alert log messages for the same ?
I would first find out which objects exist in that particular corrupted
block (or ) alternatively you could analyze all the objects in the system
tablespace like this.
hi dba ,
I went through the same problem here,where I reverse engineered a system
with no relations or integrity constraints and it was hell,since I guessed the
business rules and asked people from anywhere about the business of this
system,I don't want to remember this period of my life.
I 'm
Rafiq,
It has been a while since I dumped to tape but I'll try and lead you in the right
direction.
1. To dump different table one after the other you can list the table in a parfile and
call the parfile from your script or
2. you cal execute your exp script each time for a different table
Listers,
I am attempting to write a trigger on a table that will have batch
inserts nightly. I want each insert to check to see if a record with that
primary key exists, and if it does, update the record. If the primary key
does not yet exist in the table, insert the record. The batch
Depending on your application design, you may find a locking
scheme useful. Below is an example that uses rowid to take
out a lock. Note that this is not a lock on an object, but
simply a lock identified by a rowid.
As the demo is setup, the locks are automatically released
on rollback or
Not with a normal table trigger. Try creating a non-updateable view with an
"instead of" trigger for the insert.
Brian Norrell
Senior Software Engineer
QuadraMed
972-831-6600
-Original Message-
Sent: Tuesday, February 13, 2001 9:26 AM
To: Multiple recipients of list ORACLE-L
Hi elain
I have not personally encountered performance degradation setting this
to high value. But I will attempt to help you.
DBWR process is waiting for the IPC messages from the background
process or from the server processes, for the requests to write the dirty
buffers. That's how
Title: Oracle 816 on linux
I have a problemwhere in a statment of sql the DB Oracle doesnt get
the line in the follow situation :
select name
from table1
where field = 'AAA #989';
I think that between A and # exist some strange character that i cant
identify it ..
How canI do it ?
Ron,
Thanks for guidance. I am also working with my UNIX admin to work out some
solutions for distinct file name for each table export.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 13 Feb 2001 08:20:43 -0800
Rafiq,
It has been
Hi list,
I have a question about Unix and Oracle memory allocation. I have to say
that Unix isn't my platform, so I think for most of you this will be easy
answerd.
I have a HP Unix machine with follwing memory infos:
Memory Information:
physical page size = 4096 bytes, logical page size =
Hi Everybody,
I wanted to forward a mail to a particular Id thru an Oracle Procedure ,
can anybody tell me whether I can do that thru an Oralce Procedure
if so pls inform how to do the same.
I dont want to mail to a Unix Login id , I want to mail to a mail server
For e-g [EMAIL
We are implementing OPS for our production database.We are aware that only
the select statements(query) gets failover in case of a node failure.
But I have been told, to achieve 100%TAF from our application side i.e the
user w/o reissuing a transaction(update and etc) we need to implement
OCI in
To get a better error messages make sure your ORACLE_HOME environment
variable is set. It appears in your case that 'export
ORACLE_HOME=/u01/app/OracleHome' would be appropriate.
Error number #6 (from /usr/include/asm/errno.h) is "No such device or
address". Make sure your kernel is compiled
Riyaj,
Thanks for your response.
The thing that puzzles me is that the seconds_in_wait time for all slaves
dbwr processes equals to the time since the database was started. I would
expect the seconds_in_wait time for slaves dbwr to be less than the database
uptime. Does that mean that all
hi list
we had a major outage at exodus lastnight. blew up both machines with 6
production databases. SAs have brought most of the disks back up but not
$ORACLE_BASE (or $ORACLE_HOME). how can our databases be up if the
alert.log(s) live on the unmounted disks? doesn't an oracle database have
Please
post your findings to the group. I'm sure we'd all welcome
it.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bjorn NaessensSent:
Tuesday, February 13, 2001 10:02 AMTo: Multiple recipients of list
ORACLE-LSubject: Re: off topic :
What is the purpose of the non-updateable view?
-FS
From: "Norrell, Brian" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: HELP - Insert/Update trigger
Date: Tue, 13 Feb 2001 09:56:15 -0800
Not with a normal table trigger.
Dang it,
Brian you're right, I didn't read the original post thoroughly.
Instead of batch inserts, do batch updates and in the exception handler, do
the insert.
Or you could use the %FOUND flag based on a select PK from table.
Dan
-Original Message-
Sent: Tuesday, February 13, 2001
Use glance(preferable) or top and see memory usage. Based on free memory
you can decide about increase of your buffers. If your db_block_size is
8K, adding 1000 block means addition of 8MB in your SGA. If still not sure
check with your Unix Admin.
HTH,
Regards
Rafiq
Reply-To: [EMAIL
Have you thought of Precise Software?
I am evaluating the Precise / Savant tools now, next will be OEM 2.1.
Am looking for something that compares schemas or databases for integrity
after maintenance or Oracle upgrades.
www.precise.com http://www.precise.com
www.savant.com
Yes, it can be done,
I'd write the trig to do a select on that PK and if %FOUND is true, update
otherwise in the exception handler for that block, do the insert.
begin
..
begin
select PK from table;
UPDATE
exception
INSERT
end
..
end
Dan
-Original Message-
Sent:
How about removing the public synonym and create a private one in the schemas that
need it. Except for a table or procedure that is truly global, making a public synonym
is never a good idea.
"Nisha Patel" [EMAIL PROTECTED] 02/13/01 09:55AM
Hi All,
I have a really wierd problem with a
To be clearer I should have said if the udump destination is present. If
there are no errors I ofter delete the alert logs to make room.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 1:21 PM
hi list
we had
How about using this statement:
select name
from table1
where field like 'AAA% #989';
The % represents any character.
HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 12:25 PM
Oracle 816 on
Kris,
Try doing something to force a write to the alert log (e.g. switch logfile
or backup controlfile to trace). Of course to start up the database there
should also be writes to the alert log. Also, what did it use for init.ora?
That should also be under $ORACLE_BASE. You can check v$parameter
The only reference I found in the documentation was in the UTL_RAW package.
BIT_XOR Function
This function performs bitwise logical "exclusive or" of the values in RAW
r1 with RAW r2 and returns the "xor'd" result RAW.
If r1 and r2 differ in length, then the "xor" operation is terminated after
There is a Oracle running on this box. Hit statistics show me that I have to
increase the db_block_buffers. What I like to know is, how much more memory
can I give oracle? There are about 50 User working with this instance.
The bottom line is that you can increase db_block_buffers until the
I believe that there are no easy answer to you how much memory that you can add
to your SGA. You need to some experimental work to find out how many memory
that you can take away from system without dragging it down(or over burden it).
You can use 'vmstat' and 'sar -w' to monitor memory
That is correct. In 8.0 the package does not need to be in memory to pin
it.
-Original Message-
From: Ray Feighery [SMTP:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 4:21 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Database Startup Trigger is not pinning
I have never worked directly with "instead of" triggers, but their intent is
to be used on a non-updateable view. For instance:
SQL create view all_emps as select * from emps UNION select * from
archived_emps;
SQL insert into all_emps (...);
The RDBMS then says "Which real table does this
We are developing web database standards in my workplace. I need to identify
advantages/disadvantages of using Oracle verses MS Access for web databases.
Does anyone know of any good resources for gathering this info (web sites, articles,
etc)? Any help would be greatly appreciated.
Thanks
Hi list,
About a month ago, I moved and compressed listener.log file to a different
directory because
this file accumulated to a huge size over past year or two.
Since that point, nothing is able to write to listenr.log file even though i did
not change an writing permission
of this file and
Have you bounced the listener since you moved the log file?
Bill Carle
ATT
Database Administrator
816-995-3922
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, February 13, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L
Subject:listner.log cannot be generated
I said it was a bit xor. Your first message was not very specific. There is no
general xor operator in Oracle. However under Oracle 8i you can create one. Look at
the create operator command.
You could also do something like
(select x from A where y = 2
union
select x from A where z = 2)
Hi listers,
I remeber vaguely there is a way to select top n or
top % rows of a select statement. But I cannot find
it anywhere. Could somebody let me know? Thank you.
Leslie
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
Title: system command hangs from external pl/sql
Hi
I am trying to implement printing from pl/sql on our system. We are running Tru64 Unix and Oracle 8.0.5. I have configured an external procedure listener and created a shared library by following some of the documentation in Metalink. The
Hi:
I'm having problems setting up and using database link.
My create statement looks as follows:
create database link PROD connect to xuser identified by xpwd using
'TRNGPROD';
I then execute :
select * from sysadm.employees@PROD.
and get the following error:
ORA-12154: TNS:could not resolve
thanks, but this is what i get when i try to cd to $ORACLE_HOME:
db1:PHYS:/ora1_app cd $ORACLE_HOME
bash: cd: /ora1_app/product/8.1.6: No such file or directory
db2:CONC:/ora2_app cd $ORACLE_HOME
bash: cd: /ora2_app/product/8.1.6: No such file or directory
or an ls on $ORACLE_BASE:
Hi:
If the specified bdump is not accessable, oracle may write the alert_log to
$ORACLE_HOME/dbms or dbs directory by default. I am sure you can find it
somewhere in oracle_home.
|+---
|| Henry Poras |
|| Henry.Poras@|
||
hi,
Does anyone know whether Oracle JDBC Thin Driver
can be shipped to the clients without getting any license from
Oracle?.
Is it free for shipping?
Sanjay
Hi
I think, you removed the listener log file while the listener is up and
running. When you removed the listener log, listener was having a file
pointer open. Since the file pointer is not closed, the listener is still
writing to the same node.
If you stop and start the listener, you
hi,
I want to see the latest SQL Statements that I sent
to Database. I know that I can make use of V$sqlarea but it restricts only
tofirst 1000 characters.
But my query is more than that.
Any help.
Sanjay
Hi Sanjay,
Try the following:
-- this one will be faster but only shows the first 1000 characters of the
SQL
select username, q.*
from
v$session s , v$sql q
where
q.address = s . sql_address
and q.hash_value = s.SQL_HASH_VALUE
and s.username = 'user'
I have a 8.1.6.0.0 database.
What is the best way to change Character Set from WE8ISO8859P1 to UTF8
from:
NLS_CHARACTERSET WE8ISO8859P1
To:
NLS_CHARACTERSET UTF8
Thanks
Title: Degree of Parallelism: 0?
Hello all,
I've purposely got PQO off. But I was shocked to see I've got some parallel query slaves out there. I checked to see which objects they are, listed below. I'm not concerned about the sys/system stuff, Im worried about CTX (my intermedia text
Please try to be gentle with this soul.
Maria -
Access should not even be on your short list. The underlying architecture
is not designed for simultaneous use by multiple sessions. What type of
"web database" application(s) will you be creating? How many concurrent
users do you expect for
Hello,
I have this user statement below which is very long in a 8.1.6.2
database.
Any ideas to optimize it is wellcome.
Best Regards
Philippe
**
SELECT
PLT_LISTE_DES_AGENTS_PL97.SEXE,
PLT_FORMATION_AGENT_PL74.PL0PL009_COLLEGE,
On Tue, 13 Feb 2001, Sanjay Kumar wrote:
hi,
I want to see the latest SQL Statements that I sent to Database. I know that I can
make use of V$sqlarea but it restricts only to first 1000 characters.
But my query is more than that.
Use v$sqltext or v$sqltext_with_newlines. Simple join
Thanks David. You are right, I did not notice that the private figure
actually included the SGA size as well.
Regards
Long
-Original Message-
Sent: Thursday, 8 February 2001 7:55 PM
To: Multiple recipients of list ORACLE-L
Long
pmap seems to include portions of the SGA in the Private
With a corrupt system tablespace and no backups you have no further recovery
options.
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 6:30 AM
Hello list,
I know that the answer to my question its going to be a negative
I don't know of any comparisons but unless you have only a very tiny amount
of data and you expect only one connection to the database at a time I would
not use Access.
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 2:11
I think export and import are the only way you can do this.
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 5:40 PM
I have a 8.1.6.0.0 database.
What is the best way to change Character Set from WE8ISO8859P1 to UTF8
do you mean to find top rows based on some coplumn values..
will this help..it will fetch u the nth row based on some value of
particular column.
select * from tablename a where position_salary-1=
(select count(distinct col1) from tablename where col1a.col1)
order by col1;
can modify it
Hi all,
I need to rename some columns on my table. Any idea how to do that...
Thanks in advance,
Hessu
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ:
Hello,
I need some help. I need all the columns values on 1 line only. that is in the end of
this mail you will see the result as,
-
V$ACCESS
SYNONYM 8
PUBLIC
Hello,
If I want to achieve the following in a shell script, how can I do that:-
I put the following in a shell:-
USERID=$1
PASSWD=$2
su - $USERID -c $ORACLE_HOME/bin/lsnrctl eof
start listener
Hi all,
How to compile a pro*C code on winnt?
I'm able to precompile it and get .c file from it.
But unable to get executable from this .c file.
Any guidance in this respect will be great help to
us
Regards
Bipin
Do You Yahoo!?
Get
Hi Jared
Thanx for the reply.
I'll do some stress testing, and keep you up to date.
(I'm not too optimistic though)
Cheers
JL
-Original Message-
Sent: Tuesday, February 13, 2001 6:21 PM
To: Multiple recipients of list ORACLE-L
Depending on your application design, you may find a
Hessu,
One of the ways:
create table newtable (newcolumn1,newcolumn2,newcolumn3,...)
as select * from oldtable
;
rename newtable to oldtable;
HTH
Suhen
Hi all,
I need to rename some columns on my table. Any idea how to do that...
Thanks in advance,
Hessu
CREATE THE TABLE AGAIN WITH AS SELECT CLAUSE..
SELECTING ONLY COLUMN DEFINITION WHILE SUPPLYING THE NEW COLUMN NAME URSELF.
apply constraints if any.
reinsert the data from old table. drop old table . rename new table as old
one.
- Original Message -
To: Multiple recipients of list
87 matches
Mail list logo