Hi Mladen,
Oh, I have no doubts ;)
Hurt you still don't trust me but considering our little wager (2 tickets to
the Bowie world tour) I guess it's only fair you go to a neutral referee.
Bet when they confirm what I say they don't give as detailed an explanation
;)
Cheers
Richard
-
Title: Howto drop a corrupt database ?
Hi,
I'm running Oracle 8.0.4 on AIX: for one of the databases, my datafiles got corrupted and I got NO BACKUP (and NOARCHIVELOG) :(
SVRMGR alter database open;
ORA-01122: database file 6 failed verification check
ORA-01110: data file 6:
Hi Gorik,
Do you want to drop the database as a whole, i.e. including your system
tablespace etc?
Just delete all your controlfiles, datafiles and redologfiles, keep the
initSID.ora and start creating the database all over again. (You
do have a create-script, don't you?).
Of course you can
So, let's start another thread.
How many of you have actually seen Sequences implemented in the manner I
described
and Mladen demonstrated below ?
Hemant
At 08:24 AM 08-11-03 -0800, you wrote:
Being sort of DBA Doubting Tom, I have a bad habit of trying and testing
stuff. Here is what happens
Hemant K Chitale wrote:
So, let's start another thread.
How many of you have actually seen Sequences implemented in the manner I
described
and Mladen demonstrated below ?
Hemant
What I have seen used are non-cycling sequences which are forced to
cycle - the idea is to restart the
I've seen several of them on projects I worked on: People converted older
data-models - if model is the right name ;-) - and stuck to the
small key-fields they had.
One particlaur example got a nice :-( algorithm replaced by this nice
lick Oracle feature called 'sequence'. Of course increasing
Amen. In Miracle we'll do nicely in the years to come by being able to
support VMS, PL/SQL (the COBOL of the databases - widely used, very
efficient, not in vogue anymore for new projects), perhaps Oracle (if it
goes the way we could fear), UNIX (which is certainly dead now - if you
had any
I do not know anything about the way oracle semi compiled the code but I
will try a wild guess (anybody who better please correct me):
Maybe (a big MAYBE) oracle translate: if then... else
as: If cond then do; else go to line 250.
And the go to line 250 is counting lines until it arrive to
Will 10g(rid) be succeeded by 11G(oogle)?
CJ
DBA!ert,
Independent Oracle Consultancy
Kastanjelaan 61C
2743 BX Waddinxveen
The Netherlands
tel. +31 (0) 182 640 428
fax +31 (0) 182 640 429
mobile+31 (0) 653 911 950
e-mail [EMAIL PROTECTED]
Nice thoughts Mogens. I just read an article in a Dutch magazine which
states, and I fully agree, that the whole Soapy netservice thing won't
work.
Or will webservices be 2PC enabled? That will scale! (Use more soap)
:-(
I like your idea of google-dml. it's a real challenge! let's make
I had the same thought, also thought that
if you have something like this that does not get executed:
if VAR1 like '%abcbdbdbbbfdbfdfdfd%'
The compiler (or the semi-compiler) still has to allocate memory for VAR1
and load it.
I'm testing and will update the list, if I managed to find anything!
Yechiel's idea reminds me of one of that 'tuning tips' of old which said
'avoid calling a routine too far away in the code' (because it could be
in another page, etc.). This kind of phenomenon, reference to chunks of
code which have been safely parked away on disk may also come into play.
SF
Sunday, November 9, 2003, 10:44:25 AM, Stephane Faroult ([EMAIL PROTECTED]) wrote:
SF The big advantage on dropping and recreating them is that
SF existing privileges stay in place and you don't have to GRANT SELECT to
SF everybody ...
Yeah, I wrote a script one to let me adjust sequences in the
Slightly OT: Way before AR was available, we built a set of triggers to do
the replication job (Oracle 7.0.something). Of course synchronisation of
sequences was a hell of a job. Lucky for us, the system was more DSS than
OLTP: approx. 3000 - 10.000 transactions/day. Furthermore there was a
We haven't even touched the subject of ITL entries which is also
unaffected
by ASSM.
By the way, in 9i there is one interesting issue with ITLs, that every table
datablock gets 2 ITL slots by default, even if INITRANS and MAXTRANS are set
to 1. And blocks formatted due direct path inserts will
The honor should go to Steve Adams, I read it from his website.
Tanel.
And we do need education, because we do want to be bricks in the wall.
You seem to know everything, so please, don't leave us alone.
On 2003.11.07 12:49, Tanel Poder wrote:
For reasons why, think about it from the
Just for the record, in 10g you actually can use
drop database command ;)
Tanel.
- Original Message -
From:
Carel-Jan Engel
To: Multiple recipients of list ORACLE-L
Sent: Sunday, November 09, 2003 3:24
PM
Subject: Re: Howto drop a corrupt
database ?
Hi
With these sizes, I usually onlyexport the schema structures using
rows=n and tables are transferred over dblinks in direct mode (there is no
direct mode import possibility until 10g, and even then it's done using data
pump, Oracle's new exp/imp toolset)
Also I build indexes only after
He probably meant, that tracefile of controlfile only contains the crucial
information about data- logfile locations and only a bit of other
information.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 07, 2003 10:54 PM
Really-really excellent suggestions in this thread.
My respect,
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, November 08, 2003 12:49 AM
Arup,
I am currently devising something I have already more or less done in
the
Btw, if you configure controlfile autobackup on, the controlfile is
automatically backed up during any physical database structure change, e.g.
adding a datafile, etc.
The file is backed up to $ORACLE_HOME/dbs or $OH/database (depending on
platfoem) by default. You just be monitoring these
Well all,
I finally checked out what I stated below this
weekend, and, unfortunately, the new 9i init.ora
parameters are not there in the text. :-(
(New edition maybe, Jonathan? :-) )
*However*, the book is still outstanding in terms of
setting up MTS initially, AND troubleshooting, AND
Hi!
It was only the SCN - time mapping informatin which is aged out after 5
days, but you still can use SCN-based flashback back to your oldest undo
record.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 07, 2003 10:04 PM
Jonathan Lewis has found out that even 8i has flashback capabilities
internally http://www.jlcomp.demon.co.uk/ch_01.html
Btw, in 10g there is a guaranteed retention option as well, that
undo_retention time is forced instead of attempted.
Tanel.
- Original Message -
To: Multiple
Title: Message
These should be Portal-specific packages which
return it's internal usernames, I don't remeber any names from heart, but you
always canuse 10046 traceat level 4 to get information about which
functions/procedures are executed during authentication.
Tanel.
- Original
How will that drop corrupt datafiles? Did you already try that?
Carel-Jan
At 13:19 9-11-03 -0800, you wrote:
Just for
the record, in 10g you actually can use drop database command
;)
Tanel.
- Original Message -
From: Carel-Jan
Engel
To: Multiple recipients of
list ORACLE-L
Hi List,
Could someone please help me?
Assumption situation - Platform migration of Oracle DW on Oracle DB (data
volume 3.5 TB) from HP-UX to IBM-AIX
1.. DB migration; it is correct to use Export/Import technique/method in
the above assumption?
2.. Witch is the time frame in a worst case
Hi!
Well, if the commit is not too frequent, one natural way
of generating primary key would be select max(last_change#) from
v$datafile;
No, you definitely don't want to do that!!!
v$datafile uses x$kccf% tables which cause several physical reads into
controlfiles and x$kcvfh which shows
I think it is possible to enable DDL command logging in 9i, it can be used
in logical standby.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 6:09 PM
You guessed and hoped you were close enough. If you were
A. Teles wrote:
Hi List,
Could someone please help me?
Assumption situation - Platform migration of Oracle DW on Oracle DB (data
volume 3.5 TB) from HP-UX to IBM-AIX
1.. DB migration; it is correct to use Export/Import technique/method in
the above assumption?
No. Would take
I think this is a high-level design and even analysis issue in many cases.
If no gaps are allowed, you probably should allocate a key value for any
record just before committing the transaction (commiting has wider meaning
here, e.g. accepting or permanently storing). That way you won't get
Hi List,
Could someone please help me?
Assumption situation - Platform migration of Oracle DW on Oracle DB (data
volume 3.5 TB) from HP-UX to IBM-AIX
1.. DB migration; it is correct to use Export/Import technique/method in
the above assumption?
Use exp/imp only for transporting the
I've never tried (actually I'm not even in beta
program currently), but it works only on exclusively mounted and not open
database, and with restricted session instance mode. During drop, controlfiles
are scanned for datafile locations and the datafiles found from there are
deleted from OS.
Hi!
I'm not entirely in agreement with the quote (that's a different story)
but
notice there is no mention of PCTFREE.
Yes, this is a deficiency of documentation. PCTFREE is still used and needed
in ASSM segments. As you said, value for it can not be tuned automatically,
since Oracle doesn't
As I understand, in case of cached sequences, SEQ$ is touched only when you
run out of cached values in library cache and a new sequence range has to be
allocated.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003
Hi List,
A secure system makes data available to authorized users, without delay.
Denial-of-service attacks are attempts to block authorized users ability to access
and use the system when needed.
By using user-profile one can lock DB users if he/she provides wrong password 3
times.
Then DBA
Dear All,
query rewrite doesn't work on materialized view if based on a regular view
which contains joins and coorelated subquery.
Got the the following message:
QSM-01063: query has a dictionary table or view
QSM-01019: no suitable materialized view found to rewrite this query.
I create a
Saminathan,
How dare you post such a message with that subject line.
Here is my response, which you will not appreciate highly:
read the fscking manual.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/secure.htm#2193
how does oracle address it?
by having it as configurable
I agree as Step 1, but I expect that you'll find quickly that the issue
is a big c value for the EXEC on the block. If you do find this, then it
indicates exactly what's been suggested several times already: use
DBMS_PROFILER to dig into the response time of the EXEC.
Cary Millsap
Hotsos
Hi all,
is there a way to monitor index usages in oracle
8i ,like 9i v$object_usage?
Thanks
Arvind
Kumar
Hi Huang/Jared,
This is exactly what I was looking for...
Thanks
ShivaM
-Original Message-
Sent: Friday, November 07, 2003 7:40 PM
To: Multiple recipients of list ORACLE-L
Naveen and Shiva,
Please see my article at
http://www.stormloader.com/yonghuang/computer/OracleRegExp.html
Is the problem still evident when the parameters are
defined as in as opposed to in out.
Cheers
Connor
--- Cary Millsap [EMAIL PROTECTED] wrote: I
agree as Step 1, but I expect that you'll find
quickly that the issue
is a big c value for the EXEC on the block. If you
do find this, then it
Hi,
Anybody knows how Oracle determine the materialized view eligible for
textmatch or general rewrite?
TIA
Chuan
Important: This transmission is intended only for the use of the addressee
and may contain confidential or legally privileged information. If you are
not the intended recipient,
What SQL I have to use.Is there any way can i know what are those columns
were updated thru EMPTY_CLOB() function?
Thx
-Seema
From: Vladimir Begun [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Select ?
Date: Sat, 08 Nov
44 matches
Mail list logo