the controlfile. Then when you
open the database the tablespace stays offline you can drop it and it's
contents thereby cleaning up the data dictionary. Yes, you can't do that with
the rollback segments on line either, which is why you need to comment them out
of the init.ora.
Dick Goulet
Bill,
A rollback will generate redo, so that it can be recovered. If a
system crashed during a rollback, the database must be able to recover to
the point at which the rollback had terminated. Since a rollback is applying
the undo records (think opposite actions), it is modifying data, so
On an ordinary insert, you get a redo record for
the row, and the undo (rollback) for that row.
You also get a similar record for each index
that has to be updated because of the new row.
Similarly, an update or delete will generate one
redo record for the table, and one redo record
for each
I recently had a situation where a process went down and Oracle had to roll back
the transaction. The original transaction did around 60,000 inserts and/or updates.
When Oracle did its rollback, it generated many redo logs in a short period of time,
but there seems to be a wide variety
Hi all
Can a person somehow force a import process to use a specific rollback
segment. I got a live system with many smallish segments, the dump file is
about 20 GB and take just over 12 hours to process but it requires a big
rollback segment.
I don't want to offline the small once so that only
rollback
segment. I got a live system with many smallish segments, the dump file is
about 20 GB and take just over 12 hours to process but it requires a big
rollback segment.
I don't want to offline the small once so that only a big one is online
since this causes problems with the day to day
:
Sent by: Subject: import and rollback segments
[EMAIL PROTECTED
-Original Message-
Sent: Friday, December 20, 2002 7:09 AM
To: Multiple recipients of list ORACLE-L
Hi all
Can a person somehow force a import process to use a specific rollback
segment. I got a live system with many smallish segments, the dump file is
about 20 GB and take just over 12
don't think we welcome such people like you here.
David
-Original Message-
Sent: Monday, December 09, 2002 5:39 AM
To: Multiple recipients of list ORACLE-L
On Mon, 9 Dec 2002, Nguyen, David M wrote:
How do I increase size of oracle data files and rollback
and whether you want it
alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M;
For rollback datafile - same as any other datafile, eg:
alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on
maxsize 10240M;
You may then need to add another rollback segment or increase
;
For rollback datafile - same as any other datafile, eg:
alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on
maxsize 10240M;
You may then need to add another rollback segment or increase the max
extents of an existing one. eg to add another rollback segment:
CREATE
up on the implications of autoextend and whether you want it
alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize
10240M;
For rollback datafile - same as any other datafile, eg:
alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on
maxsize 10240M
;
For rollback datafile - same as any other datafile, eg:
alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on
maxsize 10240M;
You may then need to add another rollback segment or increase the max
extents of an existing one. eg to add another rollback segment
, David M wrote:
How do I increase size of oracle data files and rollback segments and Can
I
do it when database is online?
Unfortunately these sizes are fixed, and based on your level of
license with Oracle Corp. If you need to increase the size of your
datafiles or rollback segments, you must
your
mouth. I don't think we welcome such people like you here.
David
-Original Message-
Sent: Monday, December 09, 2002 5:39 AM
To: Multiple recipients of list ORACLE-L
On Mon, 9 Dec 2002, Nguyen, David M wrote:
How do I increase size of oracle data files and rollback segments
Title: RE: Increase size of data files and rollback segments
I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message.
-Original Message-
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10
here.
David
-Original Message-
Sent: Monday, December 09, 2002 5:39 AM
To: Multiple recipients of list ORACLE-L
On Mon, 9 Dec 2002, Nguyen, David M wrote:
How do I increase size of oracle data files and rollback segments and
Can
I
do it when database is online
Title: RE: Increase size of data files and rollback segments
What bothers me is why can't you use sqlplus? Why do you need GUI tool?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed
, 9 Dec 2002, Nguyen, David M wrote:
How do I increase size of oracle data files and rollback segments and Can
I
do it when database is online?
Unfortunately these sizes are fixed, and based on your level of
license with Oracle Corp. If you need to increase the size of your
datafiles or rollback
Title: RE: Increase size of data files and rollback segments
Au
contraire, I welcome Jeremiah just about anywhere, as long as he doesn't drink
too much of my beer.
Read
between the lines, David.There's a message there.
:)
--Walt
Weaver
Bozeman, Montana
-Original Message
welcome such people like you here.
David
-Original Message-
Sent: Monday, December 09, 2002 5:39 AM
To: Multiple recipients of list ORACLE-L
On Mon, 9 Dec 2002, Nguyen, David M wrote:
How do I increase size of oracle data files and rollback segments
and Can
I
do
ORACLE-L
On Mon, 9 Dec 2002, Nguyen, David M wrote:
How do I increase size of oracle data files and rollback segments
and
Can
I
do it when database is online?
Unfortunately these sizes are fixed, and based on your level of
license with Oracle Corp. If you need to increase
I welcome David input always, especially when he is yanking the leg of
someone who did not troubled himself to open the SQL manual and look at
obvious commands like alter rollback segment and alter tablespace.
I liked his answer.
BTW, Please do not tell ANYONE on this list to shut up.
It is bad
Title: RE: Increase size of data files and rollback segments
ORACLE ORACLE ORACLE ORACLE SQL*NET
Just bringing it back on topic :)
Nick
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10:21 AM
To: Multiple recipients
.
David
-Original Message-
Sent: Monday, December 09, 2002 5:39 AM
To: Multiple recipients of list ORACLE-L
On Mon, 9 Dec 2002, Nguyen, David M wrote:
How do I increase size of oracle data files and
rollback segments and Can
I
do it when database is online
On Mon, 9 Dec 2002, Nguyen, David M wrote:
How do I increase size of oracle data files and rollback segments
and
Can
I
do it when database is online?
Unfortunately these sizes are fixed, and based on your level of
license with Oracle Corp. If you need to increase
.
David
-Original Message-
Sent: Monday, December 09, 2002 5:39 AM
To: Multiple recipients of list ORACLE-L
On Mon, 9 Dec 2002, Nguyen, David M wrote:
How do I increase size of oracle data files and rollback segments
and
Can
I
do it when
Title: RE: Increase size of data files and rollback segments
From: Nguyen, David M [mailto:[EMAIL PROTECTED]]
Alright guys, just because you know Jeremiah better than me
so you can take
his joke.
I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you
.dbf' resize 10240M;
For rollback datafile - same as any other datafile, eg:
alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on maxsize 10240M;
You may then need to add another rollback segment or increase the max extents of an
existing one. eg to add another rollback segment
and rollback segments
How do I increase size of oracle data
files and rollback segments and Can I do it when database is
online?
Thanks,David
How do I increase size of oracle data files
and rollback segments and Can I do it when database is online?
Thanks,David
On Mon, 9 Dec 2002, Nguyen, David M wrote:
How do I increase size of oracle data files and rollback segments and Can I
do it when database is online?
Unfortunately these sizes are fixed, and based on your level of
license with Oracle Corp. If you need to increase the size of your
datafiles
recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, December 09, 2002 3:38 AM
On Mon, 9 Dec 2002, Nguyen, David M wrote:
How do I increase size of oracle data files and rollback segments and
Can I
do it when database is online?
Unfortunately these sizes are fixed, and based
Thanks Jared, thats not what I see. I have 20 rollback segments, and at no
point in time, there were more than
4 transactions in the rollback segments. In fact, I happened to see it a
couple of minutes ago.
select usn, xacts from v$rollstat showed me 0 in 19 rollback segments, and
2 in one
Raj,
You're assuming that the transactions are lasting long enough
for you to catch them in the rollback segments.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/26/2002 09:42 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED
running) with n
rollback segments, open n+1 sqlplus sessions. In each session, update a
row but don't commit. After each session's update, look at V$ROLLSTAT.
To the best of my knowledge, the assignment algorithm has always been to
assign a new txn to the segment with the smallest number of active
Raj,
Not to be too obvious, but... Are there any transactions that are
being explicitly assigned to the rollback segments by the user/application?
-Original Message-
Sent: Tuesday, November 26, 2002 10:42 AM
To: Multiple recipients of list ORACLE-L
Thanks Jared, thats not what
In v7, the tie-breaker algorithm apparently changed to choose the
segment
that is listed earliest in the init.ora file.
What if the rollback segments are created PUBLIC, and are
not listed in init.ora?
Order of sys.undo$.us#?
Jared
Cary Millsap [EMAIL PROTECTED]
Sent by: [EMAIL
Hello,
Are u performing any exception handeling in Ur
code? Try to capture oracle err mesg using
USER DEFINED EXCEPTIONS. For more detail look
into DBMS_ERROR_CODE and DBMS_ERROR_TEXT
OraCOP
--- Charu Joshi [EMAIL PROTECTED] wrote:
Hi Arup,
Thanks for the reply.
I have
Hello Friends,
Oracle Parallel Server 8.0.6.2.0 on Solaris 2.6 Nodes
We were having some locking and rollback issues, and I set up some scripts
to alert me in case there are more than 4 transactions in the rollback
segments, and more than 1 in any of the rollback segments.
Select sum(xacts
Here's one scenario:
4 transactions, 2 rollback segs
tx 1 - rbs1
tx 2 - rbs 2
tx 3 - rbs 1
tx 4 - rbs 2
tx1 and tx3 finish.
tx2 and tx4 have not yet committed.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/25/2002 07:39 AM
Please respond to ORACLE-L
Hi
I noticed few of rollback segment in one of Database are having few waits.Is
it necessary to create rollback segment with new size? Can u please some one
send some infor on rollback segment tunning?
Thx
-Seema
_
Add photos
Gurus,
Desperately need some ideas to solve this one.
Following is the sequence of events as it happens:
1. Front-end application (VC++) queries from a view V. V fetches data from a
remote database RD via a database link.
2. Front-end inserts a row in a local table LT.
3. The Insert trigger on
Gurus,
Sorry, forgot to mention one very important fact - this error doesn't occur
always - sometimes (but rarely) it's succeeds as well.
Thanks,
Charu
-Original Message-
Sent: Thursday, November 21, 2002 2:22 PM
To: '[EMAIL PROTECTED]'
(Distributed transaction)
Gurus,
Desperately
Charu,
I guess the error you are getting is Table or Trigger is mutating. and
perhaps you are using an after insert row trigger. This is a common and
expected problem. There are ways to get around it. You have not mentioned
the version of Oracle; I would assume 8.1.7 or later.
Inside an after
Hi Arup,
Thanks for the reply.
I have checked the trigger code thoroughly and surely it's not a mutating
trigger. Nor is there any cascade effect or the trace files would have shown
the statements within that trigger.
There is some other error occurring, but we are not able to trap it because
hi, list friends:
I am interested in that
topic:http://www.ioug.org/ioug_s/repository_pkg.doc?v_tech_content_dtl_phy_id=7666
I am also considering whether too large rbs segment size does have adverse
impact on database performance. In my production (OLTP) i configured rbs to be
Zhu Chao,
Please be aware that rollback segments serve two major purposes:
* recover individual transactions (i.e. rollback)
* provide before-image information for read-consistency
The information you are getting from V$ROLLSTAT and STATSPACK is accurate at
measuring the first purpose
Hi all
i am trying to execuate one procedure which upadte the table containing 29443 records.
After 2 hours going in loop, procedure returns following error:
SQL exec test
BEGIN test; END;
*
ERROR at line 1:
ORA-01562: failed to extend rollback segment number 2
ORA-01628: max # extents (249
3 options
1. if possible , put a commit in your procedure to reduce load on rollback
segs
2. ask your dba to increase size of rollback segments. Since rollback
segment allocation is random, u may have to drop the smaller rbs segs and
create new larger segs
3. increase the maxextents of existing
Hi all,
Trying here now since have tried to find it online and build the query
myself.
I need to figure out how much space a user/session is using of a rollback
segment.
I got the queries to show which segment the user is attached to but need to
know how much is being used (something like
,
Trying here now since have tried to find it online and build the query
myself.
I need to figure out how much space a user/session is using of a rollback
segment.
I got the queries to show which segment the user is attached to but need to
know how much is being used (something like a fuel gauge
,
t.start_time,
s.sql_address Address,
s.sql_hash_value Sql Hash
FROM sys.v_$session s, sys.v_$transaction t, sys.v_$rollname r
WHERE t.addr = s.taddr AND t.xidusn = r.usn
ORDER BY t.start_time
Try this. It shows the undo blocks used in the rollback segment. Plus
some other variables for query
recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Wed, 23 Oct 2002 09:02:17 -0800
Hi all,
Trying here now since have tried to find it online and build the query
myself.
I need to figure out how much space a user/session is using of a rollback
segment.
I got the queries to show which segment
AND t.xidusn = r.usn
ORDER BY t.start_time
Try this. It shows the undo blocks used in the rollback segment. Plus
some other variables for query usage.
-Original Message-
Sent: Wednesday, October 23, 2002 12:02 PM
To: Multiple recipients of list ORACLE-L
Hi all,
Trying here now since
I am performing an export of a set of very large tables. I am not using
CONSISTENT mode. The exports are failing due to snapshot too old errors. The
application uses many small rollback segments, but has one large one for big
transactions. Is it possible to force the export to use the large
The only correct resolution to this is to ensure that DML transactions
referencing the tables being backed up, are not run at the same time.
Bringing the big rollback segment online wont buy you anything. You could
delay the inevitable by removing the optimal clauses if set.
Raj
in the rollback segments, but when the transaction that caused the changes
commits, eventually Oracle releases these. In your case, before the export
reaches the end of the table, it tries to retrieve a block, learns it is
changed, checks the rollback segments, learns it has been released, then
reports
I'm not sure whether there is another way, but can the following be done?
in the after logon trigger specify: 'SET TRANSACTION USE ROLLBACK
SEGMENT...?
don't know whether this statement is allowed inside a trigger and also
whether it will work.
and also, export commits periodically
Hi,
The snapshot too old error comes when someone has started a query on one
table and at the same time some transaction is going on. So at this time the
select query will read from rollback segment to create a consistent view in
time. Now in what happens select query has started reading
TRANSACTION USE ROLLBACK
SEGMENT...?
don't know whether this statement is allowed inside a trigger and also
whether it will work.
and also, export commits periodically, the statement will go off after the
first commit(even if it was allowed)
regards
naveen
-Original Message-
Sent: Friday
You try using direct=y on the export to see if it speeds things up enough
that you don't get shot down. There are some cases where you can't do this
(I would have to look it up to get them all): For example, if you are using
the query= parameter. But most of the time, you can greatly reduce
Message-
Sent: Friday, October 18, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L
I am performing an export of a set of very large tables. I am not using
CONSISTENT mode. The exports are failing due to snapshot too old errors. The
application uses many small rollback segments, but has one
not using
CONSISTENT mode. The exports are failing due to snapshot too old errors. The
application uses many small rollback segments, but has one large one for big
transactions. Is it possible to force the export to use the large segment
without taking all the others (except System) offline? I have
tables. I am not using
CONSISTENT mode. The exports are failing due to snapshot too old errors. The
application uses many small rollback segments, but has one large one for big
transactions. Is it possible to force the export to use the large segment
without taking all the others (except System) offline
We have ORACLE 8.1.7.4 running on NT. My questions are:
1. What difference between public rollback segment and private segement?
2. what is benefit on public segment than private segment?
3. does public segment only use on paraller server (RAC)?
Thanks
Private rollback segments usually are listed in the init.ora file. Public
rollback segments are created with the PUBLIC parameter and are available
to multiple instances that accesses the same database. Private rollback
segments are also explicitly acquired when an instance opens a database
Can't remember where I copied this from, but I believe it came from
metalink. I don't have a version associated with it, so things might have
changed in v9.
HTH
Barb
Public vs. Private Rollback Segments
A common misconception about `Private' rollback
Except in the case of maintenance on rollback segments. You can take a private
segment offline at anytime, whereas a public one has to be done with the
database unmounted.
Dick Goulet
Reply Separator
Author: Baker; Barbara [EMAIL PROTECTED]
Date: 10
things might have
changed in v9.
HTH
Barb
Public vs. Private Rollback Segments
A common misconception about `Private' rollback segments is that they are
segments reserved for a particular use or a particular transaction. The only
difference between Public
This is my understanding of "private" versus
"public" rollback segments:
Private RBS can be brought online only via
explicit ALTER ROLLBACK SEGMENT xxx ONLINE command.
The "init.ora" parameter ROLLBACK_SEGMENTS is
only a list for the automatic
Public rollback segments are managed by the federal government
(Department of Rollback Vehicles) and are likely to be unionized,
while the private rollback segments are managed by the DBA. I'm
sure that oracle documentation covers this in detail.
-Original Message-
From: dist cash
Comment:
The fact that a PUBLIC rollback segment comes online at startup
without altering the init.ora is a very useful feature.
I am at this moment creating a 40 gig RBS tablespace in an SAP
database, to be used by a single PUBLIC rollback segment.
There are certain utility operations
No, I don't think so.
11:08:27 rsysdevdb.radisys.com - jkstill@dv01 SQL create tablespace
puglic rollback segment jks tablespace rbs;
Rollback segment created.
11:08:47 rsysdevdb.radisys.com - jkstill@dv01 SQL alter rollback segment
jks online;
Rollback segment altered.
11:08:55
Jared,
Ah... but, no one had an opportunity to access the segment that you created.
I'm prob. wrong, but I seem to remember that at one time (the mists) once
the rollback seg was accessed, you could not just 'off it'. Could be I'm
thinking of something else.
Thank you,
Paul Sherman
DBAElcom
in fact I see advantages to using private (assuming you are not running
OPS/RAC)
There are times when you might not want all the rollback segments to be
online and available. You have control over this with private rollback
segments. You do not have this control with public rollback segments
Additionally:
'create rollback segment...' defaults to 'private' and the only time when
I needlessly use a keyboard is to send a message like this
one
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 17, 2002 1:59
PMTo: Multiple recipients
No, that isn't it. :)
Sherman, Paul R. [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/17/2002 12:37 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RE: [Q] Public and private rollback segment
Hi
My rollback tablespace is highly fragmented.I am thinking to do like
following?
-Create new rollback tablespace rbs1
-Create rollback segments
-Offline all rollback segments from old rollback tablespace (rbs)
-Drop rollback segments from rbs tablespace
-Drop tablespace rbs
-Create RBS
before you do all this by fragmented do you mean that there are a
large number of free extents in the tablespace?
If so, are those extents all the same size or at least a multiple of
the same size?
If so, why are you bothering to defragment?
You would only need to defragment the rollback
Why do you think it is fragmented?
Why do you think it is a problem?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, October 07, 2002 10:36 AM
Hi
My rollback tablespace is highly fragmented.I am thinking to do like
following?
-Create
in 8i, it won't work.
Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
=== 2002-08-28 00:13:00 ,you wrote£º===
1.) Can we rollback a drop statement ?
No. However, you can use Log Miner.
Alexandre
--
Please see the official ORACLE-L FAQ: http
1.) Can we rollback a drop statement ?
No. However, you can use Log Miner.
Alexandre
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
-28 00:13:00 ,you wrote£º===
1.) Can we rollback a drop statement ?
No. However, you can use Log Miner.
Alexandre
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
SEGMENT_TYPE EXTENTS MAX_EXTENTS-- --- -- -- ---SYS SYSTEM ROLLBACK 505 505
SQL connect sys Enter password: Connected.SQL alter ROLLBACK sys.system storage (maxextents 1024);alter ROLLBACK sys.system storage (maxextents 1024) *ERROR at line 1:ORA-01902: SEGMENT
I don't wantto sound too obvious but isn't the
answer in the error message ?? .
RTFMtime.
As an aside, why do you need to extend your system
rollback segment
Lee
-Original Message-From:
Jonny Delmont [mailto:[EMAIL PROTECTED]]Sent: 28 August 2002
10:53To: Multiple recipients
Do you mind if I ask why? Do you have any other rollback segments in place
other than the SYSTEM one?
In answer to your question though, look at the error message.. You missed
out the word segment.
alter rollback SEGMENT sys.system storage (maxextents 1024);
HTH
Mark
and max_extents
!= 0
4 /
OWNER SEGMENT_NAMESEGMENT_TYPE EXTENTS MAX_EXTENTS
-- --- -- -- ---
SYSSYSTEM ROLLBACK 505 505
SQL connect sys
Enter password:
Connected.
SQL alter ROLLBACK sys.system
ORA-01902: SEGMENT keyword expected
alter rollback segment sys.system storage (maxextents 1024);
regards,
Mike
-Original Message-
Sent: 28 August 2002 10:53
To: Multiple recipients of list ORACLE-L
Dear Gurus,
Could you please help me out with this - I want to increase
PROTECTED]
=== 2002-08-28 00:13:00 ,you wrote£º===
1.) Can we rollback a drop statement ?
No. However, you can use Log Miner.
Alexandre
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
INET: [EMAIL PROTECTED]
Fat City Network Services
Mark,
Thanks, your command doesn't help. To answer your question, Database was setup'd by previous DBA. Still i've never seen this type of segment...
SQL alter rollback SEGMENT sys.system storage (maxextents 1024);alter rollback SEGMENT sys.system storage (maxextents 1024) *ERROR at line 1:ORA
Jonny
The SYSTEM rollback segment is/was created initially on a database build,
and the recommendation has always been to add extra rollback segments
straight away for normal transactional processing. You really *should* have
other rollback segments available for your users.. What output do you
The message tells you already
Alter rollback segment sys.system etc
i.s.o. Alter rollback sys.system
Jonny Delmont
create a rollback tablespace, create new rollback segments IN the
rollback tablespace and take the rollback segment named SYSTEM
offline. Do NOT use it.
Having an active rollback segment in your system tablespace is like
allowing users to create objects there. Especially listen to Stephane
Thanks all for your help.
Jonny
Rachel Carmichael [EMAIL PROTECTED] wrote:
create a rollback tablespace, create new rollback segments IN therollback tablespace and take the rollback segment named "SYSTEM"offline. Do NOT use it. Having an active rollback segment in your system
, you cannot recover from drop using logmnr.It is
internal dml to data dictionary, maybe in 9i it will work, i am not sure.But
in 8i, it won't work.
Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
=== 2002-08-28 00:13:00 ,you wrote£º===
1.) Can we rollback a drop
.
Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
=== 2002-08-28 00:13:00 ,you wrote£º===
1.) Can we rollback a drop statement ?
No. However, you can use Log Miner.
Alexandre
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: Rollback !
Alexandre - Thanks for posting the link. I read the document.
It describes
how to track the DDL statements. Unless I overlooked
something, it doesn't
say you can UNDO DDL. I think the reason was explained
earlier on this post
be
specifically allocated to a transaction by a user.
Always create additional rollback segments in a separate tablespace. If you
fill up the rbs tablespace, the transaction fails. If you fill up the system
tablespace, the database fails.
-Original Message-
Sent: Wednesday, August 28, 2002 7
Johnny,
Sorry to point out the obvious, ;)
but the error message is telling you what to do.
It's ALTER ROLLBACK SEGMENT ...
Jared
Jonny Delmont [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/28/2002 02:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list
101 - 200 of 607 matches
Mail list logo
