No question at this time
DBA Top 10
1 M. Cadot 17900
2 A. Kavsek 15700
3 M. Hidayathullah ... 9200
4 B. Vroman 8100
5 T. Boles 4900
6 P. Wisse 4700
7 J. Schnackenberg 3800
8 K. Van Nieuwenhov... 2100
9 G. Van Cauter 1400
10 A. Hudspith 800
10 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48078
Total active users1704
Act. users last 24h12
Act. users last hour0
Registered user hits last week397
Registered user hits last month1835
Go up

rollback not completed
Next thread: PLATO: last version (v55) has expired
Prev thread: IMPDP seems to be stuck

Message Score Author Date
Hi masters, I have one table having one field a...... javed akhtar Jul 12, 2017, 10:52
As you never feedback, rate, thank people who sp...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Michel Cadot Jul 12, 2017, 11:05
Hi Javed, Any DDL contains 2 implicit commits, ...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Jul 12, 2017, 11:13
Dear Michel, Really, but I always follow the pr...... javed akhtar Jul 12, 2017, 11:13
Hello Philip, thanks for your feedback. co...... javed akhtar Jul 12, 2017, 11:15
Javed, https://docs.oracle.com/cd/B19306_01/ser...... Philip Wisse Jul 12, 2017, 11:35
Dear Philip, thanks for your feedback. but...... javed akhtar Jul 12, 2017, 12:09
Hi Javed, Step 1 and 5 are both DDL, don't you ...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Jul 12, 2017, 12:26
Moreover step 3 also DDL :-) The command fails...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Jul 12, 2017, 12:30
hello philip, yes, i am agreed with you. t...... javed akhtar Jul 12, 2017, 12:33

Follow up by mail Click here


Subject: rollback not completed
Author: javed akhtar, India
Date: Jul 12, 2017, 10:52, 128 days ago
Os info: linux
Oracle info: oracle 11g
Message: Hi masters,

I have one table having one field as a number which is containing a primary key.

during data uploading, I disabled that primary key after upload I got to know that there are some duplicate records were in that table so that primary key constraint is not getting enabled.

I deleted those records and enable the primary key constraint.

now my question is that when I delete duplicate records those records were sent in undo segments because didn't execute a commit or rollback command.

after enabling primary key constraint and fire rollback command, Oracle displayed rollback completed but I didn't find any error related to constraint or the data in tables.

I would like to request please clear my concept where the data has gone after rollback.


thanks in advance.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rollback not completed
Author: Michel Cadot, France
Date: Jul 12, 2017, 11:05, 128 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message:
As you never feedback, rate, thank people who spent time to help, I see no reason to do it this time.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rollback not completed
Author: Philip Wisse, Netherlands
Date: Jul 12, 2017, 11:13, 128 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi Javed,

Any DDL contains 2 implicit commits, one at the start and one at the end.

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rollback not completed
Author: javed akhtar, India
Date: Jul 12, 2017, 11:13, 128 days ago
Message: Dear Michel,

Really, but I always follow the professional addicted.

by the way, if you think that I am not following the rules; i would like to give you very special thanks for remaindering me.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rollback not completed
Author: javed akhtar, India
Date: Jul 12, 2017, 11:15, 128 days ago
Message: Hello Philip,


thanks for your feedback.

could you please give me some link or good reading stuff for the same.


thanks,
Javed
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rollback not completed
Author: Philip Wisse, Netherlands
Date: Jul 12, 2017, 11:35, 128 days ago
Message: Javed,

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4010.htm

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:7072180788422

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rollback not completed
Author: javed akhtar, India
Date: Jul 12, 2017, 12:09, 128 days ago
Message: Dear Philip,


thanks for your feedback.

but I have one confusion over here, delete is DML operation and I never fire any DDL command on the session. kindly find the activity steps

1) disable the primary key constraint.
2) insert data via app and commit;
3) try to enable the primary key constraint
4) delete duplicate data---- neither commit nor rollback on that session.
5) enable the constraint.
6) rollback under undo retention.


thanks in advance.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rollback not completed
Author: Philip Wisse, Netherlands
Date: Jul 12, 2017, 12:26, 128 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi Javed,

Step 1 and 5 are both DDL, don't you agree?

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rollback not completed
Author: Philip Wisse, Netherlands
Date: Jul 12, 2017, 12:30, 128 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Moreover step 3 also DDL :-)

The command fails but the first commit cannot be undone.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rollback not completed
Author: javed akhtar, India
Date: Jul 12, 2017, 12:33, 128 days ago
Message: hello philip,


yes, i am agreed with you.

thanks a lot for your kind help.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here